Turn on suggestions

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

Showing results for

- Home
- /
- Analytics
- /
- Forecasting
- /
- How to time series forecasting for a univariate data through neural ne...

Options

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

🔒 This topic is **solved** and **locked**.
Need further help from the community? Please
sign in and ask a **new** question.

- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content

Posted 02-12-2016 07:24 AM
(2116 views)

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.

1 ACCEPTED SOLUTION

Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content

13 REPLIES 13

- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content

Do you have SAS Enterprise Miner?

- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content

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
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content

Will be of great help

- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content

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
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content

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
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content

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

Do you have SAS IML?

- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content

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

Do you have SAS IML?

- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content

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

- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content

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
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content

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

- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content

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
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content

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
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content

**Don't miss out on SAS Innovate - Register now for the FREE Livestream!**

Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.

Multiple Linear Regression in SAS

Learn how to run multiple linear regression models with and without interactions, presented by SAS user Alex Chaplin.

Find more tutorials on the SAS Users YouTube channel.