Notice: On April 23, 2014, Statalist moved from an email list to a forum, based at statalist.org.
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
st: export count result into excel
From
dluo1@uci.edu
To
statalist@hsphsun2.harvard.edu
Subject
st: export count result into excel
Date
Wed, 20 Apr 2011 12:15:22 -0700
Hi statalist,
Is there any way I can transfer below table into excel file without
copying and pasting from the stata screen? My command is to count by
market how many American Airline(AA) appear in each market.
. by market1, sort:count if opcar1 == "AA"
-> market1 = 1
0
-> market1 = 2
0
-> market1 = 3
0
-> market1 = 4
0
-> market1 = 5
0
-> market1 = 6
0
-> market1 = 7
0
-> market1 = 8
0
-> market1 = 9
26
-> market1 = 10
32
-> market1 = 11
0
...
Thanks!
Dan Luo
PhD in Economics
University of California, Irvine
*
* 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/