7. Writing Field-developed Applications › 7.3 Writing the Code › 7.3.2 Define the Input Format Routine (DYfdaFMT) › 7.3.2.1 Define a non-MSI Input Format Routine (DYfdafmt) › 7.3.2.1.1 - Define Non-database Files (USRFMT1)

Previous Topic: 7.3.2.1 Define a non-MSI Input Format Routine (DYfdafmt)

Next Topic: 7.3.2.1.2 Define Input Record Validation (USRFMT2)
7.3.2.1.1 - Define Non-database Files (USRFMT1)
 The USRFMTn macros are executed as part of the main SAS DATA
 step in DYfdaFMT.
 
 Use the USRFMT1 macro to add non-database oriented files to
 the SAS work files that will be written by the input format
 routine.  (One work file is created for each database file
 that will exist in the DETAIL timespan.)
 
 If you need an additional work file, you must code its file
 name and the KEEP list in USRFMT1.
 
 Example:
 
   %MACRO USRFMT1;
     WORK.MYFILE (KEEP ENDTS STARTTS INTERVLS)
   %MEND USRFMT1;
 
 resolves to
 
   DATA
    WORK.UNPUNA00  (KEEP=%UNAKEEP (TS=DETAIL))
    &ADMX..CKPTDATA (LABEL='INPUT STATISTICS FOR CURRENT DATA'
                     KEEP=%WHLKEEP (TS=DETAIL))
    WORK.MYFILE (KEEP=ENDTS STARTTS INTERVLS);
 
 and enables you to generate observations to WORK.MYFILE
 whenever you need to.