Proc sql with macro or call execute

[draroda]

Hi Team,

I have one dataset where values for datasets to be merged and out dataset name mentioned.

I don't want to write proc sql repeatedly and want to achieve this task with help of call execute or macro.

Can you please help on same ?

Below is the dataset .

data temp;
input ds1 $ 1-4 ds2 $6-9 out $ 10-14;
datalines;
DEMO AECM AE
DEMO CMAE CM
DEMO MHCM CM
TEMP OTHR TMP 
TEMP EX12 EXR
;

[andreas_lds]

What have you tried so far? Do you want to merge without BY-statement? If not, you have to add the by-variable(s) to your temp-dataset.

[Kurt_Bremser · Accepted solution]

Use call execute():

data _null_;
set temp end=eof;
if _n_ = 1 then call execute('proc sql;');
call execute('create table ' !! out !! ' as select a.var1,b.var2 from ' !! ds1 !! ' as a, ' !! ds2 !! ' as b where a.xxx = b.xxx;');
if eof then call execute('quit;');
run;