63.PROC TRANSPOSE | PREFIX | NAME OPTION

                          PROC TRANSPOSE | PREFIX | NAME OPTION

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 THE ABOVE DATA::

EG1:

PROC TRANSPOSE DATA=NARROW OUT=NARROW_TRAN;

RUN;

LOG:

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

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

NOTE: PROCEDURE TRANSPOSE used (Total process time):

      real time           0.01 seconds

      cpu time            0.00 seconds

RESULT:HERE IT'S SHOWING ONLY POPULATION COUNT..

The SAS System

Obs	_NAME_	COL1	COL2	COL3	COL4
1	POPULATION	2	1	5	3

EG2:IN THIS SYNTAX ADDING ONE MORE OPTION PREFIX..

PROC TRANSPOSE DATA=NARROW OUT=NARROW_TRAN01 PREFIX=PET_COUNT;

RUN;

LOG:

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

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

NOTE: PROCEDURE TRANSPOSE used (Total process time):

      real time           0.01 seconds

      cpu time            0.00 seconds

RESULT:HERE IT'S SHOWING IN THE PLACE OF PREFIX SHOWING NAME = PET_NAME..

The SAS System

Obs	_NAME_	PET_COUNT1	PET_COUNT2	PET_COUNT3	PET_COUNT4
1	POPULATION	2	1	5	3

EG3:HERE WE ARE ADDING NAME OPTION TO GIVE NAME FOR THE VARIABLE..

PROC TRANSPOSE DATA=NARROW OUT=NARROW_TRAN02 

                          NAME=COL_TRANSPOSED PREFIX=PET_COUNT;

RUN;

LOG:

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

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

NOTE: PROCEDURE TRANSPOSE used (Total process time):

      real time           0.01 seconds

      cpu time            0.01 seconds

RESULT:HERE WE GIVEN _NAME_  = COL_TRANSPOSED ..

The SAS System

Obs	COL_TRANSPOSED	PET_COUNT1	PET_COUNT2	PET_COUNT3	PET_COUNT4
1	POPULATION	2	1	5	3

ANSWER THIS QUESTIONS IN COMMENT:

1.WHAT DID THE PREFIX OPTION DO?

2. WHAT DID THE NAME OPTION DO?

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