Dropping values below 5 dollars of variables with openingprice in the name

[Herman Bloemhof]

In my stata data I work with opening prices of nasdaq stocks. This are more than 1000 stocks and I want to only investigate stocks with low prices. So I need to drop all the values above 5 dollars for example. Is there any way I can do this without manually selecting all these variables with a drop command. Because I also have other variables like market cap and volume that should not be included in this. I only want to drop the values if the opening prices are below this value.

[Andrew Musau]

Your post is somewhat confusing. In Stata, you can drop either variables, observations, or both. Values imply observations, but if you drop an observation, it affects all variables in the dataset. Stata is not like Excel, where it is possible to delete a cell in a column without affecting other columns. Take a look at FAQ Advice #12 on how to present a reproducible example, which may make it easier to understand what you're asking and allow us to provide more helpful responses.