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.
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;
?
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;
?
Thank you. I used the "options missing=." statement to fix the issue.
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.