how to reader header from rawdata

[ericykc]

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
D135EG023456789,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

It consists of a header record for a household and is immediately followed by one record (row) for each household member, if applicable. For example, a household of three members will have three records exactly after its header record. How can i read the header only

[Kurt_Bremser · Accepted solution]

data want;
infile "path_to_your_file" dsd;
input household :$15. type :$1.;
if "A" le substr(household,1,1) le "Z";
run;

[ericykc]

thanks for helping me on pervious question. May I ask that how to let the programme know how many record under the Header? Thank a lot!

[mkeintz]

---

@ericykc wrote:

thanks for helping me on pervious question. May I ask that how to let the programme know how many record under the Header? Thank a lot!

---

You should probably start a new thread:  "how to read a hierarchical file, with household ID and number of household members".