INPUT statement inside IF statement in SAS Data step

[PoojaP1]

Hello,

Could anyone please explain how SAS processes the following code : 

Raw data file (Text file) data :

Ruth  39 11 (39 starts at Col7 and 11 at Col10)

Jose  32 22

Sue   30 33

John 40 44

DATA STEP :-

data new_1;
infile 'test1.txt';
INPUT EMPLOYEE_NAME $ 1-4;
If employee_name='Ruth' then input idnum 10-11;
else input age 7-8;
run;

OUTPUT :-

employee_name=Ruth idnum=22 age=. _ERROR_=0 _N_=1
employee_name=Sue idnum=. age=40 _ERROR_=0 _N_=2
NOTE: The data set WORK.new_1 has 2 observations and 3 variables.

I am not able to understand why SAS did not give output for Jose and John.

Thank you.

[Shmuel · Accepted solution]

Each INPUT statement, when it closed by semicolon (;), reads one line and is ready to read the following one.

In order to stay on same line and read more variables from it, you end the read statemnet by:  @;  like next code:

data want;

       infile datalines;

       input employee_name $ @;

      if employee_name = 'Ruth'

       then input idnum 10-11;
       else input age 7-8;

datalines;

Ruth  39 11 

Jose  32 22

Sue   30 33

John 40 44

; run;

[PoojaP1]

Thank you sir! That was a very nice explanation.