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.
0 Response to Minimum (or Maxium) Value in a Matrix
Post a Comment