PROC SQL - String Matching in variable values

[riya275]

I want to filter rows which end with July , august and September and i want to use proc sql to do that.

proc sql;
create table l as
select label 
from a6.labels 
where label like "%July"  ;
quit;

This code works for filtering out rows ending with july 

(however i do get an error -WARNING: Apparent invocation of macro JULY not resolved.)

how do i get rows ending with august and spetember as well in one dataset?

where label like "%July" and "%August" 

this doesnt work 

[Reeza · Accepted solution]

1. Use single quotes, not double quotes to remove the note from your log. 

2. You can combine the conditions using OR

label like '%July' or label like '%August';

You can also use INDEXW or FINDW, but you may want to consider case, UPCASE, because in string comparisons, august is not equal to August.