SAS Data Files Used for CA-Datacom/DB Examples :: SAS/ACCESS(R) 9.3 Interface to CA-Datacom/DB: Reference

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;
   datalines;
olefin   3478
gold     8934
dacron   4789
;

The following PRINT procedure produces the report shown in the output that follows.

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.SASEemps 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.;
   datalines;
245962 30AUG64 BEDORTHA           KATHY           MARTHA
765432 01MAR59 POWELL             FRANK           X.
219223 13JUN47 HANSINGER          BENJAMIN        HAROLD
326745 21FEB52 RAWN               BEATRICE        MAY
;

The following PRINT procedure produces the report shown in the output that follows.

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.BirthdayData 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.;
   datalines;
129540 31JUL60 CHOULAI
356134 25OCT60 DUNNETT
127845 25DEC43 MEDER
677890 24APR65 NISHIMATSU-LYNCH
459287 05JAN34 RODRIGUES
346917 15MAR50 SHIEKELESLAN
254896 06APR49 TAYLOR-HUNYADI
;

The following PRINT procedure produces the report shown in the following output.

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