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
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
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.