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
Multidimensional Energy Poverty Index (MEPI)I'm currently working on something related to energy access. While I could easily generate a binary …
Creating an index with missing data in time seriesDear Statalist forum, I would like to ask the following. I have a time series with missing data for…
Finite Mixture Model (FMM) with discrete and continuous partDear Statalist, I have observations in the intervall [0,1] with two modes at 0 and 1. I want to mod…
Importing specific cells from multiple excell sheets in multiple workbooksHello everyone I have a problem I hope I can get your help with. I'm a first time poster, so please…
Simple Bar Graph - Having TroubleHI There, I am looking to put together a simple bar graph that gives me the count of the number tim…
Subscribe to:
Post Comments (Atom)
0 Response to Minimum (or Maxium) Value in a Matrix
Post a Comment