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/
