Fax Appendix 5: Sample Code for Updating the Definitions | |
We could apply the following CPDDUTL control statement to the PDB after applying the generated control statements in Fax Appendix 4: Sample Table and Variable Definitions to the PDB. This UPDATE statement modifies the lists of BY and CLASS variables for this table, adding further categorization information.
UPDATE TABLE NAME=UFAXES DETAIL=(byvars='MACHINE TYPE COUNTRY ACODE DATETIME HOUR SHIFT ' ) DAY=(classvars='MACHINE TYPE COUNTRY ACODE DATETIME HOUR SHIFT ' ) WEEK=(classvars='MACHINE TYPE COUNTRY ACODE DATETIME HOUR SHIFT ' ) MONTH=(classvars='MACHINE TYPE COUNTRY ACODE DATETIME HOUR SHIFT ' ) YEAR=(classvars='MACHINE TYPE COUNTRY ACODE DATETIME HOUR SHIFT ' ) ;
Additionally, we could update variable attributes. A good example of such an update would include updating a variable's display format, as shown in Figure 3 - Updating the Data Dictionary to Associate a SAS Display Format as an Attribute of a Variable in Generic Collector Appendix 4: Other Considerations.
For more information about applying (running) a control statement, see Fax Appendix 3: Sample Code for Generating the Definitions. For more about the %CPDDUTL macro and its control statements, see the Macro Reference documentation for IT Service Vision.