SAS Data Integration Studio, DataFlux Data Management Studio, SAS/ACCESS, SAS Data Loader for Hadoop and others

SAS DI Studio: How to transpose rows to columns?

Reply
Senior User
Posts: 1

SAS DI Studio: How to transpose rows to columns?

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:

 

PatientIDYearHospital
Patient_A2015Hospital_1
Patient_A2016Hospital_2
Patient_A2017Hospital_3
Patient_B2015Hospital_3
Patient_B2016Hospital_1
Patient_B2017Hospital_1

 

and I would like to transpose the data to:

 

PatientID201520162017
Patient_AHospital_1Hospital_2Hospital_3
Patient_BHospital_3Hospital_1Hospital_1


Is this possible in SAS DI Studio?

Best regards,
Lunamachine

Super User
Posts: 5,543

Re: SAS DI Studio: How to transpose rows to columns?

Posted in reply to Lunamachine
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.
Data never sleeps
Ask a Question
Discussion stats
  • 1 reply
  • 175 views
  • 1 like
  • 2 in conversation