turn on suggestions

Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

Showing results for

Find a Community

- Home
- /
- Analytics
- /
- Forecasting
- /
- How to time series forecasting for a univariate da...

Topic Options

- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Email to a Friend
- Report Inappropriate Content

02-12-2016 07:24 AM

Hi All,

I am working on forecasting utility I wanted to do time series forecasting for a univariate data through neural network technique.Can somebody help me with the SAS Code.Would be very helpful.I am struck up and need help badly.

I am working on forecasting utility I wanted to do time series forecasting for a univariate data through neural network technique.Can somebody help me with the SAS Code.Would be very helpful.I am struck up and need help badly.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Email to a Friend
- Report Inappropriate Content

Posted in reply to Ateet

02-12-2016 07:28 AM

Do you have SAS Enterprise Miner?

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Email to a Friend
- Report Inappropriate Content

Posted in reply to Ateet

02-12-2016 07:32 AM

No reeza I dont have sas miner i am working pc sas 9.2 could you plz tell me the SAS Code???

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Email to a Friend
- Report Inappropriate Content

Posted in reply to Ateet

02-12-2016 07:39 AM

Will be of great help

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Email to a Friend
- Report Inappropriate Content

Posted in reply to Ateet

02-12-2016 08:56 AM - edited 02-12-2016 08:57 AM

Hello -

Out of curiosity: what's your motivation using neural networks for univariate forecasting?

If you have access to SAS/ETS you may want to start with more classical time series models first, such as exponential smoothing for example (PROC ESM).

Neural networks are currently not available outside of SAS Enterprise Miner - you will need to use either a SAS macro or SAS/IML to code it up yourself. Not sure if it will be worth the effort, though - see: http://www.kestencgreen.com/simplefor.pdf

Thanks,

Udo

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Email to a Friend
- Report Inappropriate Content

Posted in reply to Ateet

02-12-2016 10:38 AM

Hi udo ,

I have already built up exponential smoothing and arima models but wanted to go for complex methods which is neural network.I don't have sas eminer I'm working on pc sas 9.2 with SAS/ETS installed.

Is there any document which talks about sas code for time series forecasting in neural network.Will be of great help.

I have already built up exponential smoothing and arima models but wanted to go for complex methods which is neural network.I don't have sas eminer I'm working on pc sas 9.2 with SAS/ETS installed.

Is there any document which talks about sas code for time series forecasting in neural network.Will be of great help.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Email to a Friend
- Report Inappropriate Content

Posted in reply to Ateet

02-12-2016 10:56 AM

Search on lexjansen.com for sample code, if it exists.

Do you have SAS IML?

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Email to a Friend
- Report Inappropriate Content

Posted in reply to Ateet

02-12-2016 10:56 AM

Search on lexjansen.com for sample code, if it exists.

Do you have SAS IML?

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Email to a Friend
- Report Inappropriate Content

Posted in reply to Ateet

02-12-2016 10:58 AM

Right now I dont have but I can get it installed but is there any technique inside IML? ??

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Email to a Friend
- Report Inappropriate Content

Posted in reply to Ateet

02-12-2016 05:54 PM

Hello -

Not out of the box - but as IML provides you with access to a very powerful matrix language and lots of out of the box methods like non-linear optimization you could build a NN module yourself.

Thanks,

Udo

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Email to a Friend
- Report Inappropriate Content

Posted in reply to Ateet

02-15-2016 02:06 PM

Anybody I want help anyone knows about time series forecasting in neural network??? Would be of great help

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Email to a Friend
- Report Inappropriate Content

Posted in reply to Ateet

02-16-2016 09:51 AM

I did a Google search on Neural Network in SAS Macros and the following SUGI paper showed up. http://people.orie.cornell.edu/davidr/or474/nn_sas_implement.pdf

The paper is rather old but you can at least run a simple verion of neural network model without SAS Enterprise Miner. The neural network model implemented in EM is much faster and have a lot more model training options. Futhermore, EM comes with Random Forests and Gradient Boosting Tree models that are commonly considered for utility forecasting. Something you might consider licensing in the future.

Before getting into too much in the so called machine learning algorithms for utility forecasting, you might consider other modeling approaches that often time out beat the machine learning algorithms. Please check out the follwoing website for more info.

http://www.drhongtao.com/publications

You can also try running UCM models by each hour of the data (assuming the utility series is hourly basis) and use the CYCLE components (basically a bunch sin's and cosin's with different frequencies) to capture multiple seasonalities existing in the hourly data. Here is a sample code to run UCM by each hour for an hourly utility load data:

proc ucm data=load;

id date interval=day;

by hour;

irregular;

level;

cycle period=7 rho=1 noest=(period rho);

cycle period=3.5 rho=1 noest=(period rho);

cycle period=2.3333 rho=1 noest=(period rho);

randomreg cos1-cos16 sin1-sin16;

model eload = dec24 dec25 dec26 jan1 jan6 aug15 easterSat

easterSun easterMon easterTue holidays holySat

holySun bridgeDay endYear;

estimate back=14 plot=panel;

forecast back=14 lead=14 outfor=book.loadfor plot=decomp;

run;

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Email to a Friend
- Report Inappropriate Content

Posted in reply to Ateet

02-16-2016 09:32 PM

Hi alexchien,

Thanks for the update.I appreciate it.Actually Alex I m not working of utility domain data I am actually building forecasting macro in SAS which would accept univariate time series data and run various models on top of it and give best model based on accuracy.I have checked the paper but it seems this macro has lot of bugs.I don't have the time to resolve.So thinking anyone could give me the quick simple neural network code for time series forecasting.Would be of great help to me.

Thanks for the update.I appreciate it.Actually Alex I m not working of utility domain data I am actually building forecasting macro in SAS which would accept univariate time series data and run various models on top of it and give best model based on accuracy.I have checked the paper but it seems this macro has lot of bugs.I don't have the time to resolve.So thinking anyone could give me the quick simple neural network code for time series forecasting.Would be of great help to me.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Email to a Friend
- Report Inappropriate Content

Posted in reply to Ateet

02-17-2016 09:16 AM

I think your best bet is to install SAS EM to gain access to the production quality machine learning algorithms from SAS. You might also consider using SAS/IML to call R nnet package, but you will have to pass the data to and from R which could potentially slow down the procssing time and your code will be a bit more error prone.