topic Re: sasv9_local.cfg environment variables? in SAS Programming

sasv9_local.cfg environment variables?

Anacreo — Wed, 25 Jun 2025 21:23:18 GMT

I'm trying to pass an -emailid $emailid in my sasv9_local.cfg, I set the environment variable in the sasenv_local, and it is defintiely running and exporting the variable.

If I run this from SAS Enterprise Guide, it runs as expected.

If I run this from batch command line it won't use the environment variable, it just leaves emailid as the literal $emailid.

Is this a bug or intentional?

Re: sasv9_local.cfg environment variables?

SASKiwi — Wed, 25 Jun 2025 22:23:15 GMT

You'll need to apply the change in your SASApp folder to sasv9_usermods.cfg for this to also work for batch jobs.

Re: sasv9_local.cfg environment variables?

Anacreo — Wed, 25 Jun 2025 23:26:48 GMT

The Unix command line isn't aware of the SASApp / Lev1 structure, it does pickup the setting in !SASHOME/SASFoundation/9.4/sasv9_local.cfg but it won't resolve the $emailid, it keeps it as a literal.

$ grep emailid SASFoundation/9.4/sasv9_local.cfg
-emailid $emailid

However if I run this sas code from Unix:
%PUT MY_ENV_VAR = %SYSGET(emailid);

I can see that emailid is being set by the sasenv_local (also a debug file is outputted).

It works correctly in a SAS EG.

Re: sasv9_local.cfg environment variables?

SASKiwi — Wed, 25 Jun 2025 23:39:46 GMT

How do you execute SAS batch jobs then? The typical practice is to execute the sasbatch script that would be in /sasapp/batchserver in which case it will pick up SASApp modifications.

Re: sasv9_local.cfg environment variables?

Anacreo — Wed, 25 Jun 2025 23:50:30 GMT

We will just execute !SASHOME/SASFoundation/9.4/bin/sas mysascode.sas

Re: sasv9_local.cfg environment variables?

SASKiwi — Thu, 26 Jun 2025 00:23:38 GMT

I suggest you try the sasbatch script as otherwise you will miss out on any config modifications.

Re: sasv9_local.cfg environment variables?

Anacreo — Thu, 26 Jun 2025 01:04:22 GMT

We have a large configuration, I can definitely investigate it, but we're not setup that way today. Would like to get the original problem solved.

Re: sasv9_local.cfg environment variables?

Ksharp — Thu, 26 Jun 2025 01:20:21 GMT

You need to set this environment variable at command line .

For example, if you want environment variable SAS_EXECFILEPATH has value "c:\sascode\" :

"D:\SASHome\SASFoundation\9.4\sas.exe" -nosplash -sysin "c:\temp\temp.sas"  -set SAS_EXECFILEPATH "c:\sascode\"

Check @Rick_SAS blog:

How to pass parameter into SAS programm:

https://blogs.sas.com/content/iml/2015/03/16/pass-params-sysget.html

Re: sasv9_local.cfg environment variables?

Anacreo — Thu, 26 Jun 2025 01:20:55 GMT

My full fix is below, I was hoping to skip the autoexec.sas and just do it in the sasv9_local.cfg with the -emailid = $emailid.

This allows the system to set the user's proper FROM address instead of using a generic address and making users set it in their mail statement. We set a default for service accounts that don't have individual email addresses.

In !SASROOT/bin/sasenv_local

# Set default email emailid="noreply@ourdomain.com" # Path to the lookup file lookup_file="/userid_email_lookup.txt" # Read the file and find the matching email while IFS='|' read -r user_id field2 email rest; do if [[ "$user_id" == "$USER" && -n "$email" ]]; then emailid="$email" break fi done < "$lookup_file" # Optionally export it for use in other scripts export emailid

In sasv9_local.cfg

-autoexec !SASROOT/autoexec.sas

In !SASROOT/autoexec.sas

options emailid="%sysget(emailid)";

Thanks everyone for the participation!