SAS 9.4 SQL Procedure User's Guide, Second Edition, 2nd Edition

Employees

data Employees;

input IdNum $4. +2 LName $11. FName $11. JobCode $3.

+1 Salary 5. +1 Phone $12.;

datalines;

1876 CHIN JACK TA1 42400 212/588-5634

1114 GREENWALD JANICE ME3 38000 212/588-1092

1556 PENNINGTON MICHAEL ME1 29860 718/383-5681

1354 PARKER MARY FA3 65800 914/455-2337

1130 WOOD DEBORAH PT2 36514 212/587-0013

;

Houses

data houses;

input House $ x y;

datalines;

house1 1 1

house2 3 3

house3 2 3

house4 7 7

;

Match_11

data match_11;

input Pair Low Age Lwt Race Smoke Ptd Ht UI @@;

select(race);

when (1) do;

race1=0;

race2=0;

end;

when (2) do;

race1=1;

race2=0;

end;

when (3) do;

race1=0;

race2=1;

end;

end;

datalines;

1 0 14 135 1 0 0 0 0 1 1 14 101 3 1 1 0 0

2 0 15 98 2 0 0 0 0 2 1 15 115 3 0 0 0 1

3 0 16 95 3 0 0 0 0 3 1 16 130 3 0 0 0 0

438 Appendix 4 • Data Sets for Examples in SQL Procedure Reference