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.
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;
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.