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

Proc Expand

Accepted Solution Solved
Reply
Contributor
Posts: 20
Accepted Solution

Proc Expand

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


Accepted Solutions
Solution
‎07-16-2013 04:51 PM
SAS Employee
Posts: 416

Re: Proc Expand

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

View solution in original post


All Replies
Solution
‎07-16-2013 04:51 PM
SAS Employee
Posts: 416

Re: Proc Expand

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

Contributor
Posts: 20

Re: Proc Expand

Thank you Udo. That worked.

SAS Employee
Posts: 416

Re: Proc Expand

Todd -

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

Thanks,

Udo

Contributor
Posts: 20

Re: Proc Expand

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 ExceptionSmiley Surprisedrg.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.

SAS Employee
Posts: 416

Re: Proc Expand

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

☑ This topic is SOLVED.

Need further help from the community? Please ask a new question.

Discussion stats
  • 5 replies
  • 635 views
  • 2 likes
  • 2 in conversation