/****************************************************************/ /*          S A S   S A M P L E   L I B R A R Y                 */ /*                                                              */ /*    NAME: SQLUGDAT                                            */ /*   TITLE: DATASETS USED IN SQL USAGE GUIDE, VERSION 6.06      */ /* PRODUCT: BASE                                                */ /*  SYSTEM: ALL                                                 */ /*    KEYS: SQL DATMAN SQLV61 MACRO                             */ /*   PROCS: SQL                                                 */ /*    DATA:                                                     */ /*                                                              */ /* SUPPORT: KMS, PMK                    UPDATE:                 */ /*     REF:                                                     */ /*    MISC:                                                     */ /*                                                              */ /****************************************************************/  title1 '*** sqlugdat: SQL User Guide datasets ***'; /*-----------------------------------------------------------------*/ /*-- The following data steps create the permanent datasets used --*/ /*-- in the SQL User's Guide examples.                           --*/ /*-----------------------------------------------------------------*/data invoice;   input invnum custname $ 6-15 custnum empnum prodname $ 28-37      invqty invprice;   format invprice dollar.;   cards;280  Beach Land   16  215  snorkel      20    14290  Beach Land   16  216  flippers     15    19300  Beach Land   16  216  raft         20     7310  Coast Shop    3  318  windsurfer    2  1305320  Coast Shop    3  318  raft         30     6330  Coast Shop    5  318  snorkel       5    15340  Coast Shop    5  318  flippers     15    19350  Coast Shop    5  318  raft         40     6360  Coast Shop    5  318  snorkel      10    15370  Coast Shop   12  213  raft         10     7380  Coast Shop   14  417  windsurfer    1  1325390  Del Mar       3  417  flippers     30    18400  Del Mar       3  417  kayak         3   230410  Del Mar       8  417  raft         40     6420  Del Mar      11  417  raft         15     7430  Del Mar      11  417  snorkel      10    15440  Del Mar      11  417  flippers     20    19450  New Waves     3  215  flippers      5    20460  New Waves     3  215  flippers     10    20470  New Waves     6  213  snorkel      15    15480  New Waves     6  213  surfboard     4   735490  New Waves     6  213  snorkel      10    15500  Surf Mart   101  417  snorkel      20    14510  Surf Mart   101  417  surfboard     2   740520  Surf Mart   101  417  snorkel      12    15530  Surf Mart   118  318  flippers     15    19540  Surf Mart   118  318  raft         30     6550  Surf Mart   118  318  snorkel      10    15560  Surf Mart   127  314  flippers     25    19570  Surf Mart   127  314  surfboard     3   740run;data product;   input prodname $ 1-10 prodcost prodlist;   format prodcost prodlist dollar.;   cards;flippers      16    20jet ski     2150  2675kayak        190   240raft           5     7snorkel       12    15surfboard    615   750windsurfer  1090  1325run;data customer;   input custname $ 1-10 custnum custcity $ 22-36;   cards;Beach Land       16  Ocean CityCoast Shop        3  Myrtle BeachCoast Shop        5  Myrtle BeachCoast Shop       12  Virginia BeachCoast Shop       14  CharlestonDel Mar           3  Folly BeachDel Mar           8  CharlestonDel Mar          11  CharlestonNew Waves         3  Ocean CityNew Waves         6  Virginia BeachSea Sports        8  CharlestonSea Sports       20  Virginia BeachSurf Mart       101  CharlestonSurf Mart       118  SurfsideSurf Mart       127  Ocean IsleSurf Mart       133  Charlestonrun;data employee;   input empnum empname $ empyears empcity $ 20-34   emptitle $ 36-45 empboss;   cards;101   Herb     28  Ocean City      president     .201   Betty     8  Ocean City      manager     101213   Joe       2  Virginia Beach  salesrep    201214   Jeff      1  Virginia Beach  salesrep    201215   Wanda    10  Ocean City      salesrep    201216   Fred      6  Ocean City      salesrep    201301   Sally     9  Wilmington      manager     101314   Marvin    5  Wilmington      salesrep    301318   Nick      1  Myrtle Beach    salesrep    301401   Chuck    12  Charleston      manager     101417   Sam       7  Charleston      salesrep    401run;