60.PROC TABULATE | MIN MAX STATISTICS

               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";

   FORMAT COUNTRY $CTRYFMT.;

   TITLE "SALES REP TABULAR REPORT";

RUN;

ODS _ALL_ CLOSE;

LOG:

NOTE: There were 159 observations read from the data set PROG1.SALES.

      WHERE JOB_TITLE contains 'Rep';

NOTE: PROCEDURE TABULATE used (Total process time):

      real time           0.10 seconds

      cpu time            0.04 seconds

RESULT:

SALES REP TABULAR REPORT

	Country
	AUSTRALIA		INDIA		UNITED KINGDOM		UNITES STATES
	Annual Salary		Annual Salary		Annual Salary		Annual Salary
	Min	Max	Min	Max	Min	Max	Min	Max
Gender	25185.00	30890.00	27475.00	28745.00	26205.00	29525.00	25390.00	32985.00
F
M	25745.00	36605.00	.	.	.	.	22710.00	35990.00
All	25185.00	36605.00	27475.00	28745.00	26205.00	29525.00	22710.00	35990.00

TRY THIS OPTION 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