topic Re: SQL merge 2 data fully in SAS Programming

SQL merge 2 data fully

hhchenfx — Sat, 07 Oct 2017 01:02:53 GMT

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,

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;

Re: SQL merge 2 data fully

mkeintz — Sat, 07 Oct 2017 01:10:11 GMT

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

Re: SQL merge 2 data fully

hhchenfx — Sat, 07 Oct 2017 01:43:50 GMT

Thank you,

nice trick.

Re: SQL merge 2 data fully

Astounding — Sat, 07 Oct 2017 01:44:44 GMT

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;

Re: SQL merge 2 data fully

hhchenfx — Sun, 08 Oct 2017 02:34:08 GMT

YES, it is what I am looking for.

from a, b;

Thanks,