topic Re: weired output with except all command in SAS Procedures

weired output with except all command

nikhilbajaj — Tue, 09 Sep 2014 01:43:31 GMT

Hi all,

I am getting a weired output while using the 'except all' command. I have (A join B) as source and C as target.

(A join B) has same number of records as in C

if I do a 'except all' between C and (A join B) I get no records

but when I do 'except all' between (A join B) and C I get 37 records. And these records are actually not seen in (A join B).

Can anybody take me out of this problem?

Re: weired output with except all command

ballardw — Tue, 09 Sep 2014 15:54:23 GMT

Might help to actually post the code involved.

Re: weired output with except all command

nikhilbajaj — Tue, 09 Sep 2014 16:39:52 GMT

here is the code-

rsubmit;
proc sql;
create table TEST_RESULT as
select B.OFFRG_N,
B.OFFRG_TS,
A.AG_PER_POL_L
from MPTST031_UWS_POL A, CSTST061_UWS_CB_CV B
where A.POL_N = B.POL_N

except

select OFFRG_N,
OFFRG_TM_CRT_TS,
AG_PER_POL_L
from CCTRP121_CSIX;
select count(*) from TEST_RESULT;
quit;

Re: weired output with except all command

nikhilbajaj — Tue, 09 Sep 2014 16:54:33 GMT

hey guys, today I am not getting that unexpected output. I have no idea why this happened. But anyways thanks and sorry if you put your time on this.

Re: weired output with except all command

Howles — Wed, 10 Sep 2014 01:47:11 GMT

Don't know what was expected, but the EXCEPT operator is not commutative.

Re: weired output with except all command

Ksharp — Wed, 10 Sep 2014 13:24:39 GMT

Maybe you should uniform these variables name . These two set of variables should be the same name .

Just Guest.

Xia Keshan