DATA Step, Macro, Functions and more

PROC SQL - String Matching in variable values

Accepted Solution Solved
Reply
Contributor
Posts: 23
Accepted Solution

PROC SQL - String Matching in variable values

[ Edited ]

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 

 


Accepted Solutions
Solution
‎01-05-2018 05:13 PM
Super User
Posts: 22,850

Re: string Matching-proc sql

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. 

 

View solution in original post


All Replies
Solution
‎01-05-2018 05:13 PM
Super User
Posts: 22,850

Re: string Matching-proc sql

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. 

 

☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 1 reply
  • 132 views
  • 0 likes
  • 2 in conversation