Re: Searching literals

malena · Posted 11-17-2017 10:30 AM

I am doing literal searches for several variables for specific terms.

One of these variables contains a description of up to 100 terms. So I am doing a search on this variable for a specific term: One of these terms is "OD". But I do not want to count them if the terms are "probable OD" or "suspected OD".

I am using these 2 functions: findw and index, are these any other better functions to use?

thanks!

mkeintz · Posted 11-17-2017 10:35 AM

Please show example, using a starting SAS data set, and the desired result.

--------------------------
The hash OUTPUT method will overwrite a SAS data set, but not append. That can be costly. Consider voting for Add a HASH object method which would append a hash object to an existing SAS data set

Would enabling PROC SORT to simultaneously output multiple datasets be useful? Then vote for
Allow PROC SORT to output multiple datasets

--------------------------

Reeza · Posted 11-17-2017 10:39 AM

PRXMATCH, which is regular expressions. They're incredibly powerful for searching text strings.

Searching literals

Re: Searching literals

Re: Searching literals

SAS Innovate 2025: Call for Content

Click image to register for webinar

Classroom Training Available!