Bookmark and Share

Notice: On March 31, it was announced that Statalist is moving from an email list to a forum. The old list will shut down on April 23, and its replacement, statalist.org is already up and running.


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: st: Problem with "insheet using" command


From   "Michael I. Lichter" <mlichter@buffalo.edu>
To   statalist@hsphsun2.harvard.edu
Subject   Re: st: Problem with "insheet using" command
Date   Fri, 11 Jun 2010 12:50:33 -0400

Jason,

If Stata was reading your numeric and non-numeric data as strings, you'd still have observations. Unless you give us an idea of what your data looks like, we're probably not going to be able to help. Be sure to check that there is no file header other than variable names (and consider using the -names- option), with no blank lines. Also, it's possible that Stata will be confused if the file doesn't have the proper line endings -- it's probably assuming CR-LF in Windows. You might try opening the file in Excel and saving it again as a plain text file. You didn't get any error messages, right?

Michael

Jason Hecht wrote:
I used the following command to import data from an Excel spreadsheet:

insheet using "c:\my documents\y98.csv", comma

However, when I use the describe command to check my summary
statistics I get "O" for the number of observations.  My guess is that
all my data is being read in as strings (the spreadsheet has columns
with numbers and and columns with letters).
*
*   For searches and help try:
*   http://www.stata.com/help.cgi?search
*   http://www.stata.com/support/statalist/faq
*   http://www.ats.ucla.edu/stat/stata/

--
Michael I. Lichter, Ph.D. <mlichter@buffalo.edu>
Research Assistant Professor & NRSA Fellow
UB Department of Family Medicine / Primary Care Research Institute
UB Clinical Center, 462 Grider Street, Buffalo, NY 14215
Office: CC 126 / Phone: 716-898-4751 / FAX: 716-898-3536

*
*   For searches and help try:
*   http://www.stata.com/help.cgi?search
*   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   |   Site index