creating one observation per detail record

[fatemeh]

Hello all,

My question is that why when i execute the bellow code it gives me no output and the log says ' DATA STEP stopped due to looping'? I attached the raw data file bellow. Appreciate for any help.

data people (drop=type);
infile 'C:\Users\myuser\Desktop\census.txt';
retain address ;
if type='H' then input @3 address $15. ;
if type='P';
input @3 name $10.   @13 age $3.  @16gender $1. ;
proc print data=people;
run;

[novinosrin · Accepted solution]

are you after something like this?

data people(drop=type) ;
infile 'C:\Users\NSRINIV2\Desktop\census.txt' truncover;
retain address ;
input type $ @;
if type='H' then input @2 address $15. ;
else if type='P' then input @3 name $10.   @13 age $3.  @16gender $1. ;
run;

[Tom]

Because you never executed the INPUT statement.

Your subsetting IF statement is testing the variable TYPE before it has be assigned any values. So TYPE='P' is always false and your data step never makes it past this line.