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?
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
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.
Select SAS Training centers are offering in-person courses. View upcoming courses for: