topic Re: How to do this question? in New SAS User

How to do this question?

Melody1027 — Tue, 24 Oct 2023 10:02:01 GMT

In the data file Exe2_Data11.txt, the field indicates contains a street address and a person who lives at that address, age and gender. Create a SAS data set that contains one
observation for each person who lives at a specific address. The finished SAS data set
looks like this:

Exe2_Data11.txt

30 Daguilar St
Mary Chan,21,F
David Chan,25,M
Man Chan,2,M
15 Fuk Hi St
William Leung,30,M
20 San Fat St
Walter Ma,25,M
John Ma,50,M
78 Stanley St

Re: How to do this question?

PeterClemmensen — Tue, 24 Oct 2023 10:06:59 GMT

Is your desired output a SAS data set or a .txt file?

Re: How to do this question?

Kurt_Bremser — Tue, 24 Oct 2023 10:08:22 GMT

This is in essence the same question as posted here:

https://communities.sas.com/t5/New-SAS-User/How-to-do-this-question-if-we-don-t-know-the-number-of-member-if/m-p/899712#M40064

Re: How to do this question?

Melody1027 — Tue, 24 Oct 2023 10:09:50 GMT

SAS data set

Re: How to do this question?

Kurt_Bremser — Tue, 24 Oct 2023 11:01:50 GMT

data want;
infile "path_to_your_file" dlm="," dsd truncover;
length
  address $100
  name $50
  age 8
  gender $1
;
retain address;
input @;
if countw(_infile_,",") > 1
then do;
  input name age gender;
  output;
end;
else input address $100.;
run;