03-06-2018 06:43 PM
I have configured all my macros variables in autoexec_usermods.sas file and when I query the macros by %put ¯ovarivale, I cannot able to fetch the data from the file.
Throwing me Apparent Symbolic reference error. But the similar type of macros , I have written in other levels and I can able to access that.
I feel something is missing in one of the level while reading the data from autoexec_usermods file.
Can anyone please help me in that. Thanks in advance.
03-06-2018 07:18 PM
Suggestions (to help us help you):
03-07-2018 01:52 AM
And also supply in which server environment the error happens (workspace vs. stored process), and the complete path to the autoexec_usermods.sas file. It may be you edited the wrong file, or that the server is a persistent one (pooled, stored process) and needs to be restarted.
03-07-2018 06:04 PM
03-07-2018 06:50 PM
I'd have to strongly recommend against storing user credentials in macros, even (so called) masked passwords.
If you are running on a metadata platform, rather than define user & password, instead use "authdomain=MyAuthDomain" and set up the authentication domain in metadata (or have your platform admin do it for you).
Doesn't directly resolve your macro issue, but since you brought up credentials, thought it worth mentioning.
That aside, can you supply code & logs, even if you mask any sensitive information? Also, do the macro variables contain any special characters - an individual quote, an individual bracket, a keyword like OR, IN, etc?
03-07-2018 09:11 PM
Have you considered setting up your libraries in SAS metadata? This avoids any AUTOEXEC maintenance at all and using @AndrewHowell's recommendations you can also keep your usernames and passwords encoded.