https://communities.sas.com/t5/SAS-Programming/joining-of-two-tables/m-p/493728#M129938 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. Sat, 08 Sep 2018 06:08:32 GMT LinusH 2018-09-08T06:08:32Z https://communities.sas.com/t5/SAS-Programming/joining-of-two-tables/m-p/493723#M129936 <P>I am encountering a weird problem while joining , I have to join two data set namely POS and london_postal_codes.</P><P>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&nbsp; but when I did the same thing in sas</P><P>there is lot of missing values.</P><P>&nbsp;</P><P>my code :</P><P>proc sql;<BR />create table case_2.combined_data as<BR />select * from<BR />case_2.pos_q1 t1<BR />left join case_2.london_postal_codes t2 on t1.customer_postcode=t2.postcode<BR />;<BR />quit;<BR />run;</P><P>Any suggestions?</P> Sat, 08 Sep 2018 04:07:28 GMT https://communities.sas.com/t5/SAS-Programming/joining-of-two-tables/m-p/493723#M129936 deltaskipper 2018-09-08T04:07:28Z https://communities.sas.com/t5/SAS-Programming/joining-of-two-tables/m-p/493728#M129938 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. Sat, 08 Sep 2018 06:08:32 GMT https://communities.sas.com/t5/SAS-Programming/joining-of-two-tables/m-p/493728#M129938 LinusH 2018-09-08T06:08:32Z