insheet.hlp

是一个经济学管理应用软件 很难找的 但是经济学学生又必须用到

{smcl}
{* 22feb2005}{...}
{cmd:help insheet}{right:dialog:  {bf:{dialog insheet}}}
{hline}

{title:Title}

{p2colset 5 20 22 2}{...}
{p2col :{hi:[D] insheet} {hline 2}}Read ASCII (text) data created by a
spreadsheet{p_end}
{p2colreset}{...}


{title:Syntax}

{p 8 16 2}
{cmd:insheet}
[{varlist}]
{helpb using}
{it:filename}
[{cmd:,} {it:options}]

{synoptset 21 tabbed}{...}
{synopthdr}
{synoptline}
{synopt :[{cmdab:no:}]{opt d:ouble}}override default storage type{p_end}
{synopt :{opt t:ab}}values are tab-separated{p_end}
{synopt :{opt c:omma}}values are comma-separated{p_end}
{synopt :{cmdab:delim:iter("}{it:char}{cmd:")}}specify other separation
characters{p_end}
{synopt :{opt clear}}replace data in memory{p_end}

{p2coldent :+ [{cmd:{ul:no}}]{opt n:ames}}variable names are included on
the first line of the file{p_end}
{synoptline}
{p2colreset}{...}
{p 4 6 2}+ [{opt no}]{opt names} is not shown in the dialog box{p_end}
{p 4 4 2}
If {it:filename} is specified without an extension, {cmd:.raw} is assumed.
{p_end}
{p 4 6 2}
Note that if your {it:filename} contains embedded spaces, remember to enclose
it in double quotes.{p_end}


{title:Description}

{pstd}
{opt insheet} reads into memory from a disk a dataset that is not in Stata
format.  {opt insheet} is intended for reading files created by a spreadsheet
or database program.  Regardless of the creator of the file, {opt insheet}
reads text (ASCII) files in which there is one observation per line and the
values are separated by tabs or commas.  In addition, the first line of the
file can contain the variable names.  If you type

{phang2}{cmd:. insheet using} {it:filename}

{pstd}
{opt insheet} reads your data; that's all there is to it.

{pstd}
Stata has other commands for reading data.  If you are not sure that
{opt insheet} will do what you are looking for, see
{help infiling} and {bind:{bf:[U] 21 Inputting data}}.  If you
want to save your data in "spreadsheet-style" format, see {helpb outsheet}. 


{title:Options}

{phang}
[{opt no}]{opt double} affects the way Stata handles the storage
    of floating point variables.  If the default storage type (see
    {helpb generate}) is set to {opt float}, specifying the
    {opt double} option forces Stata to store floating point variables as
    {opt double}s rather than {opt float}s.  If the default storage type has
    been set to {opt double}, you must specify {opt nodouble} to have floating
    point variables stored as {opt float}s rather than {opt double}s; see
    {help data types}.

{phang}
{opt tab} tells Stata that the values are tab-separated.
    Specifying this option will
    speed {opt insheet}'s processing, assuming that you are right.
    {opt insheet} can determine for itself whether the separation character is
    a tab or a comma.

{phang}
{opt comma} tells Stata that the values are comma-separated.
    Specifying this option will
    speed {opt insheet}'s processing, assuming that you are right.
    {opt insheet} can determine for itself whether the separation character is
    a comma or a tab.

{phang}
{cmd:delimiter("}{it:char}{cmd:")} allows you to specify other separation
    characters.  For instance, if values in the file are separated by
    a semicolon, specify {cmd:delimiter(";")}.

{phang}
{opt clear} specifies that it is okay for the new data to replace the data that
    are currently in memory.  To ensure that you do not lose something
    important, {opt insheet} will refuse to read new data if data are
    already in memory.  {opt clear} allows {opt insheet} to replace the data
    in memory.  You can also drop the data yourself by typing {cmd:drop _all}
    before reading new data.

{pstd}
The following option is available with {opt insheet} but is not shown in
the dialog box: 

{phang}
[{opt no}]{opt names} informs Stata whether or not variable names
    are included on the first line of the file.  Specifying this option will
    speed {opt insheet}'s processing, assuming that you are right.
    {opt insheet} can determine for itself whether the file
    includes variable names.


{title:Examples}

{phang}{cmd:. insheet using auto.raw}{p_end}

{phang}{cmd:. insheet using auto.raw, clear}{p_end}

{phang}{cmd:. insheet using auto.raw, clear double}{p_end}


{title:Also see}

{psee}
Manual:  {bf:[D] insheet}

{psee}
Online:  {help infile1},
{helpb outfile},
{helpb outsheet},
{helpb rename},
{helpb save}
{p_end}