If you're going to make a .csv file anyway, there is no need to use
Stat/Transfer. You can just save as .csv from Excel. Once you have a
.csv with the variable names included as the first row, you can import
into Stata using -insheet- with the -names- option.
If you want to use Stat/Transfer, check the "Field Name Row" section
under the "Options (2)" tab to make sure you will be preserving the
column names.
Alex
-----Original Message-----
From: [email protected]
[mailto:[email protected]] On Behalf Of buddyb
Sent: Thursday, June 08, 2006 2:26 PM
To: [email protected]
Subject: Re: st: import variable names from excel
Thanks Joe,
I've used Stat/Transfer - and it makes a .csv file,
which I then import into Stata (though I think it
leaves the variable names off at that point?). I can
copy and paste as well. Whatever works best. thanks
for your help.
Buddy
--- [email protected] wrote:
> Buddy,
>
> When you say import, do you mean that you are doing
> a copy and paste from
> Excel to Stata's data editor, reading the file in
> from a tab delimited or
> .csv file, or using Stat/Tranfer software to put the
> Excel data into Stata
> format?
>
> Joe
>
>
>
>
>
>
> buddyb
>
> <buddyb_99@yahoo.
>
> com>
> To
> Sent by:
> [email protected]
> owner-statalist@h
> cc
> sphsun2.harvard.e
>
> du
> Subject
> st: import
> variable names from
> excel
>
> 06/08/2006 02:12
>
> PM
>
>
>
>
>
> Please respond to
>
> statalist@hsphsun
>
> 2.harvard.edu
>
>
>
>
>
>
>
>
> Hi Everyone,
>
> I did a FAQ search on this and got some wierd
> results.
> I'm new to STATA and have a simple question.
>
> I want to import an excel file that has variable
> names
> on the first line. For some reason, it imports the
> data but not the variable names. Can anyone help?
>
> Thanks,
> Buddy
>
> __________________________________________________
> Do You Yahoo!?
> Tired of spam? Yahoo! Mail has the best spam
> protection around
> http://mail.yahoo.com
> *
> * 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/
>
> *
> * 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/
>
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
*
* 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/
This message is intended solely for the designated recipient(s). It may contain confidential or proprietary information and may be subject to confidentiality protections. If you are not a designated recipient, you may not review, copy, or distribute this message. If you receive this in error, please notify the sender by reply e-mail and delete this message.
Arrowstreet Capital, L.P. is an Equal Opportunity Employer.
*
* 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/
