Chapter Contents
Chapter Contents
Previous
Previous
Next
Next
The DATASOURCE Procedure

Structure of a SAS Data Set Containing Time Series Data

SAS procedures require time series data to be in a specific form recognizable by the SAS System. This form is a two-dimensional array, called a SAS data set, whose columns correspond to series variables and whose rows correspond to measurements of these variables at certain time periods.

The time periods at which observations are recorded can be included in the data set as a time ID variable. The DATASOURCE procedure does include a time ID variable by the name of DATE.

For example, the following data set, extracted from a CITIBASE data file, gives the foreign exchange rates for Japan, Switzerland, and the United Kingdom, respectively.

Time ID Time Series
variable Variables
DATEEXRJANEXRSWEXRUK
SEP1987143.2901.50290164.460
OCT1987143.3201.49400166.200
NOV1987135.4001.38250177.540
DEC1987128.2401.33040182.880
JAN1988127.6901.34660180.090
FEB1988129.1701.39160175.820

Figure 10.1: The Form of SAS Data Sets Required by Most SAS/ETS Procedures

Chapter Contents
Chapter Contents
Previous
Previous
Next
Next
Top
Top

Copyright © 1999 by SAS Institute Inc., Cary, NC, USA. All rights reserved.