Bookmark and Share

Notice: On April 23, 2014, Statalist moved from an email list to a forum, based at

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

Re: st: RE : st: Insheet Issue

From   "Michael N. Mitchell" <>
Subject   Re: st: RE : st: Insheet Issue
Date   Sat, 11 Sep 2010 12:51:39 -0700

Dear Antonio

I would suggest checking out the -hexdump- and -filefilter- commands within Stata. The -hexdump- command, with the -analyze- option will give you a kind of frequency distribution of all of the different characters in your file. This will allow you to identify any nasty bits in your file (i.e., non-ASCII characters).

You can then use the -filefilter- command to convert those nasty characters into something more innocuous (that would not bother -insheet-).

This solution takes a little time and patience, but I think it will get you to where you want to go.

Best luck!

Michael N. Mitchell
Data Management Using Stata      -
A Visual Guide to Stata Graphics -
Stata tidbit of the week         -

On 2010-09-11 12.42 PM, Vezzani, Antonio (EST) wrote:
I checked the file: in the last row uploaded there is an arrow in a cell
string, I've tried to delete it but still doesn't work, and the null cells
are already empty...any other suggestion?

-------- Message d'origine--------
De: de la part de Ronan Conroy
Date:	sam. 11/09/2010 18:35
Objet:	Re: st: Insheet Issue

On 10 MFómh 2010, at 21:46, Jeph Herrin wrote:

Perhaps an embedded | or<carriage return>; or an empty
row. Have you tried inspecting line 164,502 of the ASCII file?

Another nightmare character is the 'Null' character.

Try opening your data in a text editor and giving a 'convert to ASCII'

If you don't have a text editor that does this, you might look at the
text editor FAQ and get one as a priority. Very useful for data

Ronán Conroy
Associate Professor
Division of Population Health Sciences
Royal College of Surgeons in Ireland
Epidemiology Department,
Beaux Lane House, Dublin 2, Ireland
+353 (0)1 402 2431
+353 (0)87 799 97 95
+353 (0)1 402 2764 (Fax - remember them?)

P    Before printing, think about the environment

*   For searches and help try:

*   For searches and help try:
*   For searches and help try:

© Copyright 1996–2018 StataCorp LLC   |   Terms of use   |   Privacy   |   Contact us   |   Site index