CSULB_STAT475_handout24

CSULB_STAT475_handout24 - STAT 475 Chapter 4 COMBINING...

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

View Full Document Right Arrow Icon
STAT 475 Chapter 4 COMBINING TABLES VERTICALLY USING PROC SQL Reference SAS Certification Prep Guide: Advanced Programming for SAS 9 PROC SQL may be used to select data from multiple tables and to combine the tables vertically (that is, pasting one after another). The following four set operations are distinguished: EXCEPT (selects unique rows from the first table that are not found in the second table) ******* *** ******** ** *** Syntax proc sql; select * from table1 except select * from table2 ; quit; INTERSECT (selects unique rows that are common to both tables) ******** ********* Syntax 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
proc sql; select * from table1 intersect select * from table2 ; quit; UNION (selects unique rows from one or both tables) ******* *** ******** ** ********* *********** ************ ************ ************ ******* Syntax proc sql; select * from table1 union select * from table2 ; quit; OUTER UNION (selects all rows from both tables) ******* *** ******** ** ********* *********** ******** ****** *********** ************* ************* ********** Syntax 2
Background image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the 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 / 5

CSULB_STAT475_handout24 - STAT 475 Chapter 4 COMBINING...

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