Our Blogs

SAS Made Simple, SAS, SQL Martin Shine SAS Made Simple, SAS, SQL Martin Shine

SAS Made Simple: How to prevent rounding errors when using SAS’s Proc SQL

Join us as we look at how to prevent rounding errors when using SAS’s Proc SQL; leveraging the default formatting of the SELECT INTO statement. I recently encountered  some peculiar behaviour when using the “select into” function in SAS’s proc SQL. It was rounding very large numeric values in macro variables to the nearest 5 significant figures…

Read More