Notice: On April 23, 2014, Statalist moved from an email list to a forum, based at statalist.org.
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/