D/All,
I got my EG upgraded from 4.1 to 7.1 and presently I'm facing a weird issue with the proc export. The issue is -
I have a dataset with all variables as Character type. (Even the numeric variables are in character format - Thats the requirement and I cannot change it back to number format). Some of the variable observations are NULL. Now when this dataset is exported into CSV format thru SAS EG 4.1 everything is good. The NULL values appear as NULL in CSV file but when exported with SAS EG 7.1 these NULL values are replaced with a period symbol ( . )
I tried using options missing = ''; but that only works on number variable. What do I write so that these Character variable appears NULL in CSV.
Experts, request your advice.
Rgds,
AK
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.
Find more tutorials on the SAS Users YouTube channel.