Hello.  I am using SAS Visual Analytics 7.5 and I cannot upgrade to Viya.  I would like to know if the name of report objects (i.e. list table 1, crosstab 1), names of filters for data sources, and/or names of filters for report objects are saved somewhere in metadata.  I am currently using the Metadata Browser in base SAS to search for these items but I have been unsuccessful.  Thanks! ... View more

Hello all.  I'm using VA 7.4.  I wasn't sure where to post this question.  I have an upcoming audit where I need to be able to show each VA user's access to individual data elements within the VA reports.  Currently, users are assigned to a group based on their role at our organization.  I also use Access Control Templates to set an access level on the Visual Analytics reports.   I need to know the name of the VA reports that all SAS users have access to AND I need to know the data elements that are being USED by each VA report.  I can determine the first requirement by using the sas-relationship-reporter.exe, SAS Environment Manager, and/or querying metadata.  However, I can't seem to figure out which data elements are actually being USED by the VA report.  I feel like this information may be stored in metadata somewhere because when I am using VA Report Designer, on the Data tab there is an option that I can select that reads, "Only Show Used Items".  I'm hopeful that there is an automated way to find this information because doing this manually for each user will be extremely tedious and time consuming.   Thanks for reading. ... View more

I've had some intermittent problems with the process flow on some of my EG projects. Occasionally, I will open an EG project and it appears empty (no programs, no process flow). After searching the forums, I found that right-clicking in the "Project Tree" area and selecting "Refresh" would bring back the programs in the project tree. However, I have found no solution for bringing back the process flow. This is very problematic because I have the process flow scheduled to run every hour and this doesn't work when the EG project gets in this state. I also noticed that the project name isn't populated at the upper-left corner of the EG application when I open projects that are in this state. It is almost like the application fails to completely open but I do not get an error message of any type.   Prior to this issue, I was receiving an error message about a "valid GIT repository". Per one of the SAS problem notes, I changed the GIT repository location (I can't find this problem note now). After making this change, I quit getting the "valid GIT repository" error but it was about this time that I began getting the issue described in the first paragraph. Perhaps these things are related? ... View more

Hello.  Can PROC SGPLOT be used in a SAS stored process?  For example, the code below runs fine on SAS Enterprise Guide but when I try to use it in a stored process I get a blank rectangle where the chart should be and an error that reads, "STP: A failure occurred in the Execution Context post processing." proc sgplot data=have; pbspline x=year_num y=unique_count / group=del_method datalabel=unique_count; yaxis min=0 max=10000; run; ... View more

Hello.  I am new to the administration side of SAS but I have been developing reports for quite a while.  I've been monitoring the disk space used on the SAS server and I noticed that the disk usage has been steadily increasing, unexpectedly, since May 2019.  I first looked at orphaned work files but those don't seem to be an issue since I started running cleanwork.exe on a daily basis in May of 2019.  Next, I looked at my metadata server logs and I believe that may be where my problem lies.  I have some very old logs dating back to 1/1/2018.  Another thing I noticed about the daily logs is that their size had been steadily increasing from 1/1/2018 (1.3 MB) to 5/1/2019 (50MB) and then the size of the daily log jumped dramatically overnight from approximately 50MB to 225+ MB in May of 2019.  The 225MB level has been maintained ever since.  Also since May 2019, it looks like there are more instances of multiple logs per day (one large and the others smaller).   Is there any reason that I cannot or should not delete old server logs?  If not, are there any rules-of-thumb about how many days of logs that I should keep? Two things happened in May that I know about.  1) I started running cleanwork.exe nightly. 2) I started running a script in EG, hourly, that creates/updates multiple datasets and then autoloads them into memory.  Could either of these things be causing the large jump in server log size? Are there any other daily logs that I could/should delete after a period of time? Thanks for your time. ... View more

Hello.  Is there a way to display a measure as a date in a crosstab in Visual Analytics?  I'm not asking about displaying a date as a row or column.  I'm asking how to display the crosstab cells (measure) as a date.  I see there are numerous formats (comma, currency, dollar, euro, etc.) that can be applied but displaying a number as a date doesn't appear to be one of them.  I'm trying to show, in crosstab form, the date an event (column) occurred for an individual (row).  I've tried using a normal list for this but the crosstab output is much preferred. ... View more