topic Re: Getting variable information from one row to another if ID is the same in New SAS User

Getting variable information from one row to another if ID is the same

sas1011 — Thu, 05 Dec 2019 20:25:26 GMT

Hello,

I have a data set that has clinical member information with discharge dates for each member. This dataset also has the same member(identified by the member_id) that have multiple rows with different discharge dates if they were re-admitted.

I want to be able to get one row for each member ID with a new column(s) for the different discharge dates.

Sample data(HAVE):

Member_ID Discharge_date Hospital

1 11/20/2019 ABC

1 12/03/2019 ABC

2 11/22/2019 XYZ

3 11/20/2019 ABC

4 10/30/2019 JKL

4 11/15/2019 JKL

Result(NEED):

Member_ID Discharge_date Discharge_date2 Hospital

1 11/20/2019 12/03/2019 ABC

2 11/22/2019 . XYZ

3 11/20/2019 . ABC

4 10/30/2019 11/15/2019 JKL

I'm not able to wrap my mind around how to get this done.

It sounds like it might be an easy solution for some of the experts in this community.

Thanks for the help.

Re: Getting variable information from one row to another if ID is the same

novinosrin — Thu, 05 Dec 2019 20:47:13 GMT



data have;
input Member_ID                               Discharge_date  :mmddyy10.                          Hospital $;
format Discharge_date mmddyy10.;
cards;
1                                                  11/20/2019                                            ABC
1                                                  12/03/2019                                            ABC
2                                                  11/22/2019                                            XYZ
3                                                  11/20/2019                                            ABC
4                                                  10/30/2019                                            JKL
4                                                  11/15/2019                                            JKL
;

proc transpose data=have out=want(drop=_name_) prefix=Discharge_date;
by member_id hospital;
var Discharge_date;
run;

Re: Getting variable information from one row to another if ID is the same

sas1011 — Thu, 05 Dec 2019 21:05:42 GMT

Thank you. This worked.

I never used proc transpose until now - thats why it never occured to me.

Thanks