O'Reilly logo

Data Preparation for Analytics Using SAS by Gerhard Svolba

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Appendix C

Transposing with DATA Steps

 

C.1 Transposing and Performance

C.2  From a LONG Data Set to a WIDE Data Set

C.3  From a WIDE Data Set to a LONG Data Set

C.4  Transposing Transactional Categories with a DATA Step

 

C.1 Transposing and Performance

General

We saw in Chapter 14 that the TRANSPOSE procedure can be used to transpose data in a very flexible way and with a clear syntax. PROC TRANSPOSE and the macros we presented in Chapter 14 are the first choice for data transpositions.

However, in situations where the number of subjects is in the hundreds of thousands, and the number of variables or repetitions is in the thousands, performance issues might arise. In these cases it is advisable to use a SAS DATA step instead of PROC TRANPOSE. ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required