Hello,   In SAS Visual Analytics, I have a Drop-down list control to select a date (actually a timestamp in YYYY-MM-DD-HH-MM-SS String format).   I want the control to automatically select the latest value (first list item) by default, so that the report always opens on the current situation without the user having to change the selection manually.   I found some posts mentioning an "Initially select first item" checkbox in the Drop-down list options, but in my environment this option does not appear.   ... View more

Hello, I want to restrict standard users from seeing certain metadata columns (such as Created By, in the SAS Content Browser. Is there a way to: Globally hide or disable specific columns in the content UI? Please advise on best practices or supported options. Thank you. ... View more

Hello,   I'm trying to bulk load group identifiers using the SAS Viya CLI with the following command: ./sas-viya identities bulkload-group-identifiers --file /path/file.csv Here is the content of my CSV file: group,AB,123,wx group,CD,124,yz   However, after running the command, I get the following error:   The Bulk Loading of Group identifiers completed. { "details": [ "Failed creating 2 GROUP identifier(s). See errors reported for more information." ], "error": { "errorCode": 10586, "errors": [ { "errorCode": 10530, "httpStatusCode": 404, "message": "The identity \"AB\" was not found." }, { "errorCode": 10530, "httpStatusCode": 404, "message": "The identity \"CD\" was not found." } ], "httpStatusCode": 400, "message": "The input used to bulk load identifier values was not valid." } }     If anyone has a working example or a correct way to create groups in bulk using a CSV file, I would really appreciate your help or any guidance. Thanks in advance! ... View more

Hi everyone, I’m working in SAS Viya 4, and I’m wondering if it’s possible to create and manage groups directly from SAS Studio (without using SAS Environment Manager). In addition to that, is there any way to manage row-level filters on datasets from SAS Studio, such as assigning specific users or groups to see only certain rows based on filtering rules? Any guidance or suggestions would be appreciated. Thanks in advance! ... View more

Hi everyone, In SAS Studio, I can retrieve the currently logged-in user using &SYSUSERID.   In SAS Visual Analytics (VA) on SAS Viya 4, I’m trying to achieve something similar. I have a dataset with a column named "user" that contains usernames. I want to filter this dataset within a VA report so that each user sees only the row(s) corresponding to their username. I tried applying a data filter using the following expressions: user = 'SUB::SAS.Userid' UpCase(user) = UpCase('SUB::SAS.Userid') However, in both cases, the filter returns 0 rows, even though the "user" column contains the exact username of the account I'm using to connect to the report.   How can I dynamically filter the data in SAS VA to show only the rows for the current logged-in user?   Thanks in advance for any guidance! ... View more

Hello everyone, I’m currently using SAS Viya and able to successfully connect to Hive using the following libname statement: libname var hadoop user='user' pwd='{SAS002}xxxxxxxxxxxxxxxxxx' server='10.10.10.10' port=10000 schema=schema_name;   I would like to know if it’s possible to establish a similar connection between SAS Viya and ClickHouse.   Any guidance or shared experience would be appreciated! ... View more

I am currently working with SAS Visual Analytics and Hadoop, and I would like to display the output of an SQL query from Hadoop directly in a report in SAS Viya, without creating a table or view in SAS. Is it possible to execute SQL queries on Hadoop data live and display the results immediately in a SAS Visual Analytics report, without storing the data in an intermediate table or view? If so, how can I achieve this using Live Data Connections or any other functionality in SAS Viya? Any guidance or resources on this would be greatly appreciated. ... View more