I got a hierarchical data file:   I want to generate one observation per detail record and my code is:   data Household; infile datalines dlm=','; input Household_ID : $15. Type$; input DOB : date11. Indicator$ Gender$ Marital_Status$ Education Employment_Status$ Income$; Second_field=scan(_infile_,2,','); Do while (Second_field ='Y'or'N'); output; input DOB--Income; end; datalines; A1234567BC012,A 15/FEB/1980,Y,Male,Married,3,FT,55000 3/JUN/1982,N,Female,Married,3,UE,0 24/JAN/2005,N,Male,Unknown,2,NA,0 D135EG0234678,B 19/OCT/1950,Y,Female,Divorced,0,PT,5000 X123A567F9,A B2345234CC,A 21/May/1975,N,Male,Married,2,FT,30000 30/JUN/1978,Y,Female,Married,1,PT,10000 ; run;   But my output is like this: How could I generate one observation per detail record? ... View more