Automating Report Dates and Formats Using SAS 9 Software
In many organizations, analysts manually change the SAS code that is used to run routine reports so that it uses current dates. However, analysts can use SAS date functions and formats to create automated macro variables that update all of the dates in a report script. Using macro date variables eliminates the need to manually edit scripts, and these variables can even be used to find current external files without searching for them. Date macro variables enable an analyst to execute report scripts at pre-designated times without ever having to edit the file. This ability can greatly reduce processing time and can also eliminate user error.