Proc Expand

[toddtodd]

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

[udo_sas · Accepted solution]

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

[toddtodd]

Thank you Udo. That worked.

[udo_sas]

Todd -

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

Thanks,

Udo

[toddtodd]

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.

[udo_sas]

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