Help using Base SAS procedures

Proc SQL in EG converts null numeric values to zero -- why?

Accepted Solution Solved
Reply
New Contributor
Posts: 4
Accepted Solution

Proc SQL in EG converts null numeric values to zero -- why?

Hello,

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).

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.


eg output -- notice 0 value in age column.pngbase sas output -- notice correct null value in age column.png
Attachment

Accepted Solutions
Solution
‎12-15-2014 10:27 AM
Super User
Super User
Posts: 7,392

Re: Proc SQL in EG converts null numeric values to zero -- why?

Well, don't know EG, however in Base you can do:

options missing=

and put whatever you want there.  So maybe in your setup you have options missing=0;

?

View solution in original post


All Replies
Solution
‎12-15-2014 10:27 AM
Super User
Super User
Posts: 7,392

Re: Proc SQL in EG converts null numeric values to zero -- why?

Well, don't know EG, however in Base you can do:

options missing=

and put whatever you want there.  So maybe in your setup you have options missing=0;

?

New Contributor
Posts: 4

Re: Proc SQL in EG converts null numeric values to zero -- why?

Thank you. I used the "options missing=." statement to fix the issue.

☑ This topic is SOLVED.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 585 views
  • 0 likes
  • 2 in conversation