Re: st: insheet and dropping cases

[Ronnie Babigumira <rb.glists@gmail.com>]

Ben,

Not an answer to your question but just to point out that starting
with Stata 13, -insheet- has been superseded by -import delimited-.
Have you tried it? (you do not say which version of Stata you are
using)

Ronnie



On Thu, Feb 20, 2014 at 4:08 AM, Ben Hoen <bhoen@lbl.gov> wrote:
> Hi all,
>
> I am not able to figure out why insheet is not importing all of the cases of
> a .txt I am trying to read into memory.
>
> For example if I use insheet
>
> .  insheet using "B:\OtherDatabase\pvp3\IL.txt", delim("|") clear names
>
> It shows 200 vars, and 184 cases
>
> If, alternatively I use stat transfer, it transfers the same 200 variables
> but for 363 cases.
>
> I have 70 files to import and insheet (via a loop with append) is the
> simpliest so I would like to use it but cannot figure out why it is not
> importing all of the cases.  It does the same thing for all states, always
> importing less than what are transferred via stattransfer, regardless of the
> total file size or number of cases..
>
> Any ideas?  Thanks, in advance,
>
> Ben
>
> Ben Hoen
> Staff Research Associate
> Lawrence Berkeley National Laboratory
> Office: 845-758-1896
> Cell: 718-812-7589
> bhoen@lbl.gov
> http://emp.lbl.gov/staff/ben-hoen
>
> Visit our publications at:
> http://emp.lbl.gov/reports/re
>
> Sign up for our email list to receive publication notifications at:
> https://spreadsheets.google.com/a/lbl.gov/spreadsheet/viewform?formkey=dGlFS
> 1U1NFlUNzQ1TlBHSzY2VGZuN1E6MQ
>
>
>
>
>
>
> *
> *   For searches and help try:
> *   http://www.stata.com/help.cgi?search
> *   http://www.stata.com/support/faqs/resources/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/faqs/resources/statalist-faq/
*   http://www.ats.ucla.edu/stat/stata/