I am using Stata 16 on Windows 10. I am running analyses (logit and mlogit) on 12 outcome variables, 11 exposure variables and 9 adjustment variables in three primary models. I've created a do file that successfully outputs my results to an excel file using putexcel. For each set of variables, I'd also like to use putexcel to output the frequency of the minimum "cell" size within the cross-tabulation of my my variable pairs. For example:
. tab sex group, matcell(x)
...........| Group
.......Sex | Sham Experiment | Total
-----------+----------------------+----------
......Male | 48 40 | 88
....Female | 29 38 | 67
-----------+----------------------+----------
.....Total | 77 78 | 157
. matrix list x
x[2,2]
....c1 c2
r1 48 40
r2 29 38
(Sorry about the inserted periods - I couldn't get the formatting correct.) For the above, the value I'd like returned would be 29. The matrices will vary from a 2X2 up to a 4X5 matrix.
I've tried:
. display min(x)
invalid syntax
r(198);
. generate minx=min(`x')
invalid syntax
r(198);
. generate minx = min(x)
invalid syntax
r(198);
. generate minx==min(x)
== invalid name
r(198);
But I obviously don't have something correct. I appreciate any help. Thank you.
Related Posts with Minimum (or Maxium) Value in a Matrix
Should I use a heckman selection model when extracting a subset of my data for analysis?This is a new topic for me, so pardon my basic understanding of the heckman model. In fact, it's pos…
Forest plot of sub-groups and testing for interactionDear Statlist, I'm trying to generate a forest plot to demonstrate how various parameters from my r…
Drop (Keep) observationsDear experts, I'm wondering how to drop (or keep) my observations. Below is my dataset. What I want…
Adding post-estimation results in -esttab- table by adding more columns to e(b) and columns and rows to e(V)Dear Statalist, I want to put -nlcom- results in esttab table and these -nlcom- results are treated…
Can I use multiple imputed data in a principle component analysis if my data are not normally distributed?Is it possible to use multiple imputed data in a principle component analysis if my data are not nor…
Subscribe to:
Post Comments (Atom)
0 Response to Minimum (or Maxium) Value in a Matrix
Post a Comment