topic Re: Proc Expand in SAS Forecasting and Econometrics

Proc Expand

toddtodd — Tue, 16 Jul 2013 18:14:50 GMT

For some reason I cannot figure this simple thing out.

I am using proc expand to convert a daily time series into a monthly series. I do not want to fit the data using the variety of options. I would like to take the end of month value in the daily time series and use those value to create a monthly time series. However, I am not sure what option I use.

Thank you,

Todd

Re: Proc Expand

udo_sas — Tue, 16 Jul 2013 20:51:12 GMT

Hello -

What about using PROC TIMESERIES instead?

proc timeseries data=sashelp.citiday out=monthly plot=series;

id date interval=month accumulate=last;

var dsiukas;

run;

Thanks,

Udo

Re: Proc Expand

toddtodd — Wed, 17 Jul 2013 00:38:23 GMT

Thank you Udo. That worked.

Re: Proc Expand

udo_sas — Wed, 17 Jul 2013 17:57:46 GMT

Todd -

Great - if time permits, please mark this entry as answered.

Thanks,

Udo

Re: Proc Expand

toddtodd — Fri, 02 Aug 2013 20:39:50 GMT

I just upgraded to SAS 9.3. I used the following to change daily values to one end of month value. It worked in 9.2 but it does not work in 9.3. Any idea why?

proc timeseries data=work.MA out=MA_monthly plot=series;

id date interval=month accumulate=last;

var MA_alloc_daily;

run;

I get the following message:

[Fatal Error] :1:8: The processing instruction target matching "[xX][mM][lL]" is not allowed.

Internal Exception:org.xml.sax.SAXParseException: The processing instruction target matching

"[xX][mM][lL]" is not allowed.

org.xml.sax.SAXParseException: The processing instruction target matching "[xX][mM][lL]" is not

allowed.

at org.apache.xerces.parsers.DOMParser.parse(Unknown Source)

at org.apache.xerces.jaxp.DocumentBuilderImpl.parse(Unknown Source)

at com.sas.graphics.app.StatGraphSSR.parseXML(StatGraphSSR.java:499)

at com.sas.graphics.app.StatGraphSSR.render(StatGraphSSR.java:197)

Problem reading XML

java.lang.NullPointerException

at com.sas.graphics.applets.statgraph.StatGraph.getSessionLocale(StatGraph.java:3632)

at com.sas.graphics.app.StatGraphSSR.render(StatGraphSSR.java:205)

java.lang.NullPointerException

ERROR: Physical file does not exist, C:\Users\Todd\AppData\Local\Temp\SAS Temporary

Files\_TD9404_TFELDMANE6430_\_20C3F95075E4D4DA951C23DCEEC2DF6.bmp.

ERROR: Physical file does not exist, C:\Users\Todd\AppData\Local\Temp\SAS Temporary

Files\_TD9404_TFELDMANE6430_\_20C3F95075E4D4DA951C23DCEEC2DF6.bmp.

Re: Proc Expand

udo_sas — Sun, 04 Aug 2013 23:37:51 GMT

Hello -

Typically I would suggest to contact Technical Support for these kinds of problems. However, this usage note: http://support.sas.com/kb/40896.html might be useful.

Thanks,

Udo