merge 2 datasets with the second dataset through id

[noda6003]

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

ID

1

2

3

4

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

[Aku]

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;

[PeterClemmensen · Accepted solution]

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