I don't use excel but maybe this would work as well. Save the file as a
txt file with comma delimiters. Bring it into stata using the insheet
command. I have done that dozens of times and it works on my linux
version of stata (and my solaris version as well).
I do think to make the above work you'd need to make a . the decimal
separator, and probably also use nothing to separate thousands (e.g.,
1000, not 1,000).
Hope this helps.
Sam
On Fri, 23 Jul 2004, Armen Khachatryan 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/
>
*
* 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/
