topic Re: How can I import excel data file or cvs file to SAS? in SAS Procedures

How can I import excel data file or cvs file to SAS?

Wendy13 — Tue, 07 Apr 2015 02:55:41 GMT

I have created spread sheet in excel and trying to import data file to SAS.

My program version is SAS94 and excel is 34 bit. I found out SAS94 requires excel data convert to cvs.

When I try to import cvs file using import wizard, I get following error message:

Unable to sample external file, no data in first 5 records.

ERROR: Import unsuccessful. See SAS Log for details.

What is it mean?

I do have some blank spaces in first 5 lines (which is missing values)

How can I import cvs. file into SAS? Please help me

Re: How can I import excel data file or cvs file to SAS?

Reeza — Tue, 07 Apr 2015 03:22:38 GMT

I found out SAS94 requires excel data convert to cvs.

I don't think that's true unless your licensing has changed.

Have you tried Proc Import to import the data, or a data step? You'll need to post either code or a sample file for more help.

Re: How can I import excel data file or cvs file to SAS?

Kurt_Bremser — Tue, 07 Apr 2015 06:20:41 GMT

You need to know the structure of the csv file, then you can write a suiting data step, which does not need any license beyond base at all. Ask for the documentation of the file; if there is none, return to sender.

Re: How can I import excel data file or cvs file to SAS?

Ksharp — Tue, 07 Apr 2015 12:38:02 GMT

add an option datarow=8 .