topic Re: Proc SQL in EG converts null numeric values to zero -- why? in SAS Procedures https://communities.sas.com/t5/SAS-Procedures/Proc-SQL-in-EG-converts-null-numeric-values-to-zero-why/m-p/150766#M39726 <HTML><HEAD></HEAD><BODY><P>Well, don't know EG, however in Base you can do:</P><P>options missing=</P><P>and put whatever you want there.&nbsp; So maybe in your setup you have options missing=0;</P><P>?</P></BODY></HTML> Mon, 15 Dec 2014 15:27:20 GMT RW9 2014-12-15T15:27:20Z Proc SQL in EG converts null numeric values to zero -- why? https://communities.sas.com/t5/SAS-Procedures/Proc-SQL-in-EG-converts-null-numeric-values-to-zero-why/m-p/150765#M39725 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>I have run into an issue where proc sql converts null numeric values to 0. See attached code and screenshot below (specifically the "age" column).</P><P></P><P>This is only an issue in Enterprise Guide (Base SAS properly stores the null values as null values). How do I get Enterprise Guide to treat the null value as a null? Thanks.</P><BR /><IMG src="https://communities.sas.com/t5/image/serverpage/image-id/10679i11654BD071B2EFB4/image-size/large?v=1.0&amp;px=600" border="0" alt="eg output -- notice 0 value in age column.png" title="eg output -- notice 0 value in age column.png" /><IMG src="https://communities.sas.com/t5/image/serverpage/image-id/10680i1A157B11C1148070/image-size/large?v=1.0&amp;px=600" border="0" alt="base sas output -- notice correct null value in age column.png" title="base sas output -- notice correct null value in age column.png" /></BODY></HTML> Mon, 15 Dec 2014 15:25:11 GMT https://communities.sas.com/t5/SAS-Procedures/Proc-SQL-in-EG-converts-null-numeric-values-to-zero-why/m-p/150765#M39725 brownjd 2014-12-15T15:25:11Z Re: Proc SQL in EG converts null numeric values to zero -- why? https://communities.sas.com/t5/SAS-Procedures/Proc-SQL-in-EG-converts-null-numeric-values-to-zero-why/m-p/150766#M39726 <HTML><HEAD></HEAD><BODY><P>Well, don't know EG, however in Base you can do:</P><P>options missing=</P><P>and put whatever you want there.&nbsp; So maybe in your setup you have options missing=0;</P><P>?</P></BODY></HTML> Mon, 15 Dec 2014 15:27:20 GMT https://communities.sas.com/t5/SAS-Procedures/Proc-SQL-in-EG-converts-null-numeric-values-to-zero-why/m-p/150766#M39726 RW9 2014-12-15T15:27:20Z Re: Proc SQL in EG converts null numeric values to zero -- why? https://communities.sas.com/t5/SAS-Procedures/Proc-SQL-in-EG-converts-null-numeric-values-to-zero-why/m-p/150767#M39727 <HTML><HEAD></HEAD><BODY><P>Thank you. I used the "options missing=." statement to fix the issue.</P></BODY></HTML> Mon, 15 Dec 2014 15:44:07 GMT https://communities.sas.com/t5/SAS-Procedures/Proc-SQL-in-EG-converts-null-numeric-values-to-zero-why/m-p/150767#M39727 brownjd 2014-12-15T15:44:07Z