SAS DI Studio: How to transpose rows to columns?

[Lunamachine]

Hello!

I have a problem using "Transpose" in SAS DI Studio 4.9. Is it possible in DI to transpose data from rows to columns?

My data is like this:

PatientID	Year	Hospital
Patient_A	2015	Hospital_1
Patient_A	2016	Hospital_2
Patient_A	2017	Hospital_3
Patient_B	2015	Hospital_3
Patient_B	2016	Hospital_1
Patient_B	2017	Hospital_1

and I would like to transpose the data to:

PatientID	2015	2016	2017
Patient_A	Hospital_1	Hospital_2	Hospital_3
Patient_B	Hospital_3	Hospital_1	Hospital_1

Is this possible in SAS DI Studio?

Best regards,
Lunamachine

[LinusH]

Possible? yes, good? Not so sure.
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.
Look for the Transpose (!) transformation.