Header record of a household: Household identity: 10-15 characters, always begin with an alphabetical letter in uppercase, such as A, B, etc. Type of housing: Character ‘A’ for private, and ‘B’ for public Household member’s record (if present): Date of birth :10-11 characters in the form dd/mon/yyyy where dd is the day value which may be in the form of 1 or 2 digits. Householder indicator: Character ‘Y’ for yes, and ‘N’ for no. Gender : Characters of ‘Female’, or ‘Male’. Marital status : Characters of ‘Married’, ‘Single’, ‘Divorced’, or ‘Unknown’ . Achieved education level : Standard numeric with 0 for none, 1 for primary, 2 for secondary, 3 for tertiary. Employment status: Characters of ‘FT’, ‘PT’, ‘UE’, or ‘NA’ . Monthly income : Standard numeric. 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 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 Write a DATA step that will perform the following activities: • Create a SAS data set named Members. Members must be stored in the Work library of SAS Studio. • Read the records from Survey.txt into Members. • Create only one observation for each household in Survey.txt. • Each created observation in Members must contain only these variables but not necessarily in the given order: o The identity of the respective household o The type of housing of the respective household o The number of members in the household (0 for a household without members) o The number of male members(0 for a household without members) o The maximum achieved education level among all members in the household (0 for a household without members) o The total monthly income of the household (0 for a household without members) o The number of members in the household is at least 18 years old as of 1 January 2023 (0 for a household without members) {Hint: Use function INTCK to compute
... View more
