Hi,
I was trying to import a csv data set using proc import. My csv file contains numbers and some NaNs.
However whenever there is a NaN in the first column of a row, SAS will issue a NOTE and write it as a missing value ' . '.
In this case, only the NaN in the first column are read as ' . ' and the rest NaN are NaN in the SAS output.
I wonder if there is way to have all NaN from the original file displayed uniformly as NaN or ' . '? Perhaps also have proc import stopping issue NOTE?
I would appreciate your help and comment.
Thank you.
Mona