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 |
|
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...
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.