O'Reilly logo

SAS 9.4 SQL Procedure User's Guide, Fourth Edition, 4th Edition by SAS Institute

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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
440 Appendix 4 Data Sets for Examples in SQL Procedure Reference

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required