Conditional Row Delete
On Feb 3, 4:47 pm, wrote:
Review many postings on conditional row delete but still need help. I
want to delete all rows where there are fewer than 5 companies within
industry. The median within that industry is not very useful if there
are less than 5, or some other number, of companies.
Company SIC Code Sales
If frequency of SIC code is less than 5, then delete the row.
Please help.
It's the "freqency" part that's important. I don't want an industry
which is only represented by five or fewer companies. The SIC code
will change. For example if there are five companies within the SIC
Code 1, then I want to keep them and calculate medians, otherwise
delete the company.
|