BookmarkSubscribeRSS Feed
GeorgeSAS
Lapis Lazuli | Level 10

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!

 

 

1 REPLY 1
Tom
Super User Tom
Super User

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;

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

What is Bayesian Analysis?

Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 1 reply
  • 729 views
  • 1 like
  • 2 in conversation