topic Re: use first row as name and start the data from third row in proc import function in SAS Programming

use first row as name and start the data from third row in proc import function

nazmul — Sun, 10 Jun 2018 06:58:30 GMT

Dear Everyone,

I am importing text file to SAS format. I want to use first row as name and start the data from third row. I am using the following code. It is not happening:

proc import datafile='H:\Seminar Class\Banking Seminar\Data by me\Bank Call Report\FFIEC data\FFIEC CDR Call Bulk All Schedules 03312011/FFIEC CDR Call Bulk POR 03312011.txt'
out=POR0311 dbms=dlm replace;
datarow=2; delimiter='09'x;
run;

Re: use first row as name and start the data from third row in proc import function

Kurt_Bremser — Sun, 10 Jun 2018 16:21:19 GMT

Post the log. Anytime something "does not work", post the log. Use the {i} button to preserve formatting.

Re: use first row as name and start the data from third row in proc import function

pau13rown — Sun, 10 Jun 2018 22:16:37 GMT

it says 'datarow=2', but you want to start at row 3. Usually it is not recommended to modify the data source but why not just remove the 2nd row from the txt file and run the code again?

Re: use first row as name and start the data from third row in proc import function

Patrick — Mon, 11 Jun 2018 01:40:39 GMT

@nazmul

If you want to read the data starting in row 3 then instruct SAS to do so by setting datarow=3

proc import datafile='c:\temp\test.txt'
  out=POR0311 
  dbms=dlm replace;
  datarow=3
  ;
  delimiter='09'x;
  getnames=yes;
  guessingrows=max;
run;

If Proc Import can't fully do what you need then you can also always copy/paste the generated data step from the log into a code window and then amend this data step as you need it. This gives you full flexibility.

Re: use first row as name and start the data from third row in proc import function

nazmul — Mon, 11 Jun 2018 05:03:09 GMT

Thank you Patrick. Your code was really helpful for me 😄