Notice: On April 23, 2014, Statalist moved from an email list to a forum, based at statalist.org.

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

From |
Nikolaos Pandis <[email protected]> |

To |
[email protected] |

Subject |
Re: st: tabulation question |

Date |
Mon, 4 Nov 2013 23:45:37 +0200 |

ok got tabm var1-var30, row thanks On Mon, Nov 4, 2013 at 11:44 PM, Nikolaos Pandis <[email protected]> wrote: > Nick, > tabm !!! > can you add row %? > Thank you, > Nick > > On Mon, Nov 4, 2013 at 11:35 PM, Nikolaos Pandis <[email protected]> wrote: >> Sergiy, >> >> Thank you for the explanation. >> I used "tabulate" and it worked out great. >> I have 30 variables but all have 3 levels-so no problem there and I >> can do a little editing >> A 'transpose" option would have been great. >> I tried to use "tabout" but the % did not work-this would have been >> ideal as the table formatting would have been almost done! >> >> see what I get with tabout-but perhaps I am using it incorrectly >> >> ..your previous code... >> foreach myvar of varlist justificationforthetrial-literaturereview { >> tabulate `t' `myvar' , row >> tabout `t' `myvar' using file.xls if rct==1,cells( fre row) f(0c) >> clab(No. %) append >> } >> >> Statistic 1 1 2 2 3 3 Total Total >> No. % No. % No. % No. % >> Freq 15 100 16 100 116 100 147 100 >> Total 15 100 16 100 116 100 147 100 >> Best wishes, >> Nick >> >> On Mon, Nov 4, 2013 at 11:15 PM, Sergiy Radyakin <[email protected]> wrote: >>> Nick, >>> you can get a bunch of different stats with -table-, but not >>> proportions, so try -tabulate- instead of table in the last code line >>> of the above example: >>> tabulate `t' rep78, row >>> >>> I don't know an easy way to get rid of the totals in this table using >>> just options. Also interestingly, the svy version of this command >>> resists such an alignment, and rotates itself when there is only one >>> row into a column. Totally not sure what is the motivation for >>> implementing this behavior, and not having a simple -transposed- >>> option. >>> >>> -tabulate- is built-in, so no way to cut into the middle. >>> >>> Some 6 years ago I wrote a totally custom solution for doing all sort >>> of things like this, but it is plugin-based and Windows-specific, so >>> not sure if it is going to be welcomed. For your case a couple of >>> simple loops would suffice (loop by vars you want, by their levels, >>> summarize if, divide r(N) by _N to get proportions), so there is >>> probably no reason to bring in heavy artillery. >>> >>> I am not sure what you mean with a loop for several variables - they >>> might have different number of categories, so be careful, as you would >>> need to stitch/align the results. >>> >>> Best, Sergiy Radyakin >>> >>> >>> >>> >>> >>> On Mon, Nov 4, 2013 at 3:48 PM, Nikolaos Pandis <[email protected]> wrote: >>>> Sergiy >>>> >>>> Thanks! It looks great >>>> I added a loop to do this for several variables. >>>> How can I add the % of the row total next to the frequencies? >>>> >>>> Best, >>>> >>>> Nick >>>> >>>> On Mon, Nov 4, 2013 at 10:18 PM, Sergiy Radyakin <[email protected]> wrote: >>>>> Yes, Nick: >>>>> do http://radyakin.org/statalist/2013110401/horiz_freq.do >>>>> perhaps there are multiple other ways to do it. >>>>> >>>>> Best, Sergiy Radyakin >>>>> >>>>> On Mon, Nov 4, 2013 at 2:42 PM, Nikolaos Pandis <[email protected]> wrote: >>>>>> Hi, >>>>>> >>>>>> Is there a way to put the levels of the categorical variable (1-3) >>>>>> into the columns and the frequencies in the rows? >>>>>> Thank you, >>>>>> Nick >>>>>> tabulate catvar >>>>>> catvar | >>>>>> | >>>>>> | Freq. Percent Cum. >>>>>> ------------+----------------------------------- >>>>>> 1 | 15 10.20 10.20 >>>>>> 2 | 16 10.88 21.09 >>>>>> 3 | 116 78.91 100.00 >>>>>> ------------+----------------------------------- >>>>>> Total | 147 100.00 >>>>>> * >>>>>> * For searches and help try: >>>>>> * http://www.stata.com/help.cgi?search >>>>>> * http://www.stata.com/support/faqs/resources/statalist-faq/ >>>>>> * http://www.ats.ucla.edu/stat/stata/ >>>>> * >>>>> * For searches and help try: >>>>> * http://www.stata.com/help.cgi?search >>>>> * http://www.stata.com/support/faqs/resources/statalist-faq/ >>>>> * http://www.ats.ucla.edu/stat/stata/ >>>> * >>>> * For searches and help try: >>>> * http://www.stata.com/help.cgi?search >>>> * http://www.stata.com/support/faqs/resources/statalist-faq/ >>>> * http://www.ats.ucla.edu/stat/stata/ >>> * >>> * For searches and help try: >>> * http://www.stata.com/help.cgi?search >>> * http://www.stata.com/support/faqs/resources/statalist-faq/ >>> * http://www.ats.ucla.edu/stat/stata/ * * For searches and help try: * http://www.stata.com/help.cgi?search * http://www.stata.com/support/faqs/resources/statalist-faq/ * http://www.ats.ucla.edu/stat/stata/

**References**:**st: tabulation question***From:*Nikolaos Pandis <[email protected]>

**Re: st: tabulation question***From:*Sergiy Radyakin <[email protected]>

**Re: st: tabulation question***From:*Nikolaos Pandis <[email protected]>

**Re: st: tabulation question***From:*Sergiy Radyakin <[email protected]>

**Re: st: tabulation question***From:*Nikolaos Pandis <[email protected]>

**Re: st: tabulation question***From:*Nikolaos Pandis <[email protected]>

- Prev by Date:
**Re: st: tabulation question** - Next by Date:
**st: Saving variable response sets over many datasets** - Previous by thread:
**Re: st: tabulation question** - Next by thread:
**Re: st: tabulation question** - Index(es):