Search the Community
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
218 results
Sorted by:
09-13-2023
01:40 AM
Hi,
When i am trying to execute below code i am getting cartesian product while using inner join but i dont want cartesian, i need 6 rows only as it is with previous quarter comparision,
I have s...
04-14-2023
05:23 AM
I need to run this merge in sql and I'm getting a cartesian product join. I took the step of eliminating duplicates from one of the joined datasets, but I still getting the message on t...
12-05-2011
01:17 PM
Hello, I'm looking to create a cartesian product with 3+ tables. TableA: ------ Columns for TableA: colA Values for colA: product A, product B, product C (three rows) TableB: ------ C...
Show results in replies (4)
-
Without having dug into your attachment - I think this can be solved if you can have some rank/sort...
-
...fficient as SQL. data TableA ; input colA $10.;; cards; product A product B product C ; run; d...
-
...roc format, a data step and, finally, proc sql: %let COVa_colA = product A, product B, product C...
-
...he following code also works as expected: %let COVa_product = product A, product B, product C; %l...
12-01-2018
02:15 PM
...orry, Ive got the feeling that this question is stupid but Im not sure how to handle this issue. Is this the Cartesian Product?
08-02-2021
11:44 PM
Hello team,
Are full join and cross join (cartesian product) same thing in SAS?
Regards,
blueblue
03-24-2022
10:08 AM
1 Like
...able_a_b
as
select distinct a.*, b.*
from table_a as a
left join table_b as b
on 1 = 1
;quit;
10-12-2017
06:59 AM
Hi, I have a process where I do a Cartesian product of 2 tables (one with data and one with parameters) using proc sql and then I use data step to apply the needed filters so that at the e...
01-25-2018
07:13 AM
...11 1
111 2
222 3
222 4
222 5
;
proc sql;
create table test2 as
select a.*, b.Record_ID as ID2
from test a
left join test b
on a...
01-12-2015
10:28 AM
I'm merging two data files and creating a cartesian join or merge. My end goal is to determine for each SELLER and BUYER combination, what products are matching The Data looks as f...
05-02-2023
09:37 AM
Hi All,
I need to know is there any way I can optimize this join. I am getting notes :
NOTE: The execution of this query involves performing one or more Cartesian product joins that c...