Write and run SAS programs in your web browser

How do I perform time series forecasting - data preparation?

Accepted Solution Solved
Reply
New Contributor
Posts: 2
Accepted Solution

How do I perform time series forecasting - data preparation?

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. 

 


Accepted Solutions
Solution
‎02-05-2017 06:50 AM
Grand Advisor
Posts: 9,732

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

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-dat... show how to create datastep code from a SAS data set to provide full data that can be used with code.

View solution in original post


All Replies
Super User
Posts: 1,077

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

please post:

  -  10 test data with few lines 

  -  code you tried to run 

New Contributor
Posts: 2

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

Thank you for your reply. 

Attached please find code output and test data. 

Attachment
Attachment
Solution
‎02-05-2017 06:50 AM
Grand Advisor
Posts: 9,732

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

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-dat... show how to create datastep code from a SAS data set to provide full data that can be used with code.

Post a Question
Discussion Stats
  • 3 replies
  • 161 views
  • 0 likes
  • 3 in conversation