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   "Ángel Rodríguez Laso" <angelrlaso@gmail.com>
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   Fri, 17 Oct 2008 13:55:41 +0200

With Stat/Transfer and stcmd works beautifully.

Many thanks again.

Angel Rodriguez-Laso

2008/10/16 Martin Weiss <martin.weiss1@gmx.de>:
> 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/
>

*
*   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