SAS SERVERPASS

Dataanalyst313 — Mon, 25 Jan 2016 17:39:01 GMT

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

outfile= "\\A\B\C\D\E.xls"

dbms= EXCELCS replace;

SHEET = "TEST";

SERVER ='XXXXXXXX;

SERVERUSER = 'XXXXXX’;

SERVERPASS = &password;

Any help is appreciated.

Re: SAS SERVERPASS

SASKiwi — Mon, 25 Jan 2016 18:42:37 GMT

Try adding double quotes here: serverpass = "&password";

I'm assuming that your &password is defined without quotes like so: %let password = MyPassword;

topic Re: SAS SERVERPASS in SAS Programming

SAS SERVERPASS

Re: SAS SERVERPASS