Help using Base SAS procedures

How to infile this complex raw txt file

Reply
Regular Contributor
Posts: 204

How to infile this complex raw txt file

[ Edited ]

Hello all;

 

Can anyone tell me how to read a txt file with multiple column names combined in different record with data step?

the raw txt filelook like this:

 

var1 var2 var3 var4 var5

1 2 3 4 5

6 7 8 9 0

var1 var2 var3 var4 var5

11 12 13 14 15

16 17 18 19 10

var1 var2 var3 var4 var5

21 22 23 24 25

26 27 28 29 30

 

data need;

infile 'c:\rawdata.txt';

input var1 var2 var3 var4 var5;

run;

 

Thank you very much!

 

 

Super User
Super User
Posts: 6,500

Re: How to infile this complex raw txt file

Check the line before reading it so that you can eliminate the extra header rows.  You will need some way to tell which are the header rows to eliminate.  In your example they all start with the string 'var1'.

data need;
  infile 'c:\rawdata.txt';
  input @;
  if _infile_=: 'var1' then delete;
  input var1 var2 var3 var4 var5;
run;
Ask a Question
Discussion stats
  • 1 reply
  • 239 views
  • 1 like
  • 2 in conversation