Hi I have a file uploaded to a big data platform showing correct d.p but somehow when our clients see the same file via ODBC, the decimal place change from 4 to 2, how did that happen? Do I need to setup schema for showing data via ODBC or there is specific settings required dealing with?
... View more
Hi , I have SAS jobs in SAS EG. For each job, I would like to have related output tables (after Table Loader Step). E.g. I have a JOB_A with two output (TABLE_A & TABLE_B) I would like to have something like: JOB_A | TABLE_A JOB_A | TABLE_B I don't know how to perform this with SAS code? Can you help with this? Thanks
... View more
In VA I created a 100% stacked bar chart with labels per segment. The percentage value is shown with 2 decimals. How can this be changed to 1 decimal? Aantal is the measured variable (Frequencypercentage cannot be used here.) Thanks for suggestions. Jurgen
... View more
Hi, do you guys ever work with Verhoeff check digit algorithm (https://en.wikipedia.org/wiki/Verhoeff_algorithm) with SAS? I am trying to use sas for verhoeff check digit but havent found any script to do so.
... View more
Hi,
I am new to SAS Admin. I am looking to give read-only permission to Redshift tables in SAS DI Studio for a specific SAS user group in PROD environment.
Example:
CDP SAS Users Group - I have assigned it to Redshift Read Only Users
I have 2 set of auth domains I have created for 2 groups
I have a library to Redshift access using CDP_Redshift_Prod as the write access to Redshift. See below
LIBNAME ROCOUR SASIORST DSN=prod_cdp_ods_sas SCHEMA=xxxx AUTHDOMAIN="CDP_Redshift_Prod" ;
My issue is, I only want to give users of the CDP SAS Users to have read-only metadata and read only data to the redshift tables. How can I achieve this as I cannot change the configuration of the existing library to use CDP_Redshift_Prod_RO.
I tried using the Redshift Write Users group to CDP SAS Users and giving only read only via ACT but I can still write to the Redshift table.
Any help you be more than welcome.
... View more