st: insheet and dropping cases

["Ben Hoen" <bhoen@lbl.gov>]

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/