Good evening:
I'm stuck creating a proc sql statement filtering for a value that includes a single quote (').
PROC sql;
create table target as
select
*
from
source
where
value = "Tom's Trucks"
quit;
run;
Thanks for your help.
PROC sql; create table target as select * from source where value = "Tom's Trucks" ; quit; run;
@sutzig wrote:
Good evening:
I'm stuck creating a proc sql statement filtering for a value that includes a single quote (').
PROC sql; create table target as select * from source where value = "Tom's Trucks" quit; run;
Thanks for your help.
Reeza:
Thank you for pointing out the syntax error in the sample, but this is not the issue. The issue is creating a filter using a text value criteria which includes a single quote (and, presumably double quotes).
For example
PROC sql;
create table target as
select
*
from
source
where
value in=("Tom's Trucks" ; "Carstop");
quit;
run;
will only return records for Carstop.
Steve
Please provide an example of data where you are having trouble filtering. (Note in your example you have mistakenly added an equal sign and typed a semi-colon instead of comma between the quoted list of values.)
proc sql;
create table target as
select *
from source
where value in ("Tom's Trucks" , "Carstop")
;
quit;
Also since this is SQL code are you perhaps not running that WHERE clause in SAS but have actually pushed it into some remote database that has a different understanding of the meaning of double quote and single quotes?
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.