Hi,
I remember that there is a quick way to do SQL to accomplish the merge 2 datasets as I did below.
I just cant figure out what is the syntax, basically, I dont need to use the variable x=1;
Thank you,
HC
data a;
input number;
datalines;
1
3
102
;run;
data b;
input name1 :$5. ;
datalines;
new1
new2
;run;
data a; set a; x=1; run;
data b; set b; x=1; run;
proc sql;
create table want (drop=x)as select * from a join b
on a.x=b.x;quit;
Change the "ON" expression to any tautology:
data a;
input number;
datalines;
1
3
102
;run;
data b;
input name1 :$5. ;
datalines;
new1
new2
;run;
proc sql;
create table want as select * from a join b on 1=1;
quit;
In fact you could say "ON 0=0" or "ON 1>0".
Change the "ON" expression to any tautology:
data a;
input number;
datalines;
1
3
102
;run;
data b;
input name1 :$5. ;
datalines;
new1
new2
;run;
proc sql;
create table want as select * from a join b on 1=1;
quit;
In fact you could say "ON 0=0" or "ON 1>0".
Thank you,
nice trick.
HC
Are you just looking for this? Just create data sets A and B, and don't create X:
proc sql;
create table want as select * from a, b;
quit;
YES, it is what I am looking for.
from a, b;
Thanks,
HC
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.