Bookmark and Share

Notice: On April 23, 2014, Statalist moved from an email list to a forum, based at

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: st: Re: string comparision

From   San Chu <[email protected]>
To   "[email protected]" <[email protected]>
Subject   Re: st: Re: string comparision
Date   Mon, 30 Jul 2012 20:34:18 -0700 (PDT)

Hi Tashi,

I think strpos is what you need

list if strpos(Name,"Jo")>0


----- Original Message -----
From: Joseph Coveney <[email protected]>
To: [email protected]
Cc: 'tashi lama' <[email protected]>
Sent: Monday, July 30, 2012 9:43 PM
Subject: st: Re: string comparision

Tashi Lama wrote:

Is there a direct way of listing variables matching all of the some of the
strings, similar to sql functions "like" and "rlike" ? Here is my dataset say,

ID    Name 
1    John Malda 
2    Sam Houston 

I would like to list Name var matching full or part of the string something like

list if Name like "Jo"

I searched for previous posts related to above question and found some of the
string-matching functions/commands like strgroup, reclink and strmatch. I can
picture using strmatch to solve my problem but that wouldn't be direct in the
sense, I will have to use loops and may be create indicator  variables to get my
job done. But again, I can only picture at this point. Any folks know any direct
and better options? 


Stata's -strmatch()- function does just what you want.  It works with wildcard
symbols, just like SQL's LIKE.  -strmatch()- is direct, and you don't need to
create indicator variables or use loops.  See illustration below.

Stata also has regular expression capabilities, but they're not needed to do 
what you show that you want to accomplish.

Joseph Coveney

. drop _all

. input byte ID str244 Name 

>                      Name
  1. 1 "John Malda"
  2. 2  "Sam Houston"
  3. end

. list if strmatch(Name, "*Jo*"), noobs

  | ID        Name |
  |  1  John Malda |

*  For searches and help try:

*   For searches and help try:

© Copyright 1996–2018 StataCorp LLC   |   Terms of use   |   Privacy   |   Contact us   |   Site index