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.
... View more