27.SQL OPTIONS

                                            SQL OPTIONS

PROC SQL OPTIONS:::::

-->THESE OPTIONS WILL MENTIONED IN SAS SQL 

1.FLOW:CONTROL THE APPEARANCE OF THE WIDE CHARACTERS

2.DOUBLE:DOUBLE SPACE B/W OBS

3.INOBS:LIMIT THE ROWS

4.OUTOBS: RESTRICT THE NO OBS

5.PRINT/NOPRINT: CONTROLLING THE OUTPUT

6.NONUMBER/NUMBER:GIVE THE ROW NUMBER

PROC SQL;

SELECT * FROM SASHELP.CLASS;

QUIT;

NUMBER:

PROC SQL NUMBER;

SELECT * FROM SASHELP.CLASS;

QUIT;

NONUMBER:

PROC SQL NONUMBER;

SELECT * FROM SASHELP.CLASS;

QUIT;

FLOW:

PROC SQL FLOW=300;

SELECT * FROM SASHELP.CLASS;

QUIT;

DOUBLE:

PROC SQL DOUBLE;

SELECT * FROM SASHELP.CLASS;

QUIT;

INOBS:

PROC SQL FLOW=30 DOUBLE INOBS=5;

SELECT * FROM SASHELP.CLASS;

QUIT;

OUTOBS:

PROC SQL FLOW=30 DOUBLE OUTOBS=7 NUMBER;

SELECT * FROM SASHELP.CLASS;

QUIT;

PRINT:

PROC SQL PRINT;

SELECT * FROM SASHELP.CLASS;

QUIT;

NOPRINT:

PROC SQL NOPRINT;

SELECT * FROM SASHELP.CLASS;

QUIT;

--PLEASE FOLLOW THE BLOG FOR MORE INFO....

--JOIN US IN TELEGRAM CHANNEL FOR MORE UPDATES

   CLICK HERE: https://t.me/SasAll4You