SAS Support Communities

rgreen33 · ‎10-16-2020

I am working on a script in SAS Studio (Viya). I need to reference a file in My Folder or SAS Content. How can I find the path of my file so that it can be used in my script? Everything that I try keeps give me the following error: Physical file does not exist. Thanks, Ricky

rgreen33 · ‎10-16-2020

We are moving from VA 9.4 to Viya. Several of our reports have tabbed pages. In VA 9.4, the tabs appeared at the top of the report, with the report controls under them. In Viya, it appears that the report controls are now on the top and the tabs appear below them. The tab fonts are kind of small and kind of blend in as text. Is there a way in Viya to make the tabs more prominent? Thanks, Ricky

rgreen33 · ‎10-12-2020

Thank you @joeFurbee. I will check these out too!

rgreen33 · ‎10-12-2020

Perfect! This is exactly what I was looking for! Thank you @gwootton

rgreen33 · ‎10-12-2020

We are in the process of switching to Viya. I have my Viya environment pulling users and groups (some nested) from Active Directory. I am using Row-Level Filtering on many of my data sets, based on "... IN ('SUB::SAS.IdentityGroups')". As an administrator, I would like to have a script that I can run for trouble-shooting that will list, for any given user, their SAS.IdentityGroups...as Viya would see them in the Row-Level Filtering. Is this possible? I have searched, hoping that a SAS Studio script that might be usable, but I have not found anything. Any help on this matter would be greatly appreciated.

rgreen33 · ‎12-14-2017

@SASKiwi, Thanks again for the info. I had not thought about the idea of using a stored process for this (even though I am using a stored process to pull my job schedules from Metadata to a SAS VA Report). That might just work. 🙂 Another option that I found would be to leave the data in SAS and use SAS Visual Analytics Explorer. Since this tool is not included in mobile bi, you are not bound by the 250,000 cell limit. In reality, the user could probably do everything that he/she wants to do in SAS Visual Analytics Explorer. We are fairly new to SAS, so we are just learning the capabilities of all of the tools...and doing a slow rollout of each of them. So, SAS Visual Analytics Explorer may become a part of our toolbox soon. Thanks again, Ricky

rgreen33 · ‎12-11-2017

@SASKiwi, Thank you for the reply. I had already stumbled across that document...and I too thought that the 5,000 records seemed very low. However, your reply did prompt me to start looking at other things...and after more digging, I think that I stumbled across the cause for our issue. As I mentioned, the dataset being returned is very wide...as in 106 columns wide. It appears that in addition to the High-Cardinality thresholds, we are also bound by the properties of the Visual Analytics Transport Service...particularly, the property "viewerservices.default.max.cells.produced". This property dictates the number of data cells that can be delivered to a mobile device for a single data query...and the default value is 250,000. Thus, when our List Table contains 106 columns, the maximum number of rows that can be returned is 2,358...which is exactly the behavior that we are seeing. Thanks again, Ricky

rgreen33 · ‎12-08-2017

Was a solution found for this? We are using VA 7.4 and we are trying to solve this exact same issue. Any ideas would be greatly appreciated. Thanks, Ricky

rgreen33 · ‎12-08-2017

We have a few "self-service" reports which essentially contains several filters and a single List Table. The purpose of these reports is to allow our users the ability to export as much or as little data as they would like to MS Excel and then work with it in ways that are not available in other reports (in other words, this is for the "do it yourselfer"). Obviously, these List Tables are very wide with many columns. The problem that I am encountering is that the number of rows returned is around the 5,000 range...and I need for this to be much higher. Also, when I attempt to export this data from SAS VA 7.4 modern viewer report to MS Excel, the export pop-up forces me to select a range of 1 to "much less than 5,000" rows. Can these limits be increased? If so, how? I have searched the web and looked thru the settings for VA in Management Console, but nothing is standing out to me as being the obvious values to change. Any help would be greatly appreciated. Thanks, Ricky

rgreen33 · ‎12-08-2017

Thank you for the info. I think that I will be able to work with this to come up with a solution. Thanks, Ricky

rgreen33 · ‎12-08-2017

I have been testing these changes in my INI file and it does appear that this has fixed my issue too. Thanks for your help, Ricky

rgreen33 · ‎12-07-2017

