18.PROC TRANSPOSE

                                                 PROC TRANSPOSE 

PROC TRANSPOSE:-

USED FOR DATA ROTATION/FLIPPING DATA/RE-STRUCTURING THE DATA

-OBSERVATIONS TO VARIABLES

-VARIABLES TO OBSERVATIONS

BY:: BY USING SORTED DATA WE CAN ALSO TRANSPOSE THE DATA

DATA TRANS;

INPUT NAME$ SUBJECT$ MARKS;

CARDS;

RAJU MATHS 52

SHIVA ENGLISH 56

MANEESHA ZOO 45

RAVLI ENGLISH 55

KUMAR BOTANY 65

REDDY MATHS 63

ANIL ZOO 56

RAM MATHS 54

;

RUN;

PROC SORT DATA=TRANS;

BY NAME;

RUN;

PROC TRANSPOSE DATA=TRANS OUT=TRANSPOSED;

BY NAME;

ID SUBJECT;

VAR MARKS;

RUN;

BY DEFAULT PROC TRANSPOSE WILL TRANSPOSE THE "ALL NUMERIC VARIABLES" IN THE DATASET 

PROC TRANSPOSE DATA=TRANS OUT=NOSTATEMENT PREFIX=STUDENT;

RUN;

SORT PROCEDURE IS NOT REQUIRED IF YOU ARE MENTIONED "NOTSORTED" OPTION IN "BY STATEMENT

PROC TRANSPOSE DATA=TRANS NAME=VNAME OUT=NOTSORTED;

BY NAME NOTSORTED;

ID SUBJECT;

VAR MARKS;

RUN;

PROC TRANSPOSE DATA=SASHELP.CLASS PREFIX=NAME_  SUFFIX=_STUDENT OUT=CLASS;

BY AGE NOTSORTED;

ID NAME;

VAR HEIGHT AGE WEIGHT;

RUN;

PROC TRANSPOSE DATA=SASHELP.CLASS OUT=CLASSTRA;

BY AGE NOTSORTED;

ID NAME;

VAR HEIGHT;

RUN;

--PLEASE FOLLOW THE BLOG TO GET MORE INFO...