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
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
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.