09-08-2015 08:39 PM
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.
09-08-2015 08:56 PM