topic Re: Reading raw data from a text file in SAS Programming

Reading raw data from a text file

sanyam13 — Mon, 02 Jul 2018 16:28:22 GMT

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' .

Re: Reading raw data from a text file

Tom — Mon, 02 Jul 2018 16:49:52 GMT

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.

Re: Reading raw data from a text file

Cynthia_sas — Mon, 02 Jul 2018 17:19:46 GMT

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.

Just another possible approach.

Cynthia