topic Re: Combining two datasets in SAS Programming

Combining two datasets

Pcase — Fri, 27 May 2022 00:58:55 GMT

Normally I merge datasets using a key. However, in this case I don't have or want a key. I want to get a new dataset that combines each row from both. Here's an example with two datasets:

Data1:

Fld1:

Data2:

Fld2:

I want to get:

Data3:

Fld1: Fld2:

A 1

A 2

A 3

B 1

B 2

B 3

How do I achieve this? Nothing I've tried so far has worked Thanks!

Re: Combining two datasets

Astounding — Fri, 27 May 2022 01:48:48 GMT

"All combinations" is a simple task for SQL:

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

Re: Combining two datasets

SASKiwi — Fri, 27 May 2022 01:49:36 GMT

DATA step method:

data A;
  var1 = 'A'; output;
  var1 = 'B'; output;
run;

data B;
  var2 = 1; output;
  var2 = 2; output;
  var2 = 3; output;
run;

data c;
  set A;
  do i = 1 to OBSNUM;
    set B point = i nobs = OBSNUM;
    output;
  end;
run;

Re: Combining two datasets

Pcase — Fri, 27 May 2022 17:25:55 GMT

Thanks! This did the trick!