White Papers
Finding Time: SAS and Data Warehouse Solutions for Determining Last Day of the Month
Overview This paper presents the different ways a SAS programmer can automate the extraction of time series data from the warehouse where data are stored, by the last day of each month, in the column monthend date (ME_DT). The goal is to run programs and create data sets for each month with minimal program changes and no manual intervention: taking a point in time and going back months, quarters, and fiscal or calendar years for historical data, adjusting for leap years (eg, 2004, 2000, 1996) and last day of the month (28, 29, 30, 31). The two SAS solutions are a MACRO and the INTNX function.
| Publisher | SAS Institute | File Format | |
|---|---|---|---|
| Date Published | March 2003 | Downloads | 1 |
| Format | White Papers | ||
| Topics |
|
||
-
Did you find this white paper useful?
White Paper RSS
Download
Register
