topic Blank variables in SAS Programming

Blank variables

GN0001 — Fri, 25 Jun 2021 15:43:05 GMT

Hello team

Will that create Cartesian product If we join two data sets and the variable join have blanks?

Thanks,

Blue blue

Re: Blank variables

PaigeMiller — Fri, 25 Jun 2021 15:44:38 GMT

There's a very easy way to find out. Try it and see.

Re: Blank variables

Reeza — Fri, 25 Jun 2021 15:52:42 GMT

If you join and have 3 blanks in one and 10 blanks in the other on the join key then yes, you'll end up with 30 blank records.
Does it create a full cartesian product - No.