topic Re: Trying to create a data set with 2 columns and 880 rows using Arrays and Do Loops (or any method in SAS Programming

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

MelissaM — Wed, 15 Apr 2020 08:15:03 GMT

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.

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

Kurt_Bremser — Wed, 15 Apr 2020 08:22:03 GMT

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;

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

MelissaM — Wed, 15 Apr 2020 20:25:01 GMT

I am so appreciative. I cannot express!