topic how to reader header from rawdata in SAS Programming

how to reader header from rawdata

ericykc — Sun, 29 Oct 2023 11:00:13 GMT

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

Re: how to reader header from rawdata

Kurt_Bremser — Sun, 29 Oct 2023 13:22:07 GMT

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

Re: how to reader header from rawdata

ericykc — Sun, 29 Oct 2023 14:13:13 GMT

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!

Re: how to reader header from rawdata

mkeintz — Sun, 29 Oct 2023 17:51:31 GMT

@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".