topic Storing a Macro variable. in SAS Programming

Storing a Macro variable.

kuridisanjeev — Mon, 02 Apr 2012 13:41:43 GMT

Hi Everyone..

I am Using the following code..

Proc SQL;

select mail into : email separated by ' " " ' from dump;

quit;

filename report email from ="$$$$$$$$$@*******.com"

to="&email"

...So on..............................

My Question is ,instead of running the SQL Query Every time,I want to store that Email macro Variable permanently..

So ,Is there any way to store the macro variable permanently??

Storing a Macro variable.

art297 — Mon, 02 Apr 2012 13:48:22 GMT

I've never heard of permanently storing a macro variable, but you could always wrap the code within a SAS macro (that you can store permanently), and then just call the macro whenever it is needed. That would probably be a better choice, anyhow, as the email base is likely to change over time.

Storing a Macro variable.

kuridisanjeev — Mon, 02 Apr 2012 13:59:02 GMT

Thank you art.

Storing a Macro variable.

Haikuo — Mon, 02 Apr 2012 14:15:20 GMT

Or you could store it into a permanent text file, and put it back to a macro variable when needed:

%let email=%bquote("alkjdva@ald.com" "lajdfla@ut.com");

data _null_;

file "h:\email.txt";

put "&email";

run;

data _null_;

infile "h:\email.txt" truncover;

input email $char50.;

put email;

if _n_=1 then call symputx('email_new',email);

run;

%put &email_new;

Regards,

Haikuo

Storing a Macro variable.

Astounding — Mon, 02 Apr 2012 14:21:57 GMT

It's already stored in a temporary data set. You just need to retrieve it:

proc sql;

create table perm.macrovar as select * from dictionary.macros where name='MY_MACRO_VARIABLE';

quit;

However, if you are dealing with long values, dictionary.macros breaks up your variable into 200-character blocks which will need to be reassembled later.