Notice: On April 23, 2014, Statalist moved from an email list to a forum, based at statalist.org.
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: st: insheet problem (Stata 10.1)
From
Robert Picard <[email protected]>
To
[email protected]
Subject
Re: st: insheet problem (Stata 10.1)
Date
Wed, 30 Mar 2011 09:44:58 -0400
I think the problem is that a number of records include double quotes,
some with a single double quote (see line 30926 => | DR ANDREW ALPERT,
DMD "PERIODO| ). If I do a global replace of all double quotes with
nothing, then -insheet- reads the file correctly. I'm guessing that
what happens here is that -insheet- sees the unmatched double quote
and starts eating lines until it finds the next double quote. Not the
expected behavior so I think you should forward the problem to Stata
technical support.
Robert
On Wed, Mar 30, 2011 at 8:13 AM, scott hankins <[email protected]> wrote:
> Hello everyone
>
> I have an "issue" with insheet using Stata 10.1 that I hope someone
> can help me to diagnose.
>
> I have downloaded the file at this location
> (ftp://ftppub.doh.state.fl.us/ldo/data/licensee_profile.txt), it is a
> pipe ("|") delimited file.
>
> When I type
> - insheet using "licensee_profile.txt", delimiter("|") Stata tells me
> I have (42 vars, 97543 obs)
> the last variable (v42) is "empty"
>
> When I type
> - infix str var 1-1000 using "licensee_profile.txt" Stata tells me I
> have (145353 observations read) with the first observation being the
> variable names.
>
> If I open the file in a text editor (jedit), there are 145353 rows, so
> that matches infix results. I can open the file in Excel and re-save
> as a tab delimited file and then use -insheet without any problems
> (i.e. there are 145352 observations and 41 vars). Doing things this
> way "solves" my problem, but I would like to know what is giving Stata
> problems so I can deal with this in the future. How would I even go
> about diagnosing the problem?
>
> thank you
>
> Scott Hankins
> *
> * 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/
>
*
* 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/