topic How do I perform time series forecasting - data preparation? in SAS Studio

How do I perform time series forecasting - data preparation?

amalie1 — Mon, 30 Jan 2017 12:56:01 GMT

Hi,

I have imported a data set with two columns; one with Date (dd/mm/yy) and one with revenue.
The dates are the end of quarter dates e.g. 31/03/2014 - 30/06/2014 - 30/09/2014

I would like to make a forecast on it.

In the import - the data looks fully imported and creates a table.

However, after I run the file in the data preparation section under forecasting - the fields becomes blank.

I assign the Date column the role of Time ID with quarter intervals and I have revenue as the time-series variable.

I have just been following the tutorial guide at SAS training.

Thank you for your help.

I am on the SAS university Edition.

Re: How do I perform time series forecasting - data preparation?

Shmuel — Mon, 30 Jan 2017 16:10:21 GMT

please post:

- 10 test data with few lines

- code you tried to run

Re: How do I perform time series forecasting - data preparation?

amalie1 — Mon, 30 Jan 2017 18:04:01 GMT

Thank you for your reply.

Attached please find code output and test data.

Re: How do I perform time series forecasting - data preparation?

ballardw — Mon, 30 Jan 2017 20:18:09 GMT

Many users here don't want to download Excel files because of virus potential, others have such things blocked by security software. Also if you give us Excel we have to create a SAS data set and due to the non-existent constraints on Excel data cells the result we end up with may not have variables of the same type (numeric or character) and even values.

Instructions at https://communities.sas.com/t5/SAS-Communities-Library/How-to-create-a-data-step-version-of-your-data-AKA-generate/ta-p/258712 show how to create datastep code from a SAS data set to provide full data that can be used with code.