topic Re: merge 2 datasets with the second dataset through id in SAS Programming

merge 2 datasets with the second dataset through id

noda6003 — Wed, 03 Mar 2021 08:36:01 GMT

I have 2 datasets one has ID values and i want to merge it with text to get the values from text, i need something like below - want dataset. any help on it

TEXT

Height

Weight

I want something like this

ID	TXT
1	Height
1	Weight
2	Height
2	Weight
3	Height
3	Weight
4	Height
4	Weight

Re: merge 2 datasets with the second dataset through id

Aku — Wed, 03 Mar 2021 09:11:59 GMT

With Proc SQL you can create cartesian product just (You haven't defined dataset names , so I'm using column names)

Proc Sql;

create table want as

select *

from ID, TEXT;

quit;

Re: merge 2 datasets with the second dataset through id

PeterClemmensen — Wed, 03 Mar 2021 09:35:17 GMT

With a data step.

data have1;
input ID;
datalines;
1
2
3
4
;

data have2;
input TEXT $;
datalines;
Height
Weight
;

data want;
   set have1;
   do i=1 to n;
      set have2 point=i nobs=n;
      output;
   end;
run;

Result:

ID  TEXT 
1   Height 
1   Weight 
2   Height 
2   Weight 
3   Height 
3   Weight 
4   Height 
4   Weight