topic Re: SAS DI Studio: How to transpose rows to columns? in SAS Data Management https://communities.sas.com/t5/SAS-Data-Management/SAS-DI-Studio-How-to-transpose-rows-to-columns/m-p/399517#M12123 Possible? yes, good? Not so sure.<BR />This since you will dynamically create new columns. Perhaps if you create an end user table which is not be consumed using meta data registration directly. <BR />Look for the Transpose (!) transformation. <BR /> Thu, 28 Sep 2017 15:08:17 GMT LinusH 2017-09-28T15:08:17Z SAS DI Studio: How to transpose rows to columns? https://communities.sas.com/t5/SAS-Data-Management/SAS-DI-Studio-How-to-transpose-rows-to-columns/m-p/399433#M12118 <P>Hello!<BR /><BR />I have a problem using "Transpose" in SAS DI Studio 4.9. Is it possible in DI to transpose data from rows to columns?</P><P>&nbsp;</P><P>My data is like this:</P><P>&nbsp;</P><TABLE><TBODY><TR><TD>PatientID</TD><TD>Year</TD><TD>Hospital</TD></TR><TR><TD>Patient_A</TD><TD>2015</TD><TD>Hospital_1</TD></TR><TR><TD>Patient_A</TD><TD>2016</TD><TD>Hospital_2</TD></TR><TR><TD>Patient_A</TD><TD>2017</TD><TD>Hospital_3</TD></TR><TR><TD>Patient_B</TD><TD>2015</TD><TD>Hospital_3</TD></TR><TR><TD>Patient_B</TD><TD>2016</TD><TD>Hospital_1</TD></TR><TR><TD>Patient_B</TD><TD>2017</TD><TD>Hospital_1</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>and I would like to transpose the data to:</P><P>&nbsp;</P><TABLE><TBODY><TR><TD>PatientID</TD><TD>2015</TD><TD>2016</TD><TD>2017</TD></TR><TR><TD>Patient_A</TD><TD>Hospital_1</TD><TD>Hospital_2</TD><TD>Hospital_3</TD></TR><TR><TD>Patient_B</TD><TD>Hospital_3</TD><TD>Hospital_1</TD><TD>Hospital_1</TD></TR></TBODY></TABLE><P><BR />Is this possible in SAS DI Studio?<BR /><BR />Best regards,<BR />Lunamachine</P> Thu, 28 Sep 2017 08:50:57 GMT https://communities.sas.com/t5/SAS-Data-Management/SAS-DI-Studio-How-to-transpose-rows-to-columns/m-p/399433#M12118 Lunamachine 2017-09-28T08:50:57Z Re: SAS DI Studio: How to transpose rows to columns? https://communities.sas.com/t5/SAS-Data-Management/SAS-DI-Studio-How-to-transpose-rows-to-columns/m-p/399517#M12123 Possible? yes, good? Not so sure.<BR />This since you will dynamically create new columns. Perhaps if you create an end user table which is not be consumed using meta data registration directly. <BR />Look for the Transpose (!) transformation. <BR /> Thu, 28 Sep 2017 15:08:17 GMT https://communities.sas.com/t5/SAS-Data-Management/SAS-DI-Studio-How-to-transpose-rows-to-columns/m-p/399517#M12123 LinusH 2017-09-28T15:08:17Z