67. WIDE FILE TRANSPOSE | USING ID STATEMENT

                            WIDE FILE TRANSPOSE | USING ID STATEMENT

                             

DATA TO TRANSPOSE:

DATA FILE;

 INFILE CARDS MISSOVER;

 INPUT PET_OWNER $10. CAT DOG FISH BIRD;

 CARDS;

Mr. Black   1 2 . 0 

Mrs. Brown 0 1 0 1 

Mrs. Green . 0 5 

Mr. White 3 1 7 2 

; 

RUN;

PROC PRINT;

RUN;

LOG:

NOTE: The data set WORK.FILE has 4 observations and 5 variables.

NOTE: DATA statement used (Total process time):

      real time           0.03 seconds

      cpu time            0.00 seconds

RESULT:

                               

The SAS System

Obs	PET_OWNER	CAT	DOG	FISH	BIRD
1	Mr. Black	1	2	.	0
2	Mrs. Brown	0	1	0	1
3	Mrs. Green	.	0	5	.
4	Mr. White	3	1	7	2

SIMPLE TRANSPOSE:

PROC TRANSPOSE DATA=FILE OUT=TRANSFILE;

RUN;

LOG:

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

NOTE: The data set WORK.TRANSFILE has 4 observations and 5 variables.

NOTE: PROCEDURE TRANSPOSE used (Total process time):

      real time           0.12 seconds

      cpu time            0.01 seconds

RESULT:

The SAS System

Obs	_NAME_	COL1	COL2	COL3	COL4
1	CAT	1	0	.	3
2	DOG	2	1	0	1
3	FISH	.	0	5	7
4	BIRD	0	1	.	2

NAME AND PREFIX:

PROC TRANSPOSE DATA=FILE OUT=TRANSFILE1

                                                  NAME=COL_TRANSPOSED

PREFIX=PET_COUNT;

RUN;

LOG:

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

NOTE: The data set WORK.TRANSFILE1 has 4 observations and 5 variables.

NOTE: PROCEDURE TRANSPOSE used (Total process time):

      real time           0.09 seconds

      cpu time            0.03 seconds

RESULT:

The SAS System

Obs	COL_TRANSPOSED	PET_COUNT1	PET_COUNT2	PET_COUNT3	PET_COUNT4
1	CAT	1	0	.	3
2	DOG	2	1	0	1
3	FISH	.	0	5	7
4	BIRD	0	1	.	2

ID STATEMENT:

PROC TRANSPOSE DATA=FILE OUT=TRANSFILE1

                         NAME=COL_TRANSPOSED;

ID PET_OWNER;  

RUN;

LOG:

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

NOTE: The data set WORK.TRANSFILE1 has 4 observations and 5 variables.

NOTE: PROCEDURE TRANSPOSE used (Total process time):

      real time           0.03 seconds

      cpu time            0.01 seconds

RESULT:

The SAS System

Obs	COL_TRANSPOSED	Mr__Black	Mrs__Brown	Mrs__Green	Mr__White
1	CAT	1	0	.	3
2	DOG	2	1	0	1
3	FISH	.	0	5	7
4	BIRD	0	1	.	2

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