Trying to create a data set with 2 columns and 880 rows using Arrays and Do Loops (or any method)

[MelissaM]

I have two categorical data sets: one with 20 rows, and one with 44 rows.

I need to make one data set which has two columns of 20 x 44 or 880 rows.

I need to keep the data in character format, so don't have to reformat anything.

I'd be embarrassed to tell you how much I've researched this, but to no avail (I have learned a lot, though).

But could use your guidance.

I'm guessing it's an array with a do loop, but am open to SQL or anything.

Appreciated in advance.

[Kurt_Bremser · Accepted solution]

What you want is a "cartesian join", easily achieved with proc sql:

data one;
input column1 $;
datalines;
one_1
one_2
;

data two;
input column2 $;
datalines;
two_1
two_2
two_3
;

proc sql;
create table want as
  select one.column1, two.column2
  from one, two
;
quit;

[MelissaM]

I am so appreciative. I cannot express!