8.GLOBAL OPTIONS

                                CREATING USER(OWN) DEFINED FORMATS

--->BY USING PROC FORMAT:::WE CAN USE USER DEFINED FORMAT

              ****VALUE STATEMENT IS NEED IN USER DEFINED FORMAT

  -->IF CHARACTER---DOLLAR SYMBOL IS USED

  -->IF NUMERIC---NO NEED OF DOLLAR(LETTER/UNDERSCORE) SYMBOL

  -->CANNOT BE MORE THAN 32 CHARACTER

IF CHARACTER---DOLLAR SYMBOL

PROC FORMAT;

   VALUE $RAMU  'AU'='AUSTRALIA'

                                  'US'='UNITED STATES'

                          'OTHER'='MISSING'

        'IN'='INDIA';

RUN;

PROC PRINT DATA=PROG1.SALES;

VAR COUNTRY GENDER;

FORMAT COUNTRY $RAMU.     ;

RUN;

-->IF NUMERIC---NO NEED OF DOLLAR

PROC FORMAT;

VALUE  RANGA   25000-49999='JUNIOR LEVEL'

                                50000-99999='SENIOR LEVEL'

                            100000-250000='MANAGER LEVEL';

RUN;

 

PROC PRINT DATA=PROG1.SALES;

VAR COUNTRY GENDER SALARY;

FORMAT COUNTRY $RAMU. SALARY RANGA.;

RUN;

APPLY THE SAS FORMATS(NOT USER DEFINED)

PROC PRINT DATA=PROG1.SALES;

VAR COUNTRY GENDER SALARY;

FORMAT COUNTRY $1. SALARY DOLLAR13.2;

RUN;

                  GLOBAL STATEMENTS::::

-->THESE STATEMENTS YOU  CAN USE 'ANY WHERE IN SAS ENVIRONMENT'

1.OPTIONS

2.TITLES

3.FOOTNOTES

4.ODS(OUTPUT DELIVERY SYSTEM)::: FILE FORMATS

    

   -->HTML:: HYPER TEXT MARKUP LANGUAGE(OPEN IN WEB BROWSERS-              CHROME,FIREFOX,ME)

   -->PDF:: PORTABLE DOCUMENT FORMAT(OPEN IN ADOBE READER)

   -->RTF:: RICH TEXT FORMAT(OPEN IN MS-WORD)

  

   --> CSVALL:: COMMA SEPARATED VALUE (OPEN IN EXCEL)

1.OPTIONS

--->DATE(DEFAULT):: DISPLAY THE DATE AND TIME

--->NODATE:: DO NOT DISPLAY THE DATE AND TIME

--->NUMBER(DEFAULT):: PRINT THE PAGE NUMBER

--->NONUMBER:: WON'T PRINT THE PAGE NUMBER

--->CENTER(DEFAULT): OUTPUT WILL BE IN CENTER

--->NOCENTER:::OUTPUT WILL ALIGN TO LEFT SIDE

--->PAGE SIZE(PS=):: NUMBER OF LINES(15-32767)

--->LINE SIZE(LS=):: NUMBER OF LINE SIZE(64-256)

OPTIONS NODATE NONUMBER NOCENTER LS=70 PS=18;

PROC MEANS DATA=SASHELP.CLASS;

RUN;

IF U NEED ALL DEFAULT OPTIONS

OPTIONS DATE NUMBER CENTER;

PROC PRINT DATA=SASHELP.CLASS;

RUN;

2.TITLES::

->WILL APPEAR AT THE 'TOP OF THE PAGE'

->DEFAULT TITLE IS 'The SAS System'

->WE CAN GIVE 1-10 TITLES AT A TIME

->AN UN-NUMBERED TITLE IS EQUAL TO TITLE1

TITLE 'ALL STUDENTS DATA';

PROC MEANS DATA=SASHELP.CLASS;

TITLE 'DATA OF THE STUDENTS';

TITLE1 ' STUDENTS DATA';

TITLE2 'ALL  DATA';

TITLE3 'ALL STUDENTS ';

TITLE4 'ALL STUDENT DATA';

TITLE5 ' DATA';

TITLE6 'ALL STU DATA';

TITLE7 'ALL ENTS DATA';

TITLE8 'ALL TS DATA';

TITLE9 'ALL STUDENTS DATA';

TITLE10 'ATS DATA';

RUN;

DATA SAS;

SET SASHELP.CLASS;

TITLE1 ' STUDENTS DATA';

TITLE2 'ALL  DATA';

TITLE3 'ALL STUDENTS ';

TITLE4 'ALL STUDENTS DATA';

TITLE5 ' DATA';

RUN;

PROC PRINT;

RUN;

DATA SAS;

SET SASHELP.CLASS;

TITLE ' STUDENTS DATA';

RUN;

PROC PRINT;

RUN;

TO REMOVE THE TITLE : JUST WRITE TITLE AT THE END .

TITLE;  AND RUN THE PROGRAM

3.FOOTNOTES:::

->WILL APPEAR AT THE 'BOTTOM OF THE PAGE'

->WE CAN GIVE 1-10 FOOTNOTES AT A TIME

->AN UN-NUMBERED FOOTNOTES IS EQUAL TO FOOTNOTES1;

FOOTNOTE 'CLASS DATA OF ALL STUDENTS';

PROC SUMMARY DATA=SASHELP.CLASS PRINT;

FOOTNOTE 'COUNT OF THR OBS FROM SASHELP';

FOOTNOTE1 'COUNT THR OBS FROM SASHELP';

FOOTNOTE2 'COUNT OF FROM SASHELP';

FOOTNOTE3 'COUNT OF  OBS FROM SASHELP';

FOOTNOTE4 'COUNT OF THR OBS FROM SASHELP';

FOOTNOTE5 'COUNT OF THR  SASHELP';

FOOTNOTE6 'COUNT OF THR OBS FROM SASHELP';

FOOTNOTE7 'T OF THR OBS SASHELP';

FOOTNOTE8 'COUNT OF THR OBS M SASHELP';

RUN;

FOOTNOTE 'DDGYFHFYTDYFVTFTD';

PROC SUMMARY DATA=SASHELP.CLASS PRINT;

RUN;

TITLE 'COUNT OF OBSERVATIONS';

DATA SAS12;

SET SASHELP.CLASS;

FOOTNOTE 'COUNT OF THR OBS FROM SASHELP';

FOOTNOTE1 'COUNT THR OBS FROM SASHELP';

FOOTNOTE2 'COUNT OF FROM SASHELP';

FOOTNOTE3 'COUNT OF  OBS FROM SASHELP';

RUN;

PROC PRINT;

RUN;

PROC PRINT DATA=SASHELP.CLASS;

TITLE1 ' STUDENTS DATA';

TITLE2 'ALL  DATA';

TITLE3 'ALL STUDENTS ';

FOOTNOTE1 'COUNT THR OBS FROM SASHELP';

FOOTNOTE2 'COUNT OF FROM SASHELP';

FOOTNOTE3 'COUNT OF  OBS FROM SASHELP';

RUN;

TO DELETE THE FOOTNOTE JUST WRITE FOOTNOTE AND SEMICOLON RUN .

FOOTNOTE; RUN THE PROGRAM

4.ODS(OUTPUT DELIVERY SYSTEM)::: FILE FORMATS

    

   -->HTML:: HYPER TEXT MARKUP LANGUAGE(OPEN IN WEB BROWSERS-CHROME,FIREFOX,ME)

   -->PDF:: PORTABLE DOCUMENT FORMAT(OPEN IN ADOBE READER)

   -->RTF:: RICH TEXT FORMAT(OPEN IN MS-WORD)

     

    -->CSVALL:: COMMA SEPARATED VALUE (OPEN IN EXCEL)

ODS HTML FILE="C:\Users\sumed\OneDrive\Desktop\ODS\CARS.HTML";

PROC MEANS DATA=SASHELP.CARS;

RUN;

ODS HTML CLOSE;

ODS PDF FILE="C:\Users\sumed\OneDrive\Desktop\ODS\CARS12.PDF";

PROC MEANS DATA=SASHELP.CARS;

RUN;

ODS PDF CLOSE;

ODS RTF FILE="C:\Users\sumed\OneDrive\Desktop\ODS\CARS1233.RTF" STYLE=JOURNAL;

PROC MEANS DATA=SASHELP.CARS;

RUN;

ODS RTF CLOSE;

ODS CSVALL FILE="C:\Users\sumed\OneDrive\Desktop\ODS\CARS23.CSV" STYLE=JOURNAL;

PROC MEANS DATA=SASHELP.CARS;

RUN;

ODS CSVALL CLOSE;

ODS RTF FILE="C:\Users\sumed\OneDrive\Desktop\ODS\CLAS123.RTF" STYLE=OCEAN;

DATA SS;

INFILE "C:\Users\sumed\OneDrive\Desktop\SALE1.TXT";

INPUT NAME$ AGE GEND$ HT WT;

RUN;

PROC PRINT;

RUN;

ODS RTF CLOSE;