BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
toddtodd
Calcite | Level 5

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

1 ACCEPTED SOLUTION

Accepted Solutions
udo_sas
SAS Employee

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

5 REPLIES 5
udo_sas
SAS Employee

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
Calcite | Level 5

Thank you Udo. That worked.

udo_sas
SAS Employee

Todd -

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

Thanks,

Udo

toddtodd
Calcite | Level 5

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
SAS Employee

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

sas-innovate-white.png

Register Today!

Join us for SAS Innovate 2025, our biggest and most exciting global event of the year, in Orlando, FL, from May 6-9.

 

Save $200 when you sign up by March 14!

Register now!

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