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
Calculating difference between observations in a panel with missing valuesHello! I am working with online auction data (see -dataex- below), where id is the listing identifi…
calculate averages of groups of observations separated by groups of missing observationsHi everybody, I have panel data with a few variables that have a somewhat random pattern. I need to…
poisson regression with instrumental variables and high dimensional fixed effectsI have a poisson regression model with large number of fixed effects and an endogenous independent v…
Converting R date into STATA dateHi, I am trying to convert R dates into STATA dates but unable to do so. For example, the R date i…
Filling a number of missing variables sharing prefix with "replace"Hi Statalisters, I've merged two datasets which are cross-sectional(year of 2004) and time series(y…
Subscribe to:
Post Comments (Atom)
0 Response to Minimum (or Maxium) Value in a Matrix
Post a Comment