topic SAS Data Transformation - Interesting Question in SAS Programming https://communities.sas.com/t5/SAS-Programming/SAS-Data-Transformation-Interesting-Question/m-p/247066#M309405 <P>&nbsp;I want to transform data that looks like as below:</P> <P>and has following fields :--&gt; patid, date on which a medical team was added/removed, type of team , and action</P> <P>Input data --à</P> <TABLE width="236"> <TBODY> <TR> <TD width="39"> <P>patid</P> </TD> <TD width="78"> <P>date</P> </TD> <TD width="56"> <P>Team</P> </TD> <TD width="63"> <P>action</P> </TD> </TR> <TR> <TD> <P>1111</P> </TD> <TD> <P>jan-25-2016</P> </TD> <TD> <P>medical</P> </TD> <TD> <P>added</P> </TD> </TR> <TR> <TD> <P>1111</P> </TD> <TD> <P>jan-27-2016</P> </TD> <TD> <P>surgical</P> </TD> <TD> <P>added</P> </TD> </TR> <TR> <TD> <P>1111</P> </TD> <TD> <P>29-Jan</P> </TD> <TD> <P>medical</P> </TD> <TD> <P>removed</P> </TD> </TR> <TR> <TD> <P>1111</P> </TD> <TD> <P>31-Jan</P> </TD> <TD> <P>obgyn</P> </TD> <TD> <P>added</P> </TD> </TR> </TBODY> </TABLE> <P>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</P> <P>them as below...what is the most efficient way to do this in sas base /sas ??Any help will be highly&nbsp;appreciated...</P> <P>Thanks guys</P> <P>Output Data --à</P> <TABLE width="300"> <TBODY> <TR> <TD width="38"> <P>patid</P> </TD> <TD width="74"> <P>date</P> </TD> <TD width="54"> <P>team1</P> </TD> <TD width="61"> <P>team2</P> </TD> <TD width="61"> <P>team3</P> </TD> </TR> <TR> <TD> <P>1111</P> </TD> <TD> <P>jan-25-2016</P> </TD> <TD> <P>medical</P> </TD> <TD> <P>&nbsp;</P> </TD> <TD> <P>&nbsp;</P> </TD> </TR> <TR> <TD> <P>1111</P> </TD> <TD> <P>26-Jan</P> </TD> <TD> <P>medical</P> </TD> <TD> <P>&nbsp;</P> </TD> <TD> <P>&nbsp;</P> </TD> </TR> <TR> <TD> <P>1111</P> </TD> <TD> <P>27-Jan</P> </TD> <TD> <P>medical</P> </TD> <TD> <P>surgical</P> </TD> <TD> <P>&nbsp;</P> </TD> </TR> <TR> <TD> <P>1111</P> </TD> <TD> <P>28-Jan</P> </TD> <TD> <P>medical</P> </TD> <TD> <P>surgical</P> </TD> <TD> <P>&nbsp;</P> </TD> </TR> <TR> <TD> <P>1111</P> </TD> <TD> <P>29-Jan</P> </TD> <TD> <P>surgical</P> </TD> <TD> <P>&nbsp;</P> </TD> <TD> <P>&nbsp;</P> </TD> </TR> <TR> <TD> <P>1111</P> </TD> <TD> <P>30-Jan</P> </TD> <TD> <P>surgical</P> </TD> <TD> <P>obgyn</P> </TD> <TD> <P>&nbsp;</P> </TD> </TR> </TBODY> </TABLE> Sat, 30 Jan 2016 22:47:32 GMT Arora_S 2016-01-30T22:47:32Z SAS Data Transformation - Interesting Question https://communities.sas.com/t5/SAS-Programming/SAS-Data-Transformation-Interesting-Question/m-p/247066#M309405 <P>&nbsp;I want to transform data that looks like as below:</P> <P>and has following fields :--&gt; patid, date on which a medical team was added/removed, type of team , and action</P> <P>Input data --à</P> <TABLE width="236"> <TBODY> <TR> <TD width="39"> <P>patid</P> </TD> <TD width="78"> <P>date</P> </TD> <TD width="56"> <P>Team</P> </TD> <TD width="63"> <P>action</P> </TD> </TR> <TR> <TD> <P>1111</P> </TD> <TD> <P>jan-25-2016</P> </TD> <TD> <P>medical</P> </TD> <TD> <P>added</P> </TD> </TR> <TR> <TD> <P>1111</P> </TD> <TD> <P>jan-27-2016</P> </TD> <TD> <P>surgical</P> </TD> <TD> <P>added</P> </TD> </TR> <TR> <TD> <P>1111</P> </TD> <TD> <P>29-Jan</P> </TD> <TD> <P>medical</P> </TD> <TD> <P>removed</P> </TD> </TR> <TR> <TD> <P>1111</P> </TD> <TD> <P>31-Jan</P> </TD> <TD> <P>obgyn</P> </TD> <TD> <P>added</P> </TD> </TR> </TBODY> </TABLE> <P>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</P> <P>them as below...what is the most efficient way to do this in sas base /sas ??Any help will be highly&nbsp;appreciated...</P> <P>Thanks guys</P> <P>Output Data --à</P> <TABLE width="300"> <TBODY> <TR> <TD width="38"> <P>patid</P> </TD> <TD width="74"> <P>date</P> </TD> <TD width="54"> <P>team1</P> </TD> <TD width="61"> <P>team2</P> </TD> <TD width="61"> <P>team3</P> </TD> </TR> <TR> <TD> <P>1111</P> </TD> <TD> <P>jan-25-2016</P> </TD> <TD> <P>medical</P> </TD> <TD> <P>&nbsp;</P> </TD> <TD> <P>&nbsp;</P> </TD> </TR> <TR> <TD> <P>1111</P> </TD> <TD> <P>26-Jan</P> </TD> <TD> <P>medical</P> </TD> <TD> <P>&nbsp;</P> </TD> <TD> <P>&nbsp;</P> </TD> </TR> <TR> <TD> <P>1111</P> </TD> <TD> <P>27-Jan</P> </TD> <TD> <P>medical</P> </TD> <TD> <P>surgical</P> </TD> <TD> <P>&nbsp;</P> </TD> </TR> <TR> <TD> <P>1111</P> </TD> <TD> <P>28-Jan</P> </TD> <TD> <P>medical</P> </TD> <TD> <P>surgical</P> </TD> <TD> <P>&nbsp;</P> </TD> </TR> <TR> <TD> <P>1111</P> </TD> <TD> <P>29-Jan</P> </TD> <TD> <P>surgical</P> </TD> <TD> <P>&nbsp;</P> </TD> <TD> <P>&nbsp;</P> </TD> </TR> <TR> <TD> <P>1111</P> </TD> <TD> <P>30-Jan</P> </TD> <TD> <P>surgical</P> </TD> <TD> <P>obgyn</P> </TD> <TD> <P>&nbsp;</P> </TD> </TR> </TBODY> </TABLE> Sat, 30 Jan 2016 22:47:32 GMT https://communities.sas.com/t5/SAS-Programming/SAS-Data-Transformation-Interesting-Question/m-p/247066#M309405 Arora_S 2016-01-30T22:47:32Z Re: SAS Data Transformation - Interesting Question https://communities.sas.com/t5/SAS-Programming/SAS-Data-Transformation-Interesting-Question/m-p/247109#M309406 Don't post the same question in multiple forums. Sun, 31 Jan 2016 14:34:43 GMT https://communities.sas.com/t5/SAS-Programming/SAS-Data-Transformation-Interesting-Question/m-p/247109#M309406 LinusH 2016-01-31T14:34:43Z Re: SAS Data Transformation - Interesting Question https://communities.sas.com/t5/SAS-Programming/SAS-Data-Transformation-Interesting-Question/m-p/247143#M309407 <P>Sure, I was not sure which category will be the correct to post , will avoid any duplicate submissions in future,</P> <P>Thanks For bringing this up...</P> Sun, 31 Jan 2016 23:42:51 GMT https://communities.sas.com/t5/SAS-Programming/SAS-Data-Transformation-Interesting-Question/m-p/247143#M309407 Arora_S 2016-01-31T23:42:51Z