topic Re: Proc import csv specify a row for headers and a row for the first observation in SAS Programming

Proc import csv specify a row for headers and a row for the first observation

Sir_Highbury — Tue, 05 Apr 2016 14:37:17 GMT

Dear SAS experts,

which ist the easiest way to import a csv specifying:

- in wich row are the headers

- in which row start the data

I tried in several ways (dataeow, firstobs...) But I do not gest what i want.

for instance:

proc import datafile='test.csv'

datarow=3; getnames=yes;

run;

Attached an example of the csv input and the data that I would like to get in SAS.

Re: Proc import csv specify a row for headers and a row for the first observation

ballardw — Tue, 05 Apr 2016 14:45:21 GMT

Reading variable names from the CSV requires that the name be on a single row. Easiest is to Edit the CSV to remove the entire first line with the column headers like "Platin/EURO".

Then datarow=2 should work fine.

Re: Proc import csv specify a row for headers and a row for the first observation

Sir_Highbury — Tue, 05 Apr 2016 15:19:34 GMT

Hi ballardw,

thank but this is what I am currently doing and I would not.

So means that SAS cannot do it?

Re: Proc import csv specify a row for headers and a row for the first observation

data_null__ — Tue, 05 Apr 2016 15:30:50 GMT

Use a data step to write a new copy of the file with the record(s) edited as you see fit. Then run your PROC IMPORT on that.

Re: Proc import csv specify a row for headers and a row for the first observation

ballardw — Tue, 05 Apr 2016 15:47:56 GMT

@Sir_Highbury wrote:

Hi ballardw,

thank but this is what I am currently doing and I would not.

So means that SAS cannot do it?

Show the exact code you run, the Log results and show the data as a TXT file not Excel (it may change values with out telling you).

You should always use a fully qualified path to point to input and out file locations : datafile = "C:\somefolder\otherfolder\inputfile.csv" for example instead of datafile="test.csv" as the later is going to read from what SAS considers the current active folder and is very likely not the location you expect.

Re: Proc import csv specify a row for headers and a row for the first observation

Tom — Tue, 05 Apr 2016 15:52:32 GMT

For a file with three variable just write the data step yourself. Probably will take less code than the the PROC IMPORT statements.

data want ;
   infile "myfile.csv" dsd firstobs=3 truncover ;
   length date field1 field2 8 ;
   informat date mmddyy10.;
   format date yymmdd10.;
   input date field1 field2;
run;