01-25-2016 12:39 PM
I am attempting to use a macro to add my password information to my proc export code so I don't have to re-enter password in each line of script when password changes. The example below displays my attempt. Is there anything missing from the code or do I need to take another avenue?
proc export data= TEST.test_import
dbms= EXCELCS replace;
SHEET = "TEST";
SERVERUSER = 'XXXXXX’;
SERVERPASS = &password;
Any help is appreciated.
01-25-2016 01:42 PM
Try adding double quotes here: serverpass = "&password";
I'm assuming that your &password is defined without quotes like so: %let password = MyPassword;