Filtering for text the includes single quote

[sutzig]

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]

1. Missing semicolon to end query (in red below)
2. SQL needs a QUIT, not a RUN (orange/purple below). Remove the RUN and leave the QUIT in and that should be good.

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.

---

[sutzig]

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 

[Tom]

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?