Statalist


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

RE: st: RE: Sorting in a table a list of binomial variables by frequency of apparition in a survey context


From   "Martin Weiss" <martin.weiss1@gmx.de>
To   <statalist@hsphsun2.harvard.edu>
Subject   RE: st: RE: Sorting in a table a list of binomial variables by frequency of apparition in a survey context
Date   Thu, 16 Oct 2008 14:41:57 +0200

Go to Data - Text to Columns and use "comma" as a separator in the dialog
box... That is not so much a Stata but an Excel issue, though... You might
also consider Stat/Transfer in conjunction with the -ssc d stcmd- package
which would spare you the Excel issue...


HTH
Martin


-----Original Message-----
From: owner-statalist@hsphsun2.harvard.edu
[mailto:owner-statalist@hsphsun2.harvard.edu] On Behalf Of Ángel Rodríguez
Laso
Sent: Thursday, October 16, 2008 2:39 PM
To: statalist@hsphsun2.harvard.edu
Subject: Re: st: RE: Sorting in a table a list of binomial variables by
frequency of apparition in a survey context

It doesn't work. I get in Excel something very similar to what I got
copying the -list- output, all variables from each observation
(disease) in the same cell, separated by commas:


eq,estimate,ci
hypertension,14.3,"(12,6-16,1)"
artrosis,14.0,"(12,1-15,8)"
alergy,10.4,"(8,8-12,1)"
.
.
.


Note that ci is a new string variable obtained from min95 and max95,
but I don't think this matters.

Best regards,


Angel

2008/10/16 Martin Weiss <martin.weiss1@gmx.de>:
> As your dataset is identical with the list output, try this:
>
> ************
> cap ssc inst parmest
> sysuse auto, clear
> prop r
> parmest, saving(myfile, replace)
> u myfile, clear
> drop  eq parm dof t p
> gsort -est
> *l
> outsheet using myfile.csv, comma replace
> ! myfile.csv
> ************
>
>
>
> HTH
> Martin
>
>
> -----Original Message-----
> From: owner-statalist@hsphsun2.harvard.edu
> [mailto:owner-statalist@hsphsun2.harvard.edu] On Behalf Of Ángel Rodríguez
> Laso
> Sent: Thursday, October 16, 2008 10:11 AM
> To: statalist@hsphsun2.harvard.edu
> Subject: Re: st: RE: Sorting in a table a list of binomial variables by
> frequency of apparition in a survey context
>
> Thanks, Martin, it worked very well.
>
> The only problem is that the -list- output copied to Excel doesn't
> look nice. I've sorted it out through transferring the .dta obtained
> with parmest to .txt and then reading it in Excel. This takes some
> time. I wonder if there is a quicker way to paste the -list- output
> (or any other alternative command that tabulates in a similar way)
> into Excel.
>
> Best regards,
>
> Angel Rodriguez-Laso
>
> 2008/10/13 Martin Weiss <martin.weiss1@gmx.de>:
>> Why not use -proportion- which allows -pweight-s and then store the
> results
>> via -ssc d parmest-. Save it with -parmest- as .dta and -gsort
-estimates-
>> afterwards. Then -list- and you have your table...
>>
>> Example (w/o pweights):
>>
>> ************
>> cap ssc inst parmest
>> sysuse auto, clear
>> prop r
>> parmest, saving(myfile, replace)
>> u myfile, clear
>> drop  eq parm dof t p
>> gsort -est
>> l
>> ************
>>
>>
>> HTH
>> Martin
>>
>>
>> -----Original Message-----
>> From: owner-statalist@hsphsun2.harvard.edu
>> [mailto:owner-statalist@hsphsun2.harvard.edu] On Behalf Of Ángel
Rodríguez
>> Laso
>> Sent: Monday, October 13, 2008 12:28 PM
>> To: statalist@hsphsun2.harvard.edu
>> Subject: st: Sorting in a table a list of binomial variables by frequency
> of
>> apparition in a survey context
>>
>> Dear Statalisters,
>>
>> I have a list of binomial variables where 1 means that the individual
>> has a determined disease. I need a table where proportions (and their
>> confidence intervals) of these variables (diseases) appear in
>> descending order. Although tab1 has a sort option, my data belong to a
>> survey where pweights are used, and tab1 only accepts fweights (that
>> need to be integers, which is not the case).
>>
>> Any alternative?
>>
>> Many thanks.
>>
>> Angel Rodriguez-Laso
>> *
>> *   For searches and help try:
>> *   http://www.stata.com/help.cgi?search
>> *   http://www.stata.com/support/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/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/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/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/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/statalist/faq
*   http://www.ats.ucla.edu/stat/stata/



© Copyright 1996–2014 StataCorp LP   |   Terms of use   |   Privacy   |   Contact us   |   What's new   |   Site index