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 ???
April 27 – 30 | Gaylord Texan | Grapevine, Texas
Walk in ready to learn. Walk out ready to deliver. This is the data and AI conference you can't afford to miss.
Register now and lock in 2025 pricing—just $495!
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.