SAS Data Transformation - Interesting Question

Reply
Contributor
Posts: 35

SAS Data Transformation - Interesting Question

 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

 

Esteemed Advisor
Posts: 5,198

Re: SAS Data Transformation - Interesting Question

Don't post the same question in multiple forums.
Data never sleeps
Contributor
Posts: 35

Re: SAS Data Transformation - Interesting Question

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

Ask a Question
Discussion stats
  • 2 replies
  • 230 views
  • 1 like
  • 2 in conversation