Keep the dot, save as CSV (with semicolon ";" as a separator), and then
insheet your_file.csv, delimiter(";")
(from memory, see help insheet)
--- Ben
-----Original Message-----
From: Armen Khachatryan [mailto:[email protected]]
Sent: vrijdag 23 juli 2004 13:42
To: [email protected]
Subject: st: insheet command
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/
