topic Re: proc import wizard problem... in SAS Programming

proc import wizard problem...

belboy — Sat, 10 Mar 2018 19:02:22 GMT

HI,

I'm using the import wizard with SAS to import a MS Excel CSV file. The problem is that SAS imports the entire file as a header with no observations.

For example,

SAS shows a 10 variable dataset with 0 observations:

RSID FULLNAME Priv Date EMAIL Ugkdd10 Jason Thomas DBA 2008 jt@hotmail.com

I need SAS to show me a 5 variable dataset with 1 observation:

RSID, FULLNAME, Priv, Date, EMAIL

Ugkdd10 Jason Thomas DBA 2008 jt@hotmail.com

I couldn't find any documentation of how to do this. Maybe proc transpose with some other formula?

Do I need to figure out a way to recreate the dataset with SAS code (i.e., SCAN, SUBSTR, etc)?

Any help is very much appreciated.

Re: proc import wizard problem...

Tom — Sat, 10 Mar 2018 19:28:05 GMT

I bet you are using Excel on a MAC?

Excel is too stupid to understand that Mac's are now using Unix and that text files should use linefeed as the end of line marker and not carriage return.

Either use the SAVE AS feature and pick a different file format that uses the right end of line markers.

Or tell SAS that the end of line marker is CR.

filename mycsv 'filename' termstr=cr;

Re: proc import wizard problem...

belboy — Sat, 10 Mar 2018 19:43:26 GMT

Nah, not a Mac. Using proc import wizard via Windows PC.

Re: proc import wizard problem...

SASKiwi — Sat, 10 Mar 2018 21:46:37 GMT

Try another FILE SAVE AS CSV making sure you just choose the plain CSV option and not CSV (MAC).

Re: proc import wizard problem...

SuryaKiran — Sat, 10 Mar 2018 21:59:05 GMT

Make sure you saved the right CSV file. If you save your file as CSV(Macintosh) and try to import it into SAS then you will have the records in a single line.

@Tom You maybe right they maybe saved as Mac files.

Re: proc import wizard problem...

Cynthia_sas — Sun, 11 Mar 2018 02:09:20 GMT

Hi:

One possible solution has also been posted here: https://communities.sas.com/t5/SAS-Procedures/SAS-import-entire-file-as-a-header-how-do-I-resolve/m-p/444445#M69382 in your other posting on the same question.

Cynthia