topic Re: Problem with Joint By proc sql. getting empty dataset. in SAS Enterprise Guide

Problem with Joint By proc sql. getting empty dataset.

mrug12 — Wed, 27 Nov 2013 16:41:15 GMT

I have 2 differentsas dataset.

A and B.

I am trying to get data from dataset A to dataset B as below

proc sql ;

create table c as select

a.11,

a.13,

a.14

from A,B

where

A.1=B.1 and A.2=B.2 and A.3=B.3;

quit;

Now I am getting empty dataset C.

I am sure I have values comman for 1,2 and 3 for A and B . I check formatting and length in both dataset are same. Not sure why not getting records.

Re: Problem with Joint By proc sql. getting empty dataset.

Reeza — Wed, 27 Nov 2013 16:49:17 GMT

Did you code that or use the query tool? Does the query tool return results?

I wonder if your variables are actually 1/2/3?

Re: Problem with Joint By proc sql. getting empty dataset.

mrug12 — Wed, 27 Nov 2013 16:54:57 GMT

i code it my self . i even try with query tool but geeting same result.

acual variableas are firstname, lastname and date of birth.

Re: Problem with Joint By proc sql. getting empty dataset.

Haikuo — Wed, 27 Nov 2013 16:55:33 GMT

For number variables , check their precision level; for char variables, you could be haunted by some invisible characters, to start, using LEFT and UPCASE(if you don't care about the case) to standardize your non-blank content, then compare.

If you want to get to the bottom of it, hand pick some values you believe are the same, then put them into Hex. format, and check it out.

Good luck,

Haikuo

Re: Problem with Joint By proc sql. getting empty dataset.

Reeza — Wed, 27 Nov 2013 17:03:48 GMT

Post the actual code please and log...there are many ways this could be happening.

Re: Problem with Joint By proc sql. getting empty dataset.

mrug12 — Wed, 27 Nov 2013 18:09:33 GMT

Thanks for the help. it turn out to be problem with case of char veriables.