I have written the following code:
%macro one_run (dataset1=, dataset2=, var1= , var2= );
%macro two_run (yourdate= 01Feb2015)* this is example date
proc sql;
create table ab as
select a.&var1, a.INDIV_ID, b.CD, b.&var2, b.AGENCY, b.DT, b.PAID_AMT, b.PROD_ID, b.CANCEL_DT, b.RECEIVED_CD, b.PAYMENT_DT,
b.PAYMENT_STATUS, b.PAYMENT_TYPE, b.OKey, b.Cancel
from &dataset1 a, &dataset2 b
where a.MSR_INDIV_ID = b.INDIVIDUAL_ID
and date ge "&yourdate."d;
run;
%mend one_run; %mend two_run;
%one_run (dataset1=var.FF_ACX_MSR_ID10, dataset2=ora1.FACT_MKE_PUB_SUBSCRIPTION)
%two_run(&yourdate)
The challenge i am facing here is that i have in some of the datasets more than 70 variables hence i cannot use var1, var2 so on and so forth to call these variables.
Kindly suggest how should i achieve this. if there is any other alternate apart from proc sql or macro kindly assist with the same as well.
Looking forward to assistance as always.
... View more
