Dear All,
I am working with firm level data. I want to generate a variable lsales = ln(sales) and want to replace the values in lsales as missing if the values in the variable lsales are higher than mean+3*standard deviation. While doing so, I want the summary stat of lsales by grouping state and sector and if the observation of lsales is more than 1000 in the individual group (state-sector) then find the outlier and replace it as missing. If the number of observation is less than 1000 in any of the group (state-sector) then I want to group lsales by the state only and find out the summary stat and replace the outlier with missing values. Please suggest to me how should I code this, as I am unable to visualise the loop for the condition.
Thanks
Prakash
Related Posts with Generating variable and replacing the outlier as missing based on grouping and condition
Panel data OLS time and ID restrictions.Hello I want to make an OLS regression in Stata my regression will be Code: regress regress inte…
How to get price spells ?I have Monthly prices data of many goods for 10 years. I need to get the price spells i.e. the durat…
Error (3200) in meglm, when using X##X, but no error with X and X_squaredDear Statalist members, I am using Stata 17 MP (duly updated). The models and the data I am fitti…
Stock variable problemDear Statalist, I am trying to address the perpetual method in order to build a stock variable. Basi…
A squared term is negative and significant but the graph is not.A squared term is negative and statistically significant, suggesting an inverted-U relationship as h…
Subscribe to:
Post Comments (Atom)
0 Response to Generating variable and replacing the outlier as missing based on grouping and condition
Post a Comment