topic Re: merge two data sets in macro using proc sql in SAS Programming

merge two data sets in macro using proc sql

mrer — Sun, 03 Sep 2017 20:16:21 GMT

Hello,

today I wanted to merge two data sets together to finally draw some plots with the data. I got the code working outside of a macro, but as I have more data sets I wanted to create a macro for this:

Lets say I have data like this:

data data1;
   input y ;
   datalines;
    1
    2
    4
    2
    6
    4
    3
    4
;

data data2;
   input y ;
   datalines;
    4
    3
    7
    5
    6
    9
    5
    4
;

Now I want to merge the two data sets:

%MACRO createPlotData(data1 , data2); 
proc sql;
  create table plot1 as
  select
    y 
  from
   &data1
  ;
quit;
proc sql;
  create table plot2 as
  select
    y as y1
  from
   &data2
  ;
quit;

data outputPlotData;
     set plot1 plot2;
run;
%MEND;

The code is working when I use it outside of the macro. I already googeld and looked in this forum for a solution but I could not get the code to work. I think I need to at something inside the proc sql code?

Thanks for your help!

Re: merge two data sets in macro using proc sql

novinosrin — Sun, 03 Sep 2017 20:22:15 GMT

Your code is working for me:

data data1;
input y ;
datalines;
1
2
4
2
6
4
3
4
;

data data2;
input y ;
datalines;
4
3
7
5
6
9
5
4
;

%MACRO createPlotData(data1 , data2);
proc sql;
create table plot1 as
select
y
from
&data1
;
quit;
proc sql;
create table plot2 as
select
y as y1
from
&data2
;
quit;

data outputPlotData;
set plot1 plot2;
run;
%MEND;
%createPlotData(data1,data2)

Re: merge two data sets in macro using proc sql

mrer — Sun, 03 Sep 2017 20:39:35 GMT

True! **bleep** it... got confues by result pages which comes up automatically after running the code. It showed a different data set. thanks!