Thank you for this information, one main thing to note for anybody coming across this post in the future is I had to modify the stored process itself in the management tool to disable the option to include code for stored process macros, I believe the stored process was defaulting to HTML and ignoring the headers setting the content to .xlsx format.   Additionally for anybody who might be coming across this, the formatting for the URL that I was struggling with was &_username=[Username]&_password=[Encrypted Password] at the end, I was struggling with finding the formatting for a short time.    Thanks! ... View more

Nice! But if I can wish I think it would be nice if this option is remembered. Now I have to check this every time I return to this page. ... View more

@ChrisHemedinger - Exterminate! Exterminate! 😆 ... View more

That is because the WHERE is not run "IN" the data step, put as a filter on the data before it makes it to the data step. ... View more

John.King , There is a built-in sas macro to make it happen. This built-in macro can change any encoding into other encoding: https://go.documentation.sas.com/doc/en/pgmsascdc/9.4_3.5/nlsref/p1g1d26os4w0von1cdfh827foo3r.htm   For example: Change EUC-CN(your sas session is EUC-CN encoding) into UTF-8: %let path= C:\temp\原始的SAS数据集\ ; options validvarname=any; libname x v9 "&path."; /* %COPY_TO_NEW_ENCODING(from_dsname, to_dsname, new_encoding) */ %copy_to_new_encoding(x.have, outdata, utf8) ... View more

By any chance do you  have one or more macros that includes the code of another macro as part? Something that might look similar to: %Macro outer (<parameters>); <some macro code> %Macro inner (<parameters>); <inner macro code> %mend; /*inner macro*/ <other outer macro code> %mend; /*outer macro */ Such nested compilations could be very obnoxious to diagnose when things get interrupted. Long shot, but something to consider. ... View more

The ODS Report Writing capabilities provide granular access to building reports and tables that are data driven.  See this paper for examples and also the SAS documentation.   It may be more than you need, but using these techniques you can create very customized PDF output that has the content you want. ... View more

This workshop was offered in 2023. I don't know if the specific data set is readily available, but exercises like this tend to use the HMEQ data set that is provided in the SAMPSIO library that is included with SAS Viya. ... View more

I wanted to thank everyone for the responses. Sometimes when you are doing general searches on line you bring up an older system no longer being used. We don't have the tools to use even the old system I believe, and won't be able to purchase the newer system either (I am the only one in my unit who uses statistics, most do SQL). Time series models are becoming more important and perhaps this may change in the future. ... View more

@shoin wrote: My apologies Chris, I clicked on the wrong accept as solution ... Hello @shoin, It's easy to correct this: Select Chris's post as the solution after clicking "Not the Solution" in the option menu (see icon below) of the current solution. ... View more

Thank you for the references, I did know of one of them already, but the other two seem promising. ... View more

Yes, it delivered with 25w38.  A few weeks ago. ... View more

Done.   Note: We discourage members from posting sensitive/proprietary information on this public forum, even if the intent is to remove it later. That disrupts the content of course, and as you know most members can edit their own posts only for a limited time after publishing them. ... View more

SAS Energy Forecasting ... View more

Excellent! No, I have not updated the templates. But good news, the same processes and templates still work for building tasks.   By chance, I had to fire up Visual Studio the other day to rebuild/service a task I created a long time ago so that it works with EG 8.6.  All smooth! ... View more