How to filter out string observations with common characters?

[Chris Jiao]

Hi Statalisters,

I am new to Stata and when I work on my data. I want to filter out string observations with common characters. For example, as the following chart shows, the string variable name is InstituteName and it contains many observations. However, these five observations presented below have a common character "Government" thus I want filter out them with character "Government". What command should I use to deal with this problem?

InstituteName

US Government

US Government

U.S Government

U.S Government

U S Government

[Salvatore Lattanzio]

You can use regexm. Example with browse:

browse if regexm(InstituteName,"Government")

[Chris Jiao]

You can use regexm. Example with browse:

browse if regexm(InstituteName,"Government")

Great tips. Thanks!