HintsMaster | Sep 8, 2018 | 0
SAS Proc Transpose- How to make your Columns as Rows
It is one of the most versatile SAS proc. If you know Proc Transpose you can do wonders( To Make a Values in column as separate columns in table, to make various columns as Rows of Table or Vice-Versa).
first go through this link and be ready for fun.
A Sample code:-
create table xyz as
SELECT distinct catx (‘ ‘,Make , Model) as Intro , Type , Origin , EngineSize ,
Cylinders, Length FROM SASHELP.CARS
group by type
order by type,Intro;
proc transpose data=xyz out=xyzt;
Cylinders Length ;