I've a test_mcr1 where I am creating a macro variable, and I need to use that macro variable in test_mcr2. %macro test_mcr1 (user, secrete); %let conn_creds=user="&user" password="&secrete"; %mend; test_mcr1 (user, host); %macro test_mcr2 (); test_mcr1 (mngr, some_pwd); %mend; SAS code (below two lines in sas code): %test_mcr2(); libname libref odbc &conn_creds. dsn=xyz; NOTE: test_mcr1 macro run/compiles during autoexec run.
... View more