SQL merge 2 data fully

[hhchenfx]

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;

[mkeintz · Accepted solution]

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".

[hhchenfx]

Thank you,

nice trick.

HC

[Astounding]

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;

[hhchenfx]

YES, it is what I am looking for.

from a, b;

Thanks,

HC