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?
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.