Example: Transforming the Data in the Sashelp.PriceData Data Set

To create this example:

In the Tasks section, expand the Forecasting folder, and then double-click Time Series Data Preparation. The user interface for the Time Series Data Preparation task opens.
On the Data tab, select the SASHELP.PRICEDATA data set.

Tip
If the data set is not available from the drop-down list, click . In the Choose a Table window, expand the library that contains the data set that you want to use. Select the data set for the example and click OK. The selected data set should now appear in the drop-down list.

Assign columns to these roles:

Click the Transformations tab and specify these values for the sale variable.
- From the Accumulation drop-down list, select Sum.
- From the Transformation drop-down list, select Logarithmic.
- In the Simple Difference box, enter 1.
- In the Seasonal Difference box, enter 0.
For the price variable, select Sum from the Accumulation drop-down list.
On the Output tab, select the Show output data check box. In the Number of observations to show box, enter 10.
To run the task, click .

The results show the first 10 observations in the output data set.