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
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.