In SAS Visual Analytics, I have a folder that contains 12+ reports that are all related. On each of these reports, I would like to create a tab that provides the user with a listing of the other reports in this folder (with HTML links). Has anyone done this? Or, does anyone have any ideas on how this could be done? I would like for this list to be dynamic (reading from the system) as new reports may be added in the future...and I don't want to have to update every single report. Obviously, one way to accomplish this would be to build a dataset and manually maintain the information in the dataset and read that into SAS VA report. However, I would like for this to be automated for my developers (and myself as I will be promoting any new reports from dev to prod). So, maybe something like a stored process or scheduled job that pulls the data from the system...but, how would I pull this info? Any ideas would be greatly appreciated. Thanks, Ricky

rgreen33 · ‎10-24-2017

@alexal Thanks again for your reply. I added this code to my job, but it failed...messages stated that the levels could not be set. So, going back to your original suggestion... Looking at my server, I see that I have the LOGCONFIGLOC set in the following folders: WorkspaceServer; StoredProcessServer; PooledWorkspaceServer; ConnectServer; and BatchServer. I have enabled ACM and APM on my server, thus the sasv9_usermods.cfg file is pointing me to the logconfig.apm.xml file for the logconfigloc (within each folder). Since these are scheduled jobs that are failing, I am assuming that I will need to add these loggers to the logconfig.apm.xml file within the BatchServer folder. Is this correct? If so, then I am also assuming that I will need to restart the BatchServer to get this change to take affect. Is this correct? If so, the only other question that I would have is where would this logging information show up? Would it show up in the /BatchServer/PerfLogs folder, as this is indicated in the logconfig.apm.xml file? Thanks, Ricky

rgreen33 · ‎10-24-2017

@nhvdwalt Thank you for the reply. No, they are very short running jobs...some loading less than 1,000 rows of data. Thanks, Ricky

rgreen33 · ‎10-24-2017

@alexal Thank you for your reply. I am fairly (really) new to SAS. I have not yet had the opportunity to use loggers...so, this is new to me. Can you give me some details on where this goes and where the info will be logged to? Also, once this is added to the correct location, does anything need to be restarted or will it automatically pick these setting up? Thanks, Ricky

Online Status	Offline
Date Last Visited	‎08-09-2022 04:12 PM

SAS Support Communities

Re: Need to insert rows into work.temp inside of proc cas block

Need to insert rows into work.temp inside of proc cas block

Re: Reloading in-memory table when sashdat file has been replaced

Re: Reloading in-memory table when sashdat file has been replaced

Reloading in-memory table when sashdat file has been replaced

Sort Schedule Chart by Start Time (X Axis)

Re: How can I get the status of a failed job and send alert via schedu...

Re: How can I get the status of a failed job and send alert via schedu...

How can I get the status of a failed job and send alert via scheduled ...

How can I get a list of schedules (on jobs)?

Re: Reloading in-memory table when sashdat file has been replaced

SAS VA 7.4 Heat Map Color Issue

Re: SAS VA 7.4 (modern viewer) - limits on rows returned and exported ...

Re: DI Studio Job: Status Handling/Send Email - how can I include HOST...

Re: SAS Add-In - Failed to create SAS Folders (Error from MS Outlook)

Re: Need to insert rows into work.temp inside of proc cas block

Reloading in-memory table when sashdat file has been replaced

Re: SAS VA 7.4 (modern viewer) - limits on rows returned and exported ...

CLI error connecting to SQL Server

Re: We just enabled ACM ETL Processing today - when will reports show ...

From SAS Studio (Viya), how do I reference a file that is stored in My...

Can we make report tabs more prominent?

Re: How can I get a listing of SAS.IdentityGroups (used in Row-Level F...

Re: How can I get a listing of SAS.IdentityGroups (used in Row-Level F...

How can I get a listing of SAS.IdentityGroups (used in Row-Level Filte...

Re: SAS VA 7.4 (modern viewer) - limits on rows returned and exported ...

Re: SAS VA 7.4 (modern viewer) - limits on rows returned and exported ...

Re: VA 7.1 - Select the most recent date in a Dropdown list

SAS VA 7.4 (modern viewer) - limits on rows returned and exported to E...

Re: Need help creating a dynamic list of html links to reports in a pa...

Re: CLI error connecting to SQL Server

Need help creating a dynamic list of html links to reports in a partic...

Re: CLI error connecting to SQL Server

Re: CLI error connecting to SQL Server

Re: CLI error connecting to SQL Server

SAS Global Forum 2017

Follow Us

What is...