Hi @KevinViel  For repeatability, How about adopting the following? Version Control: Git/GitHub/GitLab/Bitbucket (pick your personal/corporate choice) SAS Macros: Use Stored compiled SAS macros https://www.lexjansen.com/pharmasug/2006/ApplicationsDevelopment/AD05.pdf Check-in your SAS compiled Macros Catalog (Binary File) into your Version Control Repository and tag it with a Release ##      This will allow and your team to Check-out/Clone the specific Release(s) as and when needed     Hope this helps ... View more

Hi @navdeepk  Check these articles for some ideas and insights  https://communities.sas.com/t5/SAS-Communities-Library/SAS-Viya-CAS-accessing-S3-data-files/ta-p/806617 https://communities.sas.com/t5/SAS-Communities-Library/SAS-Viya-accessing-S3-with-EKS-Service-Account/ta-p/818605 https://communities.sas.com/t5/SAS-Communities-Library/SAS-Viya-Compute-Server-accessing-S3-Parquet-file/ta-p/841892    Hope this helps ... View more

Hi @MuTwo  You may want to check out the DOSUBL function https://support.sas.com/resources/papers/proceedings13/032-2013.pdf hope this helps, Ahmed ... View more

Hi @stataq  Typically, the missing value would be considered as a fifth grouping value, and the below SQL statement would generate 5 macros (grp1 -- grp5), where grp1 represents the null/missing value.  proc sql noprint; select max(value) into :grp1- from have /*Where group is not null*/ /* This would ignore null/missing values */ group by group; quit; %put _user_;  But if you want to exclude the null/missing group value, then use where clause as @Kurt_Bremser has suggested already. ... View more

Hi @Sheril1  Have a look at this SESUG paper This Works on So Many Levels: Building Summary Tables in SAS® with Hash Programming It may provide you with a way to get closer to your goal.   Hope this helps, Ahmed   ... View more

Hi Guys, I had a quick question regarding the Data Plane -- Can it reside in the AWS Gov Cloud or it can only be in Regular/Commercial AWS Cloud?   Thanks, Ahmed  ... View more

@slacey  You probably can add the following before your Proc DS2 statement %if (%sysfunc(exist(testtest5))) %then %do; PROC DELETE Data=testtest5; run; %end; ... View more

Hi @salah1  The best practices I follow for something like this would be  - Placing the option in the <SASHome>/SASFoundation/9.4/sasv9_local.cfg file on Linux --- This way if and when I decide to upgrade my deployment, I would not lose my site customization.  - Placing the option in the <SASHome>\SASFoundation\9.4\sasv9.cfg file on Windows    With this option being placed with the SASHome, that means whatever SAS Application that based on-top of SAS Foundation would inherit this setting 😉, as long as the application layer does not explicitly remove it by specifying  -NONETENCRYPT    Here are a link to the docs and it shows where you can place this option  https://support.sas.com/documentation/cdl/en/secref/69831/HTML/default/viewer.htm#p1cw4hgwl2dfctn11izko4a2c026.htm   Hope this helps, Ahmed ... View more

@navdeepk  "Is the userId and userpassword same as the email and password I use to login to sasviya app?"  Yes, it should be. Please ensure the credentials (username/password) you have used in the .authinfo|_authinfo file, are correct and you can successfully login into SAS Viya when using the Viya Web Login page from your browser.   @sastpw  are we missing anything else here?      ... View more

@navdeepk  Just clarify this for me 1. When you said "Ps: I am using the free trial of sas viya on web", doesn't that imply you have a URL to access viya!? if so, then that would be the value for the url: key 2. the SASPy configuration link I sent you, has the following The .authinfo file (_authinfo on Windows)¶ The IOM and HTTP access methods have support for getting the required user/password from an authinfo file in the user’s home directory instead of prompting for it. On linux, the file is named .authinfo and on windows, it’s _authinfo. The format of the line in the authinfo file is as follows. The first value is the authkey value you specify for authkey. Next is the ‘user’ key followed by the value (the user id) and then ‘password’ key followed by its value (the user’s password). Note that there are permission rules for this file. On linux the file must have permissions of 600, only the user can read or write the file. On Windows, the file should be equally locked down to where only the owner can read and write it. Also, the encoding of this file should be UTF-8, or any encoding that has ASCII as it’s low order 7-bits if you only use those characters in the file. It’s read into Python as is, and thus is expected to be utf-8. So, wherever (Windows | Linux) you are launching Jupyter from, place/create the _authinfo | .authinfo file in your home (C:\Users\<YourID> | /home/<YourID> ) directory, with the following contents  authkey user <viya_user_id> password <viya_user_password> Hope this helps     ... View more

Hi @navdeepk  Check out the SASPy configuration SASPy configuration for how to set this up   Hope this helps, Ahmed ... View more

Just to verify you are using SAS (Unicode support) sas.exe -config "<SASHome>\SASFoundation\9.4\nls\u8\sasv9.cfg" Right? to confirm, you can always execute proc options option=encoding; run; ... View more