BookmarkSubscribeRSS Feed
mlogan
Lapis Lazuli | Level 10

Hi All, I am trying to retrieve all observations where the text 'Beautiful' appear within the observation value. My problem is the text 'Beautiful' sometimes appear as lower case (beautiful) and sometimes at the beginning and sometimes in the middle of the sentence.

This is the code i wrote and they are not working (both sas and sql). can someone help please. Thanks,

/*Following code bring everything except when the word 'beautiful' appear in the middle of the sentence*/

data out;

set have;

where desc like ("%Died%");

run;

Following code doesn't work at all.

following code

proc sql;

create table out as

select * from have where desc in ("%Died%");

quit;

1 REPLY 1
dcruik
Lapis Lazuli | Level 10

You can try and subset the data set with a FIND() function and use the modifier that ignores case.

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 choose a machine learning algorithm

Use this tutorial as a handy guide to weigh the pros and cons of these commonly used machine learning algorithms.

Find more tutorials on the SAS Users YouTube channel.

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