It doesn't solve the table access requirement, but the following could be a helpful 'shot gun' approach to STP logging:  https://rawsas.com/event-logging-of-stored-process-server-sessions/ If you'd like to track and control (manual) changes to tables in SAS, our team also produces this product, which is free for 5 users:  https://datacontroller.io ... View more

You can log events as part of the stpinit program More info: https://rawsas.com/event-logging-of-stored-process-server-sessions/ ... View more

Hi, well, that means something other than encoding is causing the issue. I think your best resource might be opening a track with Tech Support. Cynthia ... View more

Hello Sanjeev,   Just to confirm if you have one variable called language with the value of Two diff language in to your entaire dataset then please try with the global filter with drop down list which has selection of language so that the below entier report will be filterd with selected language data values..   Pls tell me if no need more clearity on it..........     Jim... ... View more

What is an alternate way to do this?  I'm working with two pie charts and would like the interaction to exist between the two.  Right now if I do an interaction from pie chart 1 to pie chart 2, it works great.  However, I want to also have an interaction from pie chart 2 to pie chart 1.  I'm in version 7.3, looking for suggestions on how to accomplish this. ... View more

Thank you for your response, I did go ahead and used a separate file.  I then created a parameter which was used throughout my report. ... View more

One option worth exploring might be two drop down lists, the first less granular one filtering the second as discussed in this post:   https://communities.sas.com/t5/SAS-Visual-Analytics/How-to-filter-a-filter-in-SAS-VA/m-p/230692#M2687   ... View more

Be careful with your macro parameter names. If you use a name for a macro parameter that is also used as the name of a global macro variable, you implicitly create a local (to the macro) macro variable that takes precedence over the global one. When you then call the macro without explicitly supplying parameters, those local macrovars stay empty. For the sake of less typing, I would use shorter names for macro parameters, and maybe prefix them with the macro name.   eg %macro validate(validate_date_a, validate_date_b); As it is, your macro with the given values would do nothing, as VariableToStoreLastDateTbleB (20160831) is smaller than VariableToStoreLastDateTbleA (20160930) ... View more

This is most likely caused by the lack of a CONTENT_TYPE option set for the attachment as shown here:   filename mymail email "Somebody@abc.com" subject="SAS Test" attach=("Test.xls" content_type="application/xls" ); ... View more

Change your third argument to INTNX to 0 Make sure you're working with a DATE variable, datepart() function Interval is QTR/QUARTER   INTNX('QTR',datepart(t2.end_date),0,'B') ... View more

I recently ran into an example of an XLS file that Excel said was corrupted and couldn't get it to open in Excel. But proc import could read it. I take that as another reason to avoid Excel format files and recommend considering CSV. Yes CSV doesn't support multiple tabs. Since you say this is proc report output perhaps RTF would be acceptable. ... View more