Statalist The Stata Listserver


[Date Prev][Date Next][Thread Prev][Thread Next][Date index][Thread index]

Re: st: ONE STATA QUESTION ON READING DATA


From   "Svend Juul" <SJ@SOCI.AU.DK>
To   <statalist@hsphsun2.harvard.edu>
Subject   Re: st: ONE STATA QUESTION ON READING DATA
Date   Mon, 19 Mar 2007 10:12:22 +0100

Frank wrote:

I have tried

   infile col1-col5 using C:\statafile\grade2006.txt, clear

what I saw in the results window of STATA is as follows. 
And since the file is large, it can't stop, which probably 
means there are so many stuff not being able to read.

Is there something wrong again? 
infile col1-col5 using C:\statafile\grade2006.txt, clear
'1.00000.000000.000000.000000' cannot be read as a number for col1[117]
'351.000001.00000' cannot be read as a number for col1[120]
'84147149865196.12309.60336.63218.34402.96' cannot be read as a number
for col1
--------------------------------------------------------------

Frank,

Do you have a description of the structure and contents of the
ascii-file? If not, we can only guess. The command
   infile col1-col5 using ...
requires that the file is tab- or comma-separated, and from the error
messages that does not seem to be the case.

A fixed-format ascii-file without a format description is pretty
useless. Maybe KGB or CIA can find out, but we can't.

Svend

__________________________________________

Svend Juul
Institut for Folkesundhed, Afdeling for Epidemiologi
(Institute of Public Health, Department of Epidemiology)
Vennelyst Boulevard 6
DK-8000  Aarhus C, Denmark
Phone: +45 8942 6090
Home:  +45 8693 7796
Email: sj@soci.au.dk
__________________________________________ 

*
*   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–2014 StataCorp LP   |   Terms of use   |   Privacy   |   Contact us   |   What's new   |   Site index