Help using Base SAS procedures

Making one record from multiple

Reply
New Contributor
Posts: 3

Making one record from multiple

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.

Super Contributor
Posts: 1,636

Re: Making one record from multiple

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;

Ask a Question
Discussion stats
  • 1 reply
  • 148 views
  • 0 likes
  • 2 in conversation