topic Re: Trying to connect with database using libname statement. in SAS Programming

Trying to connect with database using libname statement.

u63406443 — Thu, 26 Oct 2023 04:31:46 GMT

Hi All,

I am trying to connect with database using libname statement, for that I have created a macro variables and those variables is not fetched in libname statement. Can you all please look into the code and help me resolve the issue.

See difference in below two libname statements in a password field.

code:

%let user=%str(rakesbx);
%let password=%str(rAk%B25%);

/*Libname cdl1 odbc datasrc="cdl2-hive" schema= abv_hcp360_besting_lease_ext user= "&user" password= "rAk%B25%";*/ ---> when I am trying these way and commenting the password variable it is giving the result i.e.,:

Success result is:

Libname cdl2 odbc datasrc="cdl2-hive" schema= abv_hcp360_opt_preference_ext user= "&user" password= "&password"; ----> when I am trying these way it is not giving the result i.e.,

Error result is:

Thanks.

Re: Trying to connect with database using libname statement.

rudfaden — Thu, 26 Oct 2023 08:47:59 GMT

Try Using %nrstr() instead of %str(). If you must use %str you need to mask you % signs like this %str(rAk%%B25%%)

Re: Trying to connect with database using libname statement.

rudfaden — Thu, 26 Oct 2023 08:49:52 GMT

See https://documentation.sas.com/doc/en/pgmsascdc/9.4_3.5/mcrolref/p0pnc7p9n4h6g5n16g6js048nhfl.htm for more info

Re: Trying to connect with database using libname statement.

u63406443 — Thu, 26 Oct 2023 10:20:14 GMT

Thank you rudfaden, Got it.