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
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
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
Thank you Udo. That worked.
Todd -
Great - if time permits, please mark this entry as answered.
Thanks,
Udo
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.
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
Join us for SAS Innovate 2025, our biggest and most exciting global event of the year, in Orlando, FL, from May 6-9. Sign up by March 14 for just $795.
Learn how to run multiple linear regression models with and without interactions, presented by SAS user Alex Chaplin.
Find more tutorials on the SAS Users YouTube channel.