topic Re: How to handle negative value in Proc X11 in SAS Forecasting and Econometrics

How to handle negative value in Proc X11

Aman4SAS — Mon, 23 Nov 2015 07:30:10 GMT

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.

Re: How to handle negative value in Proc X11

pearsoninst — Mon, 23 Nov 2015 08:12:13 GMT

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

Re: How to handle negative value in Proc X11

Aman4SAS — Mon, 23 Nov 2015 09:45:13 GMT

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;

Re: How to handle negative value in Proc X11

Aman4SAS — Tue, 24 Nov 2015 03:22:23 GMT

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;

Re: How to handle negative value in Proc X11

udo_sas — Wed, 25 Nov 2015 15:17:48 GMT

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