- data one;
- format a $3.;
- do i = 1 to 24;
- a = "a" || strip(i);
- output;
- end;
- drop i;
- run;
- data two;
- format b $3.;
- do i = 1 to 32;
- b = "b" || strip(i);
- output;
- end;
- drop i;
- run;
- proc sql;
- create table wanted as
- select one.a, two.b
- from one, two
- ;
- quit;