Trying to use where statement Like 'R%' but how to get ending with letter A?
where prxMatch("/^R.*A$/i", myVariable) > 0;
Use variable_name LIKE 'R%A';
Below I am creating a dataset which data consist start with R and end with A.
Code to create sample data set "
data demo;
input name $;
datalines;
RITA
SITA
NITA
RASHNA
KAVITA
;
RUN;
code to search letter start with R and end with A.
PROC PRINT DATA =DEMO;
WHERE NAME LIKE 'R%A';
RUN;
Thankyou very much for your reply
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.