1420 ROUSE JEREMY PATERSON NJ 201/732-9834
1403 BOWDEN EARL BRIDGEPORT CT 203/675-3434
1616 FUENTAS CARLA NEW YORK NY 718/384-3329
;
Proclib.Superv2
data proclib.superv2;
input supid $4. +8 state $2. +5 jobcat $2.;
label supid='Supervisor Id' jobcat='Job Category';
datalines;
1417 NJ NA
1352 NY NA
1106 CT PT
1442 NJ PT
1118 NY PT
1405 NJ SC
1564 NY SC
1639 CT TA
1126 NY TA
1882 NY ME
;
Stores
data stores;
input Store $ x y;
datalines;
store1 5 1
store2 5 3
store3 3 5
store4 7 5
;
Survey
data survey;
input id $ diet $ exer $ hours xwk educ;
datalines;
1001 yes yes 1 3 1
1002 no yes 1 4 2
1003 no no . . .n
1004 yes yes 2 3 .x
1005 no yes 2 3 .x
1006 yes yes 2 4 .x
1007 no yes .5 3 .
1008 no no . . .
;
450 Appendix 4 • Data Sets for Examples in SQL Procedure Reference
Get SAS 9.4 SQL Procedure User's Guide, Third Edition, 3rd Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
