topic How to left join all records in SAS Programming

How to left join all records

HitmonTran — Fri, 01 Jul 2022 21:43:28 GMT

Hi,

I want to left join all data from data2 onto data1.

Current:

data 1 (4 obs)

data 2 (1 obs)

var10	var11	var12
xxx	yyy	zzz

want:

mkeintz — Fri, 01 Jul 2022 22:45:21 GMT

Only one record from DATA2? Then

data want;
   set data1;
   if _n_=1 then set data2;
run;

But you are probably looking for:

proc sql;
  create table want as  select * 
  from data1 as a left join data2 as b 
  on a.var1=a.var1;
quit;

In fact, you don't even need to know the variable name VAR1:

proc sql;
  create table want as  select * 
  from data1 as a left join data2 as b 
  on 1=1;
quit;

which the SQL compiler will note is a cartesian product join.

Kurt_Bremser — Sat, 02 Jul 2022 05:01:57 GMT

This is a "simple" cartesian join, do

proc sql;
create table want as select * from data1, data2;
quit;