proc import csv files with NaN in data

[mona]

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

[art297]

Mona,

If NaN are simply characters that are in some fields that are otherwise numeric, I think your easiest solution would be to grab the code that proc import creates and simply modify it so that you are reading the field(s) as characters.

I nice artice on that topic can be found at: http://www2.sas.com/proceedings/sugi30/038-30.pdf

The article contains step-by-step instructions for accomplishing such a task.  That will also get rid of the notes.

Art