A String with Quote - Like Statement

proc sql;
  create table a1 as
  select *
  from retail
  where store_name like '%MAC''Y%'
; quit;