st: Using statsby and corr to ouput a table of correlations

["Joseph McCrary" <joemccrary@fastmail.fm>]

I am using the following command in Stata 7 SE:

     statsby "corr  engscale mark" r(corr_12)  r(N), by(sch_e)

to generate a table of correlations by school. When I list the results, I
get:

         sch_e     _stat1     _stat2
  1.        40          .        845
  2.        70          .        238
  3.       178          .         28
  4.       181          .         65
  5.       239          .         44
  6.       303          .         19
  7.       400          .        365
  8.       401          .        354
  9.       402          .        584
 10.       403          .        331
 11.       405          .        899
 12.       406          .        359
 13.       407          .        229
 14.       410          .        416
 15.       411          .        502
 16.       412          .        499
 17.       414          .        216
 18.       450          .        290
 19.       451          .          9
 20.       454          .        376
 21.       456          .         36
 22.       457          .         31
 23.       480          .        440
 24.       488          .         27

Why is _stat1 missing? What should I place in the statsby command to
produce the correlation matrix?

Thank you.

Joe McCrary
*
*   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/