/* Chapter 14: Documentation Roadmap */

/* Jump to: Chapter 13    Table of Contents    Appendix A */

/*

*/

/* 14.3: The Three Expressions Revisited */

/* Jump to: Next Section */

PROC SQL;                                                                       
SELECT       name, age                                                          
FROM         sashelp.class                                                      
WHERE        sex='F'                                                            
UNION                                                                           
SELECT       name, age + 1                                                      
FROM         sashelp.class                                                      
ORDER BY     age                                                                
;                                                                               
QUIT;                                                                           

/* Jump to: Top of Section     Top of Chapter */

/* 14.4: Could It Be More Logical? */

/* Jump to: Next Section */

PROC SQL;                                                                       
SELECT       name, age                                                          
FROM         sashelp.class                                                      
WHERE        sex='F'                                                            
UNION                                                                           
SELECT       name, age + 1                                                      
FROM         sashelp.class                                                      
ORDER BY     age                                                                
;                                                                               
QUIT;                                                                           
                                                                                
PROC SQL;                                                                       
CREATE TABLE mytable AS                                                         
SELECT       name, age                                                          
FROM         sashelp.class                                                      
WHERE        sex='F'                                                            
UNION                                                                           
SELECT       name, age + 1                                                      
FROM         sashelp.class                                                      
ORDER BY     age                                                                
;                                                                               
QUIT;                                                                           

/* Jump to: Top of Section     Top of Chapter */