[Date Prev][Date Next][Thread Prev][Thread Next][Date index][Thread index]

From |
"Nick Cox" <n.j.cox@durham.ac.uk> |

To |
<statalist@hsphsun2.harvard.edu> |

Subject |
st: RE: RE: counting |

Date |
Wed, 29 Sep 2004 14:42:30 +0100 |

Another way to do this is If _N < 10000 local N = _N set obs 10000 In general gen count = . qui forval i = 1/10000 { count if d0 == `i' replace count = r(N) in `i' } gen class = string(_n) + ".5" outsheet count class <etc.> in 1/10000 If original less than 10000 keep in 1/`N' Nick n.j.cox@durham.ac.uk > -----Original Message----- > From: owner-statalist@hsphsun2.harvard.edu > [mailto:owner-statalist@hsphsun2.harvard.edu]On Behalf Of Nick Cox > Sent: 29 September 2004 14:02 > To: statalist@hsphsun2.harvard.edu > Subject: st: RE: counting > > > You got what you asked for. > > By default -count- shows its result. > > -display- with no arguments shows a blank line. > > Alternatively, suppress the -count- result and do this: > > forval i = 1/10000 { > qui count if d0 == `i' > di "`i'.5" "{col 8}" r(N) > } > > -outsheet- isn't going to help with this because you > are not putting the results in a variable. A better > way to put this in a file is e.g. using -postfile-. > > Nick > n.j.cox@durham.ac.uk > > Andreas Aschbacher > > > I have d0 as variable-name for one column of my data : > > I use the following in a do-file: > > > > local i = 1 > > while `i' < 10000 { > > count if d0 >= `i' & d0 < `i' + 1 > > display > > local i = `i' + 1 > > } > > > > -> and I get in my logfile -> > > ..... > > 22 > > > > 27 > > > > 47 > > > > 67 > > > > 63 > > > > 84 > > > > 116 > > > > 195 > > ....... > > -> always with empty lines between !!! > > -> but I want to get the following : > > 1.5 22 > > 2.5 27 > > 3.5 47 > > 4.5 67 > > 5.5 63 > > 6.5 84 > > 7.5 116 > > 8.5 195 > > .. > > .. > > 9999.5 12 > > : with no emty lines between and in first column numbers > > ascending from 1.5 > > to 9999.5 with step 1. > > please "quick" advice how to bring the two resulting columns > > automatically > > in excel-Sheet,for example in first and second column.is this > > possible ? > > I was not successful with outsheet. > > * > * For searches and help try: > * http://www.stata.com/support/faqs/res/findit.html > * http://www.stata.com/support/statalist/faq > * http://www.ats.ucla.edu/stat/stata/ > * * For searches and help try: * http://www.stata.com/support/faqs/res/findit.html * http://www.stata.com/support/statalist/faq * http://www.ats.ucla.edu/stat/stata/

- Prev by Date:
**RE: st: [pooling in ordered logit]** - Next by Date:
**Re: st: RE: counting** - Previous by thread:
**st: RE: counting** - Next by thread:
**st: Re: requires version** - Index(es):

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