64.PROC TRANSPOSE | ID | VAR STATEMENTS

                           PROC TRANSPOSE | ID | VAR STATEMENTS

DATA USED IN THIS PROGRAM:

DATA NARROW;

 INPUT PET_OWNER$10. PET$ POPULATION;

 CARDS;

 MR.BLACK  DOG 2

 MR.BLACK  BIRD 1

 MRS.GREEN  FISH 5

 MR.WHITE  CAT 3

 ;

RUN;

PROC PRINT;RUN;

LOG:

NOTE: The data set WORK.NARROW has 4 observations and 3 variables.

NOTE: DATA statement used (Total process time):

      real time           0.01 seconds

      cpu time            0.01 seconds

RESULT:

The SAS System

Obs	PET_OWNER	PET	POPULATION
1	MR.BLACK	DOG	2
2	MR.BLACK	BIRD	1
3	MRS.GREEN	FISH	5
4	MR.WHITE	CAT	3

HERE I WANT TO TRANSPOSE ABOVE SYNTAX..

EG1:

PROC TRANSPOSE DATA=NARROW OUT=NARROW_TRAN03

                           NAME=COL_TRANSPOSED;

   ID PET;

RUN;

PROC PRINT;RUN;

LOG:

NOTE: There were 4 observations read from the data set WORK.NARROW.

NOTE: The data set WORK.NARROW_TRAN03 has 1 observations and 5 variables.

NOTE: PROCEDURE TRANSPOSE used (Total process time):

      real time           0.10 seconds

      cpu time            0.01 seconds

RESULT:HERE WE GOT NAMES OF ANIMALS COMPARE TO BEFORE BLOG 

                VISIT THAT  BLOG AND KNOW MORE ABOUT SAS TRANSPOSE

The SAS System

Obs	COL_TRANSPOSED	DOG	BIRD	FISH	CAT
1	POPULATION	2	1	5	3

EG2:

PROC TRANSPOSE DATA=NARROW OUT=NARROW_TRAN04

                                                                 NAME=COL_TRANSPOSED;

   VAR PET POPULATION;

RUN;

PROC PRINT;RUN;

LOG:

NOTE: Numeric variables in the input data set will be converted to character in the output data set.

NOTE: There were 4 observations read from the data set WORK.NARROW.

NOTE: The data set WORK.NARROW_TRAN04 has 2 observations and 5 variables.

NOTE: PROCEDURE TRANSPOSE used (Total process time):

      real time           0.07 seconds

      cpu time            0.00 seconds

RESULT:HERE WE GOT NAMES OF ANIMALS AS OBSERVATIONS COMPARE TO ABOVE                       RESULT   AND WE GOT VARIABLES AS COL1-COL4

                VISIT THAT  BLOG AND KNOW MORE ABOUT SAS TRANSPOSE

The SAS System

Obs	COL_TRANSPOSED	COL1	COL2	COL3	COL4
1	PET	DOG	BIRD	FISH	CAT
2	POPULATION	2	1	5	3

QUESTIONS TO YOU :

1.WHAT IS ID STATEMENT DO?

2.WHY WAS PREFIX OPTION NOT NEEDED HERE?

3.TRANSPOSE TRANSPOSES NUMERIC VARS BY DEFAULT, WHY WAS A NUMERIC AND A CHARACTER VARIABLE TRANSPOSED HERE?

TRY THIS AND COMMENT ...

-->PLEASE READ AND COMMENT THE BLOG...

--PLEASE FOLLOW THE BLOG FOR MORE UPDATES...

--FOLLOW US IN FACEBOOK SASALL4YOU AND JOIN ...

--JOIN US IN FACEBOOK AND TELEGRAM  CHANNEL FOR MORE UPDATES

   CLICK HERE: https://t.me/SasAll4You