Thank you Nick. I appreciate your response (it solved my
problem)!
cheers, clint
On 9 Jul 2003 at 19:32, Nick Cox wrote:
> [email protected]
>
> > I am working with a dataset containing approx. 5400
> > observations and I was able to extract the information I needed
> > via the -table- command, in specifically,
> > -table countyname admt_mnth admt_yr, contents(freq) concise-
> > and for the second (and more cumbersome extraction)
> > -table countyname admt_wk admt_mnth if admt_mnth==9 &
> > admt_yr==1991, contents(freq) concise-
> > where the -if- statement was changed repeatedly until I reached
> > month 12 and year 2001 (otherwise, the output was too difficult
> > to read since admt_wk allows for 52 possible values). I
> > printed the output via creation of a log file and saving it
> > with a .smcl extension (which prints nicely, btw), however, I
> > need to create rates using a different population and thus
> > would like to output the tables to an Excel file (because
> > manual input wants to be avoided) where the counties would be
> > listed down the rows and the weeks (all 52) listed across the
> > top with the corresponding number of cases in each cell. I
> > read the Statalist email from 20 June regarding 'exporting
> > tables' but I am unable to follow what they suggest or my
> > objective differs from theirs. Can anyone provide insight or
> > another method more amenable to my objective (e.g. creation of
> > new variables altogether)?
>
> I understand that you want a fairly wide table,
>
> rows counties
> cols weeks
> cells frequencies,
>
> exported to Excel (not clear on why the latter).
>
> I am not sure that -table- is your best bet.
> I would try more rudimentary approach
>
> preserve
> contract county week
> reshape wide _freq, i(county) j(week)
> outsheet using toexcel
> restore
>
> Nick
> [email protected]
> *
> * 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/
