SAS Cloud Analytic Services – Transpose Tables in-Database

SAS Cloud Analytic Services is a good option if you need to transpose a table. In-database processing can greatly reduce data transfer time and network traffic. However, it is not always possible to transpose tables in-database. Here are some considerations to consider when deciding whether or not to use this option. In-database processing is not recommended for all data and business scenarios.

First, identify the variables that you want to transpose. For long to wide transpose, the ID variable determines column structure. In this case, the ID variable is not required. You can also specify multiple ID variables in the ID statement. Finally, you will need to specify which variables you want transposed with a VAR clause. Before you run the PROC TRANSPOSE command, you will need to sort the variables.

This task can be accomplished using the SAS help function transpose. The process is similar to that of transposing a long dataset. Both cases aim to reduce the number columns per subject and create a data structure that has multiple rows. It will not transpose missing variable. You should use SAS Help Proc when you’re unsure how to transpose a dataset.

PROC TRANSPOSE reshapes data. Each variable in the input data set will be represented by a single row in the output data set. You can also use this procedure to change variable names in the output data set. PROC PRINT and PROC REPORT are the best options for printing output. The TRANSPOSE procedure doesn’t produce printed output. It can however produce HTML or PDF output.

SAS Cloud Analytic Services – Transpose Tables in-Database
Scroll to top