Bookmark and Share

Notice: On March 31, it was announced that Statalist is moving from an email list to a forum. The old list will shut down on April 23, and its replacement, statalist.org is already up and running.


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: st: Spreadsheet to STATA


From   David Backer <dabacker@umich.edu>
To   statalist@hsphsun2.harvard.edu
Subject   Re: st: Spreadsheet to STATA
Date   Tue, 6 Mar 2012 17:13:01 -0500 (EST)

Or you can first transpose the data in the spreadsheet, prior to pasting into the Stata data editor. This is simple enough to do in any version of Microsoft Excel -- COPY, then PASTE SPECIAL selecting the TRANSPOSE option.

David Backer

On Tue, 6 Mar 2012, Richard Goldstein wrote:

why not read it as is and then uses Stata's -xpose- command?

Rich

On 3/6/12 4:12 PM, solafem7@yahoo.co.uk wrote:
Hi
 Please, can anybody assist  me. Am trying to copy and paste data that are
arranged in row form in spreadsheet to be in column form  in Data Editor in
STATA. But I could not do this. Can anybody help with the trick?
Sola.

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



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


© Copyright 1996–2014 StataCorp LP   |   Terms of use   |   Privacy   |   Contact us   |   Site index