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?
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.