topic Re: Catersian join by datastep in SAS Programming

Catersian join by datastep

max_ros — Thu, 04 Feb 2021 15:15:08 GMT

Hallo community, I am writing to you because I have this problem.
I want to make the Cartesian product of two datasets where each contains 6 lines (the final db must have 36 lines) through a datastep (and not proc sql). Could you give me a hand?

The two datasets are as follows

data scoperto_1;
input Scoperto $;
datalines;
0.1
0.2
0.3
0.5
1.0
2.0
;
run;

data limite_1;
input limite $;
datalines;
40
50
60
70
80
90
;

run;

I want to get a single dataset with all combinations of "limite" and "scoperto" (36 rows) through a datastep (and NOT proc sql).

Thanks in advance

max

Re: Catersian join by datastep

PaigeMiller — Thu, 04 Feb 2021 15:24:25 GMT

Your favorite internet search engine finds answers quickly. Here's one:

https://sasnrd.com/sas-cartesian-product-proc-sql-data-step/

Re: Catersian join by datastep

max_ros — Thu, 04 Feb 2021 15:30:43 GMT

Thank you very much it works wonders