PROC SQL - String Matching in variable values

riya275 — Fri, 05 Jan 2018 22:11:38 GMT

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

Re: string Matching-proc sql

Reeza — Fri, 05 Jan 2018 22:09:32 GMT

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.