DATA Step, Macro, Functions and more

Reading raw data from a text file

Reply
Occasional Contributor
Posts: 7

Reading raw data from a text file

Ruth 39 11

jose  32 22

sue   30 33

john  40 44

 

data test;

infile 'employee';

input emp_name $1-4 ;

if emp_name = 'sue' then input age 7-8;

else input idnum 10-11;

run;

 

can you plz explain why i am getting 40 as value for age when name of the employee is 'sue' .

Super User
Super User
Posts: 8,069

Re: Reading raw data from a text file

The first INPUT statement reads one line. The second INPUT statement will read from the next line.

If you want to continue reading from the same line you need to add a trailing @ sign to the first INPUT statement so that SAS will stay on the current line.

 

SAS Super FREQ
Posts: 9,365

Re: Reading raw data from a text file

Hi:

  In addition to Tom's suggestion, if you took a slightly different approach, using simple list input (since the values are delimited by spaces) you don't need a conditional INPUT statement.

revise_datalines.png 

Just another possible approach.

 

Cynthia

Ask a Question
Discussion stats
  • 2 replies
  • 80 views
  • 0 likes
  • 3 in conversation