st: insheet problem (Stata 10.1)

[scott hankins <scott.hankins@gmail.com>]

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/