SAS PROGRAMMING
                                 HANDOUT #15

     PROC SQL is a relatively new procedure that can handle many data set manipulations.
     Many of the command are similar to the SQL programming language
     For more examples on SQL look at SAS PROGRAMMING II taught Summer Quarter 1999-2000, handouts 21-26.

DATA JIM;
 INPUT A $ B X;
CARDS;
A  1  2
D  1  4
B  4  1
C  2  5
;
LIBNAME BOB 'A:\';
PROC SQL;
  CREATE TABLE BOB.LAURA AS
  SELECT A,X
  FROM  WORK.JIM
  WHERE B=1  ;
                                                *This creates a SAS data set LAURA on BOB;
                                                *This selects observations with B=1;
PROC SQL;
  SELECT A,X
  FROM  WORK.JIM
  WHERE B=1  ;                                 *This prints the data set;

DATA BOB.LAURA; SET WORK.JIM;                  *This does it in usual SAS;
 IF B=1;
PROC PRINT;  VAR A X;
RUN;

PROC PRINT DATA=WORK.JIM;
 WHERE B=1;
 VAR A X;
RUN;
*==================================PROC SQL ALSO MERGES===========================================;
DATA JIM;
 INPUT A $ B X;
CARDS;
A  1  2
D  1  4
B  4  1
C  2  5
;
PROC SORT DATA=JIM OUT=JIM2; BY A;
DATA MARCIA;
 INPUT A $ X;
CARDS;
B  20
D  40
;
PROC SORT DATA=MARCIA OUT=MARCIA2; BY A;

PROC SQL;
 SELECT JIM.A, B,  X
 FROM JIM FULL JOIN MARCIA
 ON JIM.A=MARCIA.A;

DATA MATT; MERGE JIM2 MARCIA2; BY A;
PROC PRINT; RUN;