Tabulation with percentage

[Mohamud Hussein]

Hi,

I would like to obtain a table with the cross-tabulation reported below but with the count (i.e. 40,290; 8,125 etc) reported as percentage (%) of the total figure (i.e. 474,025 ).

Could you please help me to amend my command below to get the % figures accordingly?

Thanks,
Mohamud

tab avex strata

           |                                         Strata
      avex |       302        303        304        305       1103       1203       1204       1303 |     Total
-----------+----------------------------------------------------------------------------------------+----------
   1.46587 |         0          0          0          0          0          0          0          0 |    21,496 
  3.169218 |         0          0          0      9,710          0          0          0          0 |     9,710 
  3.260634 |         0          0          0          0          0          0          0          0 |    15,530 
  3.923852 |         0      8,125          0          0          0          0          0          0 |     8,125 
    4.1981 |    40,290          0          0          0          0          0          0          0 |    40,290 
  4.260475 |         0          0     73,515          0          0          0          0          0 |    73,515 
  4.421704 |         0          0          0          0          0          0          0          0 |   107,017 
  4.612422 |         0          0          0          0          0          0          0          0 |    92,694 
  5.102622 |         0          0          0          0          0          0          0          0 |    13,317 
  5.244775 |         0          0          0          0          0          0          0          0 |     9,198 
  5.443166 |         0          0          0          0          0          0          0          0 |    17,819 
  6.105625 |         0          0          0          0          0          0          0          0 |    52,383 
  7.141977 |         0          0          0          0      2,796          0          0          0 |     2,796 
    7.2193 |         0          0          0          0          0          0      3,817          0 |     3,817 
  9.532184 |         0          0          0          0          0          0          0      3,932 |     3,932 
  11.78654 |         0          0          0          0          0      2,386          0          0 |     2,386 
-----------+----------------------------------------------------------------------------------------+----------
     Total |    40,290      8,125     73,515      9,710      2,796      2,386      3,817      3,932 |   474,025

[Rich Goldstein]

as shown in the help file, you appear to want:

 
 tab avex strata, cell nofreq

note that my addition of the "nofreq" is a guess; if you want both frequencies and cell percentages, eliminate the "nofreq" part; note that tab also offers "row" and "column" percentages thru the "row" and "column" options

[Mohamud Hussein]

Thanks Rich.