I have a macro which processes a dataset. I want to preserve the final outcome of this processing. So I am writing the final outcome to a global dataset(I could not think of any other alternative in SAS to make macro preserve the final outcome). This works good if I call macro once. However when I call macro more than once, only the last write is preserved(apparently previous writes are erased and I am preserved with only 1 final outcome in global dataset).
Assuming writing to global dataset is preferred way to preserve the final outcome of a macro, how can I RETAIN the writes to global dataset (instead of overwriting the previous content and preserving only 1 write in global dataset). Here is SAS snippet I am using..thank you
%macro LMGenerate(mymktdata,yeartag);
data &mymktdata.highliquidity;
*blah blah;
run;
data &mymktdata.lowliquidity;
*blah blah;
run;
*this is basically difference of above 2 datasets
data liquiditypremiums;
update &mymktdata.lowliquidity(in = a) &mymktdata.highliquidity(in =b);
by year;
if a & b then
do;
netpremium=lowliquiditytotal-highliquiditytotal;
output;
end;
run;
%mend LMGenerate;
*global data;
data liquiditypremiums;
run;
%LMGenerate(yr2010mktdata,2010 )
%LMGenerate(yr2011mktdata,2011 )
Not sure what you mean by a "global" dataset. You only seem to be creating WORK datasets.
If you want to append results to a dataset you might want to look at PROC APPEND.
Here is a trivial example.
%macro xx(value);
* Calculate new values ;
data new;
x=&value;
run;
proc append base=global data=new force;
run;
%mend xx;
%xx(1);
%xx(2);
proc print data=global;
run;
Hi ,
try adding another macro variable:
%macro LMGenerate(mymktdata,yeartag,dsn);
data &mymktdata.highliquidity;
*blah blah;
run;
data &mymktdata.lowliquidity;
*blah blah;
run;
*this is basically difference of above 2 datasets
data &dsn._ liquiditypremiums;
update &mymktdata.lowliquidity(in = a) &mymktdata.highliquidity(in =b);
by year;
if a & b then
do;
netpremium=lowliquiditytotal-highliquiditytotal;
output;
end;
run;
%mend LMGenerate;
%LMGenerate(yr2010mktdata,2010,aaa )
%LMGenerate(yr2011mktdata,2011,bbb )
Hello Linlin
what is 'aaa' and 'bbb'? Not sure how to fit in macro variable here (I am newbie..).
I have a dataset outside macro and I need my macro to append some values to this dataset (so that I can do post processing after all macros are executed).
thank you
Hi,
try the code below to see if you get what you want (repace the RED part with your real dataset name, the dataset you want to add obsevations on):
%macro LMGenerate(mymktdata,yeartag);
data &mymktdata.highliquidity;
*blah blah;
run;
data &mymktdata.lowliquidity;
*blah blah;
run;
*this is basically difference of above 2 datasets
data _&mymktdata;
update &mymktdata.lowliquidity(in = a) &mymktdata.highliquidity(in =b);
by year;
if a & b then
do;
netpremium=lowliquiditytotal-highliquiditytotal;
output;
end;
run;
%mend LMGenerate;
%LMGenerate(yr2010mktdata,2010 )
%LMGenerate(yr2011mktdata,2011 )
*global data;
data want;
set your_global_dataset_name _:;
run;
Not sure what you mean by a "global" dataset. You only seem to be creating WORK datasets.
If you want to append results to a dataset you might want to look at PROC APPEND.
Here is a trivial example.
%macro xx(value);
* Calculate new values ;
data new;
x=&value;
run;
proc append base=global data=new force;
run;
%mend xx;
%xx(1);
%xx(2);
proc print data=global;
run;
Hello,
By default, SAS will replace the dataset if you supply the same name in your DATA statement that you named in your UPDATE, SET or MERGE statement...So here when you call the macro more than once, the you lose the prior update and finally you only have one dataset which overwrite the prior datasets...
I think in this case, use GENMAX = n option in data step...
%macro LMGenerate(mymktdata,yeartag);
data &mymktdata.highliquidity;
*blah blah;
run;
data &mymktdata.lowliquidity;
*blah blah;
run;
*this is basically difference of above 2 datasets
data liquiditypremiums (genmax = 3);
update &mymktdata.lowliquidity(in = a) &mymktdata.highliquidity(in =b);
by year;
if a & b then
do;
netpremium=lowliquiditytotal-highliquiditytotal;
output;
end;
run;
%mend LMGenerate;
*global data;
data liquiditypremiums;
run;
%LMGenerate(yr2010mktdata,2010 )
%LMGenerate(yr2011mktdata,2011 )
Thanks,
Urvish
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 16. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Select SAS Training centers are offering in-person courses. View upcoming courses for: