Making one record from multiple

dan1775 — Wed, 31 Oct 2012 02:00:52 GMT

Hello,

New SAS user here.

I have a data set of medical enrollment that shows the member id, their primary care provider, and the to and from dates that the member was enrolled with that provider, thus:

member_id pcp_id from_date to_date

12345 ABCD MMYYDD1 MMYYDD2

12345 EFGH MMYYDD3 MMYYDD4

67890 WXYZ MMYYDD5 MMYYDD6

The issue is that I want output like this:

member_id pcp_id1 from_date1 to_date1 pcp_id2 from_date2 to_date2

12345 ABCD MMYYDD1 MMYYDD2 EFGH MMYYDD3 MMYYDD4

67890 WXYZ MMYYDD5 MMYYDD6

So, in English I want to have a single record for each member, that lists all that members PCPs and the corresponding dates. I've done my research, but nothing I try works. I've actually used an array to go the other way on this operation, although only with a single variable.

Any help would be appreciated.

Re: Making one record from multiple

Linlin — Wed, 31 Oct 2012 02:11:54 GMT

proc summary nway data=your_dataset missing;

class member_ID;

output

out = work.wide(drop=_type_ _freq_)

idgroup(out[2](pcp_id from_date do_date)=)

;

run;

topic Making one record from multiple in SAS Procedures

Making one record from multiple

Re: Making one record from multiple