Forecasting using SAS Forecast Server, SAS/ETS, and more

How to handle negative value in Proc X11

Reply
Super Contributor
Posts: 266

How to handle negative value in Proc X11

Hi ,

 

I am trying to use proc X11 to forecast my sales. 

But i am facing a problem that there is a negative value in my time series(due to return on that particular month).

please suggest me if there is any solution in proc x11 to handle this situation or do i need to handle it other way arround?

 

Thanks in advance.

Frequent Contributor
Posts: 108

Re: How to handle negative value in Proc X11

You can use MODE=PSEUDOADD if you have - values.Or if you adjust that units ..My Knowledge Ends here ..
Super Contributor
Posts: 266

Re: How to handle negative value in Proc X11

Posted in reply to pearsoninst

can u please help me where can i put this option?

my syntax is :

proc x11 data= test yraheadout;

monthly date=month;

var=sales;

table d11;

output out =test1 b1=a d10=b d11=c;

run;

Super Contributor
Posts: 266

Re: How to handle negative value in Proc X11

Posted in reply to pearsoninst
can u please help me where can i put this option?
my syntax is :
proc x11 data= test yraheadout;
monthly date=month;
var=sales;
table d11;
output out =test1 b1=a d10=b d11=c;
run;
SAS Employee
Posts: 416

Re: How to handle negative value in Proc X11

Hello -

Have a look at the X12 (or X13 in SAS/ETS 14.1) procedure instead.

The MODE= option is supported in the X11 statement of these procedures.

Thanks,

Udo

Ask a Question
Discussion stats
  • 4 replies
  • 522 views
  • 0 likes
  • 3 in conversation