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

Re: st: insheet command

From   Neil Shephard <>
Subject   Re: st: insheet command
Date   Wed, 8 Jul 2009 14:26:00 +0100

On Wed, Jul 8, 2009 at 2:17 PM, <> wrote:
> Hello,
> I have a problem with the insheet command. I write: "insheet using
> myfile.txt". I have actually two files: the command  works well with the
> first one, but  by launchig the command with my second file, Stata
> answers: "cannot determine separator--use tab or comma option". Could you
> give me an idea where the problem comes from?

What does your data in the second file look like?

What character is used to delimit columns?  If its a comma then
explicitly specify the the -, comma- option to the end of your

insheet using myfile2.txt, comma

If its something else such as a pipe (i.e. "|") then use the -,
delim("|")- option...

insheet using myfile2.txt, delimc("|")

Both of these are documented in the help page for -insheet- which you
can read on-line in Stata by typing...

man insheet

... and the options are explained within this page.

If neither of those work then you will have to provide and example of
your data for people to help you further.


"The combination of some data and an aching desire for an answer does
not ensure that a reasonable answer can be extracted from a given body
of data." ~ John Tukey (1986), "Sunset salvo". The American
Statistician 40(1).

Email -
Website -
Photos -

*   For searches and help try:

© Copyright 1996–2017 StataCorp LLC   |   Terms of use   |   Privacy   |   Contact us   |   What's new   |   Site index