Hi.
I have a very long data set where I have a number of observations for each id. In each observation there is a string variable with a procedure text - lets call it "Surgical procedure".
I want to list (display) the 3 most reoccurring "surgical procedures". In other words I want the 3 most frequently performed procedures presented as median.
Example:
id Surgical procedure
1 Procedure A
1 Procedure B
2 Procedure A
2 Procedure C
2 Procedure A
3 Procedure D
3 Procedure B
4 Procedure A
4 Procedure A
4 Procedure A
4 Procedure D
4 Procedure B
4 Procedure C
I hope this is enough info to get som help.
Thanx
Related Posts with How to display the 3 most reoccurring observations in a string variable (presented as median)
data calculation.Dear All, Suppose that I have the following data Code: * Example generated by -dataex-. To install:…
Summary table (F, df) for Mixed ModelsHello, I'm new to Stata and I'm trying to obtain a summary table for a mixed model as shown in the e…
Margins for semiparametric regressionHello, I'm trying to estimate a semi-parametric regression model with (1) a continuous and a catego…
Interpretation stata resultsHello, I'm doing a master thesis on the effect of CSR contracting on CSR performance. My model is b…
Differents results depending order of independent variables in ANOVAHi all, I am having differents results in a Anova analysis depending order of independent variables…
Subscribe to:
Post Comments (Atom)
0 Response to How to display the 3 most reoccurring observations in a string variable (presented as median)
Post a Comment