The following (after source statements are generated by running the code in Fax Appendix 3 after running the code in Fax Appendix 2).

/*--------------------------------------------------------------*
| Table definition statements generated on 27NOV96:15:12:58.92
| For PDB table....: UFAXES
| Table type.......: EVENT
| Now sorted by....: MACHINE TYPE COUNTRY ACODE TIMESTMP
| From SAS data set: WORK.FAXES
| Data set type....: DATA
| Will be sorted by: MACHINE TYPE COUNTRY ACODE DATETIME HOUR SHIFT
*--------------------------------------------------------------*/

DELETE TABLE NAME=UFAXES NOERROR ;

CREATE TABLE NAME=UFAXES
  COLLECTOR=GENERIC TOOLNAME=SASDS TYPE=EVENT KEPT=YES
  EXTNAME=FAXES
  LABEL='Fax Activity'
  DESCRIPTION='Fax Activity'
  DETAIL=(agelimit=10 )
  DAY=(agelimit=45 )
  WEEK=(agelimit=15 )
  MONTH=(agelimit=18 )
  YEAR=(agelimit=5 ) ;

  /*----------------------------------------------------------*
  | Variable definitions for table: UFAXES
  *----------------------------------------------------------*/

  CREATE VARIABLE NAME=MACHINE EXTNAME=MACHINE
    SUBJECT='N/A' LABEL='Machine name'
    DESCRIPTION='Machine name'
    FORMAT=.
    TYPE=CHARACTER LENGTH=8 INTERPRET=STRING KEPT=YES
    ;

  CREATE VARIABLE NAME=TYPE EXTNAME=TYPE
    SUBJECT='N/A' LABEL='Fax Type: (S)end or (R)eceive'
    DESCRIPTION='Fax Type: (S)end or (R)eceive'
    FORMAT=.
    TYPE=CHARACTER LENGTH=1 INTERPRET=STRING KEPT=YES
    ;

  CREATE VARIABLE NAME=COUNTRY EXTNAME=COUNTRY
    SUBJECT='N/A' LABEL='Country Code'
    DESCRIPTION='Country Code'
    FORMAT=.
    TYPE=CHARACTER LENGTH=3 INTERPRET=STRING KEPT=YES
    ;

  CREATE VARIABLE NAME=ACODE EXTNAME=ACODE
    SUBJECT='N/A' LABEL='Area Code'
    DESCRIPTION='Area Code'
    FORMAT=.
    TYPE=CHARACTER LENGTH=3 INTERPRET=STRING KEPT=YES
    ;

  CREATE VARIABLE NAME=PHNUM EXTNAME=PHNUM
    SUBJECT='N/A' LABEL='Phone Number'
    DESCRIPTION='Phone Number'
    FORMAT=.
    TYPE=CHARACTER LENGTH=8 INTERPRET=STRING KEPT=YES
    ;

  CREATE VARIABLE NAME=PAGES EXTNAME=PAGES
    SUBJECT='N/A' LABEL='Pages Sent or Received'
    DESCRIPTION='Pages Sent or Received'
    FORMAT=BEST12.
    TYPE=NUMERIC LENGTH=8 INTERPRET=COUNT KEPT=YES
    ISTATS =(
        NOCOUNT SUM AVERAGE NOMAXIMUM NOMINIMUM NOUSS NOCV NORANGE
        NOVARIANCE NOSTD NONMISS
        )
    DAY =(
        NOCOUNT SUM AVERAGE NOMAXIMUM NOMINIMUM NOUSS NOCV NORANGE
        NOVARIANCE NOSTD NONMISS
        )
    WEEK =(
        NOCOUNT SUM AVERAGE NOMAXIMUM NOMINIMUM NOUSS NOCV NORANGE
        NOVARIANCE NOSTD NONMISS
        )
    MONTH =(
        NOCOUNT SUM AVERAGE NOMAXIMUM NOMINIMUM NOUSS NOCV NORANGE
        NOVARIANCE NOSTD NONMISS
        )
    YEAR =(
        NOCOUNT SUM AVERAGE NOMAXIMUM NOMINIMUM NOUSS NOCV NORANGE
        NOVARIANCE NOSTD NONMISS
        )
    ;


  UPDATE VARIABLE NAME=DATETIME EXTNAME=TIMESTMP
    SUBJECT='N/A' LABEL='Datetime stamp of fax'
    DESCRIPTION='Datetime stamp of fax'
    FORMAT=DATETIME21.2
    ;

  CREATE VARIABLE NAME=RESENT EXTNAME=RESENT
    SUBJECT='N/A' LABEL='Pages Resent'
    DESCRIPTION='Pages Resent'
    FORMAT=BEST12.
    TYPE=NUMERIC LENGTH=8 INTERPRET=COUNT KEPT=YES
    ISTATS =(
        NOCOUNT SUM AVERAGE NOMAXIMUM NOMINIMUM NOUSS NOCV NORANGE
        NOVARIANCE NOSTD NONMISS
        )
    DAY =(
        NOCOUNT SUM AVERAGE NOMAXIMUM NOMINIMUM NOUSS NOCV NORANGE
        NOVARIANCE NOSTD NONMISS
        )
    WEEK =(
        NOCOUNT SUM AVERAGE NOMAXIMUM NOMINIMUM NOUSS NOCV NORANGE
        NOVARIANCE NOSTD NONMISS
        )
    MONTH =(
        NOCOUNT SUM AVERAGE NOMAXIMUM NOMINIMUM NOUSS NOCV NORANGE
        NOVARIANCE NOSTD NONMISS
        )
    YEAR =(
        NOCOUNT SUM AVERAGE NOMAXIMUM NOMINIMUM NOUSS NOCV NORANGE
        NOVARIANCE NOSTD NONMISS
        )
    ;

  CREATE VARIABLE NAME=CONNECT EXTNAME=CONNECT
    SUBJECT='N/A' LABEL='Total connect time'
    DESCRIPTION='Total connect time'
    FORMAT=TIME12.2
    TYPE=NUMERIC LENGTH=8 INTERPRET=TIME KEPT=YES
    ISTATS =(
        NOCOUNT SUM AVERAGE NOMAXIMUM NOMINIMUM NOUSS NOCV NORANGE
        NOVARIANCE NOSTD NONMISS
        )
    DAY =(
        NOCOUNT SUM AVERAGE NOMAXIMUM NOMINIMUM NOUSS NOCV NORANGE
        NOVARIANCE NOSTD NONMISS
        )
    WEEK =(
        NOCOUNT SUM AVERAGE NOMAXIMUM NOMINIMUM NOUSS NOCV NORANGE
        NOVARIANCE NOSTD NONMISS
        )
    MONTH =(
        NOCOUNT SUM AVERAGE NOMAXIMUM NOMINIMUM NOUSS NOCV NORANGE
        NOVARIANCE NOSTD NONMISS
        )
    YEAR =(
        NOCOUNT SUM AVERAGE NOMAXIMUM NOMINIMUM NOUSS NOCV NORANGE
        NOVARIANCE NOSTD NONMISS
        )
    ;

  CREATE VARIABLE NAME=PCTRTRY EXTNAME=PCTRTRY
    SUBJECT='N/A' LABEL='Percent retries'
    DESCRIPTION='Percent retries'
    FORMAT=PERCENT7.2
    TYPE=NUMERIC LENGTH=8 INTERPRET=PERCENT KEPT=YES
    ISTATS =(
        NOCOUNT NOSUM AVERAGE NOMAXIMUM NOMINIMUM NOUSS NOCV NORANGE
        NOVARIANCE NOSTD NONMISS
        )
    DAY =(
        NOCOUNT NOSUM AVERAGE NOMAXIMUM NOMINIMUM NOUSS NOCV NORANGE
        NOVARIANCE NOSTD NONMISS
        )
    WEEK =(
        NOCOUNT NOSUM AVERAGE NOMAXIMUM NOMINIMUM NOUSS NOCV NORANGE
        NOVARIANCE NOSTD NONMISS
        )
    MONTH =(
        NOCOUNT NOSUM AVERAGE NOMAXIMUM NOMINIMUM NOUSS NOCV NORANGE
        NOVARIANCE NOSTD NONMISS
        )
    YEAR =(
        NOCOUNT NOSUM AVERAGE NOMAXIMUM NOMINIMUM NOUSS NOCV NORANGE
        NOVARIANCE NOSTD NONMISS
        )
    ;

  CREATE VARIABLE NAME=STATUS EXTNAME=STATUS
    SUBJECT='N/A' LABEL='Final Status Code'
    DESCRIPTION='Final Status Code'
    FORMAT=.
    TYPE=CHARACTER LENGTH=1 INTERPRET=STRING KEPT=YES
    ;

  CREATE VARIABLE NAME= HOUR
    EXTNAME='HOUR'
    LABEL='Hour of day'
    DESCRIPTION='Hour_of_day'
    KEPT=YES VALIDITY=. INTERPRET=INT TYPE=NUMERIC
    LENGTH=4 FORMAT=2. INFORMAT=. IDNUM=.
    OID= .
    SUBJECT='N/A' ;

  CREATE VARIABLE NAME= SHIFT
    EXTNAME='SHIFT'
    LABEL='Operations shift'
    DESCRIPTION='Operations_shift'
    KEPT=YES VALIDITY=. INTERPRET=STRING TYPE=CHARACTER
    LENGTH=1 FORMAT=. INFORMAT=. IDNUM=.
    OID= .
    SUBJECT='N/A' ;

/*----------------------------------------------------------*
| Default table ordered using DATETIME HOUR and SHIFT.
*----------------------------------------------------------*/

UPDATE TABLE NAME=UFAXES
  DETAIL=(byvars='DATETIME HOUR SHIFT ' )
  DAY=(classvars='DATETIME HOUR SHIFT ' )
  WEEK=(classvars='DATETIME HOUR SHIFT ' )
  MONTH=(classvars='DATETIME HOUR SHIFT ' )
  YEAR=(classvars='DATETIME HOUR SHIFT ' ) ;