data dat1;
input x;
cards;
1
3
4
6
7
8
;
run;
data dat2;
input y;
cards;
1
4
3
6
7
5
;
run;
How to get the data include all combination of x and y?
that is:
x y
1 1
1 4
1 3
1 6
1 7
1 5
3 1
3 4
3 3
3 6
3 7
3 5....
thanks.
Proc Sql; create table want as select dat1.x, dat2.y from dat1, dat2 ; quit;
There will be a note in the log about a Cartesian join that cannot be optimized. Since you are requesting a Cartesian join, all records with all records, that note is okay.
Proc Sql; create table want as select dat1.x, dat2.y from dat1, dat2 ; quit;
There will be a note in the log about a Cartesian join that cannot be optimized. Since you are requesting a Cartesian join, all records with all records, that note is okay.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.