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
;
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;
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.
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;
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 25. 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.