Proc Options :
To find out the global options in SAS log.
Syntax:-
Proc options <options>;
Run;
Examples:-
Specify the all options short form in log.
PROC OPTIONS SHORT;
RUN;
Specify the all options long form in log.
Default is long form.
PROC OPTIONS LONG;
RUN;
Display groups and group descriptions
PROC OPTIONS LISTGROUPS;
RUN;
See below options group wise
PROC OPTIONS GROUP=ERRORHANDLING;
RUN;
PROC OPTIONS GROUP=SORT;
RUN;
PROC OPTIONS GROUP=PDF;
RUN;
PROC OPTIONS GROUP=Email;
RUN;
PROC OPTIONS GROUP=SQL;
RUN;
Till now we know two components in SAS program those are Data step and Proc step.
Additionally there is one more that is Global options
Global options are useful to handle the data properly in both Data & Proc steps
And useful to change default settings. We can write options anywhere in SAS system and once if we write it works until the SAS session closes or changing the value.
See the log for options after executing below program
Proc options;
Run;
How can we use those options
These options are global options, so once we use this it will be work upto closing the SAS session or changing that option with different value.
We can use these options anywhere in SAS session using OPTIONS like below
Options yearcutoff=1920 nodate nonumber missing=0
Orientation=landscape ls=200 ps=40;
Data ds;
Infile datalines;
Input EMP_ID EMP_NAME$ SEX$ AGE DOB INCOME;
Informat DOB date7.
Format DOB weekdate30.;
Datalines;
1 Abdal F 26 30May83 10000
2 Ander M 20 12Jun83 10000
3 Aziz F 23 05Aug83 20000
4 Bayer M 24 10Apr84 .
5 Black M 25 10Oct84 30000
6 Blair F 25 09Jan85 36000
7 Blue F 28 22Jan85 15000
8 Brown M 30 12Feb85 14000
9 Bush F 35 10Mar85 15000
10 Black M 25 30Dec85 30000
;
Run;
Proc print data=ds;
Title ‘Emp info of Stansys’;
Run;
Few important OPTIONS With description
NODATE
Do not print date and time on top of each page of SAS log and procedure output
NO PAGE
Do not print page number on each page of SAS output
MISSING=
Character to represent missing numeric value
ORIENTATION=LANDSCAPE
Orientation of the page when printing, default is Portrait
LS (Line Size)
Line size for SAS log and SAS procedure output
No of characters in a line
LINESIZE must be between 64 and 256.
PS (PAGE SIZE)
No of lines in a page
PAGESIZE must be between 15 and 32767.
YEARCUTOFF=1920
Cutoff year for DATE and DATETIME informats and functions
Specifies the first year of a 100-year span that is used by date informats and functions to read a two-digit year.
SYSIN
Specifies the default location of SAS source code when running in batch or non interactive mode “C:\Program Files\SASFoundation\9.2\sas.exe” -SYSIN “E:\SAS\SAMPLE.SAS”
SYSPRINT=(“Send To OneNote 2007”)
Set the default printer and, optionally, an alternate destination (file) for output
FONT=(SASFONT SIZE)
Sets the display manager font. The first parameter is the face name of the font and the second optional parameter is the point size of the font.
Options Font=Verdana 10;
Proc print data=sashelp.class;
Run;
OBS=
Number of the last observation to process
Options OBS=10;
Proc print data=sashelp.class;
Run;
CENTER|NOCENTER
Center SAS procedure output
By default, output is always centered. To specify not centered, use NOCENTER which will print results to the output window as left justified.
NOTES|NONOTES
Write notes to the SAS log | Suppress notes to the SAS log
SOURCE|NOSOURCE
Write program to the SAS log | Suppress program to the SAS log
CAPS|NOCAPS
Translate SAS source and data lines to uppercase
OPTIONS CAPS;
DATA DS;
INFILE DATALINES;
INPUT ID NAME$ SEX$ SAL;
DATALINES;
101 Ram m 5000
102 Krishna m 6000
102 padma f 4000
102 maDAn m 7000
;
RUN;
REPLACE|NOREPLACE
Allow replacement of permanent SAS data sets
BUFFNO=1
Number of buffers for each SAS data set
BUFSIZE=0
Size of buffer for page of SAS data set
LRCEL=256
Default record length for external files
USER=LIBNAME
Default location for all one-level SAS data set names
Create a library name and specify that library name with user, all the datasets will store into that library without specifying library name infront of dataset name.
OPTIONS USER=KRISHNA;
DATA DS;
SET SASHELP.CLASS;
RUN;
FMTSEARCH
List of catalogs to search for formats and informats
Libname Krishna “C:\Documents and Settings\Administrator\Stansys\sas”;
/*Libname krishna “/sas/sasebi/apache/data”;*/
Proc format library=krishna.catalog;
Value $gender ‘F’=’Female’ ‘M’=’Male’;
Run;
Options fmtsearch=(krishna.catalog);
Data ds;
Set sashelp.class;
Format sex $gender.;
Run;
MACRO
Allow use of SAS macro facility
Note: All macro options we can get at Macro concepts again so i am not giving here