Problem with Joint By proc sql. getting empty dataset.

[mrug12]

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.

[Reeza]

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?

[mrug12]

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

acual variableas are firstname, lastname and date of birth.

[Reeza]

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

[Haikuo · Accepted solution]

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

[mrug12]

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