D/All,
SAS programs when executed on SAS 9.1.3 produces a null for all missing value when exported to CSV where as SAS 9.4 produces a period ( . ) for all the missing values in the dataset.
Is there a way to resolve this defect without changing the code. I have 5000+ source codes hence cannot take risk of updating all the codes.
Experts request your advice.
Thanks to everybody.. This forum & all experts are really awesome & helpful for almost any kind of issues we guys face.
Rgds, Anil
This is not a defect. Most likely your SAS 9.1.3 has the SAS MISSING option set and SAS 9.4 doesn't. Add the statement: OPTIONS MISSING = ''; to SAS 9.4.
Are you using PROC EXPORT or ODS or ???
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.
Need to connect to databases in SAS Viya? SAS’ David Ghan shows you two methods – via SAS/ACCESS LIBNAME and SAS Data Connector SASLIBS – in this video.
Find more tutorials on the SAS Users YouTube channel.