DATA Step, Macro, Functions and more

merge two data sets in macro using proc sql

Accepted Solution Solved
Reply
Occasional Contributor
Posts: 8
Accepted Solution

merge two data sets in macro using proc sql

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!


Accepted Solutions
Solution
‎09-03-2017 04:39 PM
PROC Star
Posts: 283

Re: merge two data sets in macro using proc sql

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)

View solution in original post


All Replies
Solution
‎09-03-2017 04:39 PM
PROC Star
Posts: 283

Re: merge two data sets in macro using proc sql

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)

Occasional Contributor
Posts: 8

Re: merge two data sets in macro using proc sql

Posted in reply to novinosrin
True! **bleep** it... got confues by result pages which comes up automatically after running the code. It showed a different data set. thanks!
☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 155 views
  • 0 likes
  • 2 in conversation