Re: st: tabulation question

[Nikolaos Pandis <nikpandis@gmail.com>]

Nick,
tabm !!!
can you add row %?
Thank you,
Nick

On Mon, Nov 4, 2013 at 11:35 PM, Nikolaos Pandis <nikpandis@gmail.com> 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 <serjradyakin@gmail.com> 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 <nikpandis@gmail.com> 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 <serjradyakin@gmail.com> 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 <nikpandis@gmail.com> 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/