SAS/ACCESS Interface to CA-DATACOM/DB: Reference

SAS Data Files

This section describes the SAS data files used in this book. It provides the SAS statements that create the data file and shows the output from the PRINT procedure.

MYDATA.OUTOFSTK Data File

The SAS data file MYDATA.OUTOFSTK is used in Using CA-DATACOM/DB Data in SAS Programs. It was created with the following SAS statements:

libname mydata 'your-SAS-library';
data mydata.outofstk;
   input fibernam $8. fibernum;
   cards;
olefin   3478
gold     8934
dacron   4789
;
run;

The following PRINT procedure lists the output shown in SAS Data File MYDATA.OUTOFSTK.

proc print data=mydata.outofstk;
   title 'SAS Data File MYDATA.OUTOFSTK';
run;

SAS Data File MYDATA.OUTOFSTK

SAS Data File MYDATA.OUTOFSTK OBS FIBERNAM FIBERNUM 1 olefin 3478 2 gold 8934 3 dacron 4789

MYDATA.SASEMPS Data File

The SAS data file MYDATA.SASEMPS is used in Browsing and Updating CA-DATACOM/DB Data. It was created with the following SAS statements:

libname mydata 'your-SAS-library';
data mydata.sasemps;
   input empid birthdat date7. lastname $18. firstnam $15.
         middlena $15.;
   cards;
245962 30AUG64 BEDORTHA           KATHY           MARTHA
765432 01MAR59 POWELL             FRANK           X.
219223 13JUN47 HANSINGER          BENJAMIN        HAROLD
326745 21FEB52 RAWN               BEATRICE        MAY
;
run;

The following PRINT procedure lists the output shown in SAS Data File MYDATA.SASEMPS.

proc print data=mydata.sasemps;
   format birthdat date7.;
   title 'Data in MYDATA.SASEMPS Data File';
run;

SAS Data File MYDATA.SASEMPS

Data in MYDATA.SASEMPS Data File OBS EMPID BIRTHDAT LASTNAME FIRSTNAM MIDDLENA 1 245962 30AUG64 BEDORTHA KATHY MARTHA 2 765432 01MAR59 POWELL FRANK X. 3 219223 13JUN47 HANSINGER BENJAMIN HAROLD 4 326745 21FEB52 RAWN BEATRICE MAY

LIB6.BIRTHDAY Data File

The SAS data file LIB6.BIRTHDAY is used in Using CA-DATACOM/DB Data in SAS Programs. It was created with the following SAS statements:

libname lib6 'your-SAS-library';
data lib6.birthday;
   input empid birthdat date7. lastname $18.;
   cards;
129540 31JUL60 CHOULAI
356134 25OCT60 DUNNETT
127845 25DEC43 MEDER
677890 24APR65 NISHIMATSU-LYNCH
459287 05JAN34 RODRIGUES
346917 15MAR50 SHIEKELESLAN
254896 06APR49 TAYLOR-HUNYADI
;
run;

The following PRINT procedure lists the output shown in SAS Data File LIB6.BIRTHDAY.

proc print data=lib6.birthday;
   format birthdat date7.;
   title 'LIB6.BIRTHDAY Data File';
run;

SAS Data File LIB6.BIRTHDAY

LIB6.BIRTHDAY Data File OBS EMPID BIRTHDAT LASTNAME 1 129540 31JUL60 CHOULAI 2 356134 25OCT60 DUNNETT 3 127845 25DEC43 MEDER 4 677890 24APR65 NISHIMATSU-LYNCH 5 459287 05JAN34 RODRIGUES 6 346917 15MAR50 SHIEKELESLAN 7 254896 06APR49 TAYLOR-HUNYADI

Chapter Contents
Previous
Next
Top of Page