What you probably want is an Access Control Template. You can find out more information in PC SAS help files if you look up "Access Control Template" or ACT.

Or, if you want to enter ID and password without changing code and you are using Unix with Xwindows or PC SAS, try this;

data _null_; retain ID PWD; format ID PWD $15.; ID=''; PWD=''; window get_input irow=2 rows=25 columns=80 #2 @3 'Please confirm the following parameter:' #4 @3 'ID:' +1 ID $15. attr=underline autoskip=yes color=brown persist=yes required=yes #6 @3 'PASSWORD:' +1 PWD $15. attr=underline autoskip=yes color=brown persist=yes required=yes ; window confirm_input irow=20 rows=10 columns=60 #3 @3 'Please Confirm Inputs(Y/N)?' +1 answer $1. attr=underline color=blue required=yes ; window msg_window irow=10 rows=10 columns=80 #4 @3 'Error : ' +1 msg $70. color=blue protect=yes; display get_input; display confirm_input; if upcase(answer) = 'Y' then do; msg=''; if _cmd_ ne ' ' then do; msg='CAUTION: UNRECOGNIZED COMMAND' || _cmd_; answer=''; end; if msg='' then do; ID = UPCASE(ID); PWD = UPCASE(PWD); call symput("myuserid",compress(ID)); call symput("mypassword",compress(ID)); if upcase(answer)='Y' then stop; end; else display msg_window; end; ctr + 1; run;

LIBNAME ntz oledb init_string="Provider=nzoledb; User ID=&myuserid;Password=&mypassword; Initial Catalog=mycatalog;Data Source=mysource;" schema=myschema;

That should give you a popup window that requests your ID and password and passes them off as macro_variables.

Good luck.