Stata The Stata listserver
[Date Prev][Date Next][Thread Prev][Thread Next][Date index][Thread index]

Re: st: variables copy


From   "Michael Blasnik" <[email protected]>
To   <[email protected]>
Subject   Re: st: variables copy
Date   Thu, 01 Dec 2005 08:26:32 -0500

This is a terrible idea on many levels -- not only can you lose precision and labeling, not only does it require you to do something that isn't documented or automatically repeatable (through do/log files), but why would you ever want to tediously cut and paste columns in Excel when you could much more easily just type drop or keep in Stata? These aren't tricky commands.

Michael Blasnik
[email protected]


----- Original Message ----- From: "b. water" <[email protected]>
To: <[email protected]>
Sent: Thursday, December 01, 2005 4:50 AM
Subject: RE: st: variables copy



dear yang li,

my suggestion might be frown upon by others but could get the job done till such time you become comfortable with stata.

put your original data in excel (if it's in stata .dta, copy paste to excel from the editor), highlights those unwanted columns, cut and paste them to another sheet (in case you need them in the future) then copy and paste the columns that you want into stata.

another approach, which i would encourage you if you think you would be stataing for a while is to invest time in understanding joseph's do-file. it can be re-applied ad-infinitum with minor jiggling to another similar problems.

best wishes,
bw

ps: assuming you have excel that is
*
*   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/



© Copyright 1996–2024 StataCorp LLC   |   Terms of use   |   Privacy   |   Contact us   |   What's new   |   Site index