BookmarkSubscribeRSS Feed
Kritha
Calcite | Level 5

Trying to use where statement Like 'R%' but how to get ending with letter A?

3 REPLIES 3
PGStats
Opal | Level 21

where prxMatch("/^R.*A$/i", myVariable) > 0;

 

 

PG
Riteshdell
Quartz | Level 8

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;

 

result.PNG

sas1212.PNG

Kritha
Calcite | Level 5

Thankyou very much for your reply

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

How to Concatenate Values

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.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 3 replies
  • 2177 views
  • 3 likes
  • 3 in conversation