Save file as a text (tab delimited file) in excel. In
stata insheet using yourfile.txt (this should work
well and if your first row in excel has variable names
even better, stata will take these as the variable
names as it is insheeting your data)
Ronnie
Ps: Remember to increase your memory before insheeting
--- Armen Khachatryan <[email protected]> wrote:
> Dear colleagues,
>
> I am new to STATA, I apologize for asking simple
> questions.
> The matter is that I try to bring in a relatively
> large dataset of some
> 6000 obs, and 20 variables from EXCEL.
> I converted the file into csv, and read into STATA
> with INSHEET.
> STATA reads all as one single V1 with those many
> observations.
>
> In my Excel file I have tried to change the European
> comma decimal
> separator to be a dot. The result is the same. What
> should I do to get
> my Excel file normally read by STATA?
>
> Any help would be highly appreciated.
>
> Armen
>
> Armen Khachatryan
> University of Hohenheim
> Stuttgart, Germany
> Tel: 0049 (0)711/459 26 00 or 33 03
> Fax: 0049 (0)711/459 37 62 or 37 09
>
>
>
>
> *
> * 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!?
New and Improved Yahoo! Mail - Send 10MB messages!
http://promotions.yahoo.com/new_mail
*
* 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/
