SAS Learning Hub

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

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

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

          ADDING NEW DATA INTO AVAILABLE DATA USING MERGE  DATA  WHICH WANTS TO MERGE WITH ALREADY CREATED DATE..IT CONSISTS OF 3 STEPS AND I HAVE ALSO SORTED THE DATA.. 1.DATA CLASS1;  SET SASHELP.CLASS4; RUN; LOG: NOTE: There were 19 observations read from the data set SASHELP.CLASS4. NOTE: The data set WORK.CLASS1 has 19 observations and 8 variables. NOTE: DATA statement used (Total process time):       real time           0.50 seconds       cpu time            0.04 seconds 2.DATA WORK.CLASS2;  INPUT  Name$ Sex$ Age Height Weight DOB:DATE9. CLASS GRADE$;  DATALINES;  Nancy F 19 69 102 12MAR2002 . A  Firoz M 20 76 125 15JUN2001 . A  ; RUN; LOG: NOTE: The data set WORK.CLASS2 has 2 observations and 8 variables. NOTE: DATA statement used (Total process time):       real time           ...

                                        PROC TABULATE | OUT OPTION  PROC TABULATE OUT OPTION: PROC TABULATE OUTPUT OPTION PRODUCES DATASETS USING FOLLOWING METHOD: PROC TABULATE DATA=SAS DATASET OUT=SAS DATASET; THE OUTPUT VARIABLES ARE: * BY  VARIABLES * CLASS VARIABLES * THE AUTOMATIC VARIABLES _TYPE_ , _PAGE_  AND _TABLE_ * CALCULATED STATISTICS EG: PROC TABULATE DATA=PROG1.SALES OUT=SALES;  CLASS JOB_TITLE GENDER COUNTRY;  WHERE JOB_TITLE CONTAINS "Rep";  TABLE COUNTRY;  TABLE GENDER COUNTRY;  TABLE JOB_TITLE,GENDER,COUNTRY; RUN; PROC PRINT;RUN; LOG: NOTE: There were 159 observations read from the data set PROG1.SALES.       WHERE JOB_TITLE contains 'Rep'; NOTE: The data set WORK.SALES has 31 observations and 7 variables. NOTE: PROCEDURE TABULATE used (Total process time):       real time       ...

               PROC TABULATE | MIN MAX STATISTICS PROC FORMAT: PROC FORMAT;  VALUE $CTRYFMT  "AU"="AUSTRALIA"                  "US"="UNITES STATES" "IN"="INDIA" "UK"="UNITED KINGDOM"; RUN; LOG: NOTE: Format $CTRYFMT has been output. NOTE: PROCEDURE FORMAT used (Total process time):       real time           0.09 seconds       cpu time            0.03 seconds RESULT: PROC TABULATE: MINIMUM AND MAXIMUM STATISTICS WITH ODS.. HERE ODS MEANS :OUTPUT DELIVERY  SYSTEM... WE CAN WRITE ANY DOCUMENTS LIKE PDF,HTML,RTF ETC.. ODS HTML FILE="SALES000.HTML" PROC TABULATE DATA=PROG1.SALES ;    CLASS GENDER COUNTRY;    VAR SALARY;    TABLE GENDER ALL,COUNTRY*SALARY*(MIN MAX);    WHERE JOB_TITLE CONTAINS "Rep";    LABEL SALARY="Annual Salary";   ...

                             PROC MEANS | CHARTYPE OPTION  PROC MEANS DATA=PROG1.SALES  ;  VAR SALARY;  CLASS GENDER COUNTRY;  OUTPUT OUT=WORK.MEANS1         MIN=MINSALARY MAX=MAXSALARY         SUM=SUMSALARY MEAN=AVGSALARY; RUN; PROC PRINT;RUN; LOG: NOTE: Writing HTML Body file: sashtml.htm NOTE: There were 165 observations read from the data set PROG1.SALES. NOTE: The data set WORK.MEANS1 has 13 observations and 8 variables. NOTE: PROCEDURE MEANS used (Total process time):       real time           3.88 seconds       cpu time            0.39 seconds RESULT: WITHOUT  CHARTYPE OPTIONS OBSERVE THE _TYPE_..                                            ...

                              PROC MEANS | DESCENDTYPES OPTION PROC MEANS DATA=PROG1.SALES  ;  VAR SALARY;  CLASS GENDER COUNTRY;  OUTPUT OUT=WORK.MEANS1         MIN=MINSALARY MAX=MAXSALARY         SUM=SUMSALARY MEAN=AVGSALARY; RUN; PROC PRINT;RUN; LOG: NOTE: Writing HTML Body file: sashtml.htm NOTE: There were 165 observations read from the data set PROG1.SALES. NOTE: The data set WORK.MEANS1 has 13 observations and 8 variables. NOTE: PROCEDURE MEANS used (Total process time):       real time           3.88 seconds       cpu time            0.39 seconds RESULT: WITHOUT  DESCENDTYPES OPTION OBSERVE THE _TYPE_..                                           ...