joining of two tables

[deltaskipper]

I am encountering a weird problem while joining , I have to join two data set namely POS and london_postal_codes.

The problem I facing is that when I join them in mysql server no missing values are there for the variables of table london_postal_code  but when I did the same thing in sas

there is lot of missing values.

my code :

proc sql;
create table case_2.combined_data as
select * from
case_2.pos_q1 t1
left join case_2.london_postal_codes t2 on t1.customer_postcode=t2.postcode
;
quit;
run;

Any suggestions?

[LinusH]

Apparently the inbrhe for youbare using in SAS, soes not match on the join column. So its down to boring data quality checks. Like try to left/trim so no spaces are lingering.