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

Get SAS 9.4 SQL Procedure User's Guide, Second Edition, 2nd Edition now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.