topic Looking for how to code for an apostrophe in an IN: statement in SAS Programming

Looking for how to code for an apostrophe in an IN: statement

cbrotz — Thu, 07 Mar 2024 17:38:04 GMT

How do I code an IN: statement with an apostrophe s:

IN:('LOWE'S');

The code above does not work.

Thank you.

cbrotz — Thu, 07 Mar 2024 17:45:12 GMT

Looks like double quotes outside of the single works "LOWE'S"

SASJedi — Thu, 07 Mar 2024 17:49:03 GMT

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');