topic creating one observation per detail record in SAS Programming

creating one observation per detail record

fatemeh — Sat, 07 Apr 2018 15:33:45 GMT

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;

Re: creating one observation per detail record

novinosrin — Sat, 07 Apr 2018 15:58:01 GMT

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;

Re: creating one observation per detail record

Tom — Sat, 07 Apr 2018 16:25:19 GMT

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.