topic Re: Proc sql with macro or call execute in SAS Programming

Proc sql with macro or call execute

draroda — Thu, 10 Jan 2019 09:59:25 GMT

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
;

Re: Proc sql with macro or call execute

andreas_lds — Thu, 10 Jan 2019 10:11:23 GMT

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.

Re: Proc sql with macro or call execute

Kurt_Bremser — Thu, 10 Jan 2019 10:23:19 GMT

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;