I am resolving my ID and Password through macro variables in my SAS code. I am using Option mprint and symbolgen to see the resolved value of other macros in my code. I dont want it to resolve my ID and Password. Is there a way that I can mask these 2 macro variables
#1 disable mprint and symbolgen immediately before setting and using the macro variables.
#2 use a masked version of the passwords (proc pwencode)
#3 see if you can adapt your process so that credentials are not needed (ie set up automated ssh connections with public/private key authentication)
solution 3 is to be preferred.
In places where we need confidential information, this is stored in .sas files only readable by the user in question; these files are %include'd when needed. For security, they have options nomprint nosymbolgen set (so no public log will show the values).
#1 disable mprint and symbolgen immediately before setting and using the macro variables.
#2 use a masked version of the passwords (proc pwencode)
#3 see if you can adapt your process so that credentials are not needed (ie set up automated ssh connections with public/private key authentication)
solution 3 is to be preferred.
In places where we need confidential information, this is stored in .sas files only readable by the user in question; these files are %include'd when needed. For security, they have options nomprint nosymbolgen set (so no public log will show the values).
If you are using the password in a LIBNAME statement then you should also consider using the LIBNAME() function in a data step instead. You can use the SYMGET() function to retrieve a macro variable value without it being displayed.
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.