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: [email protected]
[mailto:[email protected]] On Behalf Of Ángel Rodríguez
Laso
Sent: Thursday, October 16, 2008 2:39 PM
To: [email protected]
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 <[email protected]>:
> 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: [email protected]
> [mailto:[email protected]] On Behalf Of Ángel Rodríguez
> Laso
> Sent: Thursday, October 16, 2008 10:11 AM
> To: [email protected]
> 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 <[email protected]>:
>> 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: [email protected]
>> [mailto:[email protected]] On Behalf Of Ángel
Rodríguez
>> Laso
>> Sent: Monday, October 13, 2008 12:28 PM
>> To: [email protected]
>> 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/
