CSULB_STAT475_handout26

CSULB_STAT475_handout26 - quit; The output is Row id x 1 1...

Info iconThis preview shows pages 1–3. Sign up to view the full content.

View Full Document Right Arrow Icon
STAT 475 Chapter 8 MANAGING PROCESSING USING PROC SQL Reference SAS Certification Prep Guide: Advanced Programming for SAS 9 There are several options that may be specified in the PROC SQL statement: INOBS= that restricts the number of input rows that PROC SQL acquires from any source. It is analogous to the SAS system option OBS= and is useful for debugging queries on large tables. data one; input id x$; cards; 1 a 2 b 3 c 4 d 5 e ; options nodate nonumber; title; proc sql inobs=3; select * from one; quit; The output is id x ƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒ 1 a 2 b 3 c OUTOUBS= that restricts the number of output rows that PROC SQL displays or writes to a table. proc sql outobs=4; select * from one; quit; The output is id x 1
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
ƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒ 1 a 2 b 3 c 4 d NUMBER|NONUMBER that specifies whether the output should include a column named ROW, which displays row numbers. NONUMBER is the default. This option is analogous to the OBS|NOOBS option in the PROC PRINT statement. proc sql number; select * from one;
Background image of page 2
Background image of page 3
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: quit; The output is Row id x 1 1 a 2 2 b 3 3 c 4 4 d 5 5 e DOUBLE|NODOUBLE that specifies whether the output should be double-spaced or not. The default is NODOUBLE. Double-spacing can make it easier to read the output. This option makes the plain text output in the output window double-spaced, but the html output remains the same. proc sql double; select * from one; quit; The output is id x 1 a 2 b 3 c 4 d 5 e RESETTING OPTIONS To add, drop, or modify an option, use the RESET statement. 2 data one; input id x$; cards; 1 a 2 b 3 c 4 d 5 e ; data two; input id y$; cards; 21 x 22 y 23 z ; options nodate nonumber; title; proc sql outobs=2; select * from one; reset outobs= number; select * from two; quit; The output is id x 1 a 2 b Row id y 1 21 x 2 22 y 3 23 z 3...
View Full Document

This note was uploaded on 12/14/2011 for the course STAT 475 taught by Professor Olgak during the Fall '11 term at CSU Long Beach.

Page1 / 3

CSULB_STAT475_handout26 - quit; The output is Row id x 1 1...

This preview shows document pages 1 - 3. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online