65.PROC TRANSPOSE | ID AND VAR STATEMENT

                          PROC TRANSPOSE | ID AND VAR STATEMENT

  

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..

EG:

PROC TRANSPOSE DATA=NARROW OUT=NARROW_TRAN

                           NAME=COL_TRANSPOSED;

   VAR PET POPULATION;

   ID PET;

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_TRAN has 2 observations and 5 variables.

NOTE: PROCEDURE TRANSPOSE used (Total process time):

      real time           0.01 seconds

      cpu time            0.01 seconds

RESULT:

The SAS System

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

JUST VISIT THE PREVIOUS PROC TRANSPOSE IT WILL BE EASY TO UNDERSTAND AND PRACTICE...

QUESTIONS:

WHAT IS THE DIFFERENCE BETWEEN THIS OUTPUT AND PREVIOUS BLOG OUTPUT?

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