Extract data

[Olivia Emma]

Hello

I have a data for African countries and I want to keep only the data for countries with this code
COM
ETH
KEN


how I can do this please

[Olivia Emma]

this command worked

keep if country == "COM" | country == "ETH" | country == "KEN" | country == "MUS" | country == "MWI" | country == "ZMB" | country == "ZWE"

[Clyde Schechter]

Yes, that would work. You could also save yourself some typing by doing this instead:

keep if inlist(country, "COM", "ETH", "KEN", "MUS", "MWI", "ZMB", "ZWE")

With strings, -inlist()- is available to you for up to 9 such countries. If in another situation you had a larger number of countries, you would have to do something more complicated such as breaking them into groups of 9 and then conjoining the separate -inlist()- terms with |.

[Olivia Emma]

Yes, that would work. You could also save yourself some typing by doing this instead:

keep if inlist(country, "COM", "ETH", "KEN", "MUS", "MWI", "ZMB", "ZWE")

With strings, -inlist()- is available to you for up to 9 such countries. If in another situation you had a larger number of countries, you would have to do something more complicated such as breaking them into groups of 9 and then conjoining the separate -inlist()- terms with |.

Thanks