How do I code an IN: statement with an apostrophe s:
IN:('LOWE'S');
The code above does not work.
Thank you.
You can use two apostrophes in sequence like this:
where Store name IN ('LOWE''S','HOME DEPOT');
Or you can use double quotes for the outer quotes, like this:
where Store name IN ("LOWE'S",'HOME DEPOT');
Looks like double quotes outside of the single works "LOWE'S"
You can use two apostrophes in sequence like this:
where Store name IN ('LOWE''S','HOME DEPOT');
Or you can use double quotes for the outer quotes, like this:
where Store name IN ("LOWE'S",'HOME DEPOT');
Join us for SAS Innovate 2025, our biggest and most exciting global event of the year, in Orlando, FL, from May 6-9. Sign up by March 14 for just $795.
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.
Ready to level-up your skills? Choose your own adventure.