Re: st: tabulation question

[Nikolaos Pandis <nikpandis@gmail.com>]

ok got
tabm var1-var30, row
thanks

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