SAS Data Transformation - Interesting Question

[Arora_S]

 I want to transform data that looks like as below:

and has following fields :--> patid, date on which a medical team was added/removed, type of team , and action

Input data --à

patid	date	Team	action
1111	jan-25-2016	medical	added
1111	jan-27-2016	surgical	added
1111	29-Jan	medical	removed
1111	31-Jan	obgyn	added

The output that i need should be in this way: so for each date i have the team in one row and for missing dates i can populate

them as below...what is the most efficient way to do this in sas base /sas ??Any help will be highly appreciated...

Thanks guys

Output Data --à

patid	date	team1	team2	team3
1111	jan-25-2016	medical
1111	26-Jan	medical
1111	27-Jan	medical	surgical
1111	28-Jan	medical	surgical
1111	29-Jan	surgical
1111	30-Jan	surgical	obgyn

[LinusH]

Don't post the same question in multiple forums.

[Arora_S]

Sure, I was not sure which category will be the correct to post , will avoid any duplicate submissions in future,

Thanks For bringing this up...