[Limdep Nlogit List] Reading Excel data file without variable names

William Greene wgreene at stern.nyu.edu
Thu Aug 24 02:29:59 EST 2006

I know I'm missing something here - this sounds like pushing a square peg
into a round hole.  If the file is read without names, then how will you refer to
the variables when you operate the program?  The program can issue default
names X1, X2,... but do you really want this?  On the other hand, all it takes to
get around this is to read the Excel file into Excel, and add a row of names to
it.  (Phil has it right, by the way, the program does expect the row of names in
all cases.)
/Bill Greene

Professor William Greene
Department of Economics
Stern School of Business
New York University
44 West 4th St., Rm. 7-78
New York, NY   10012
Ph. 212.998.0876
Fax. 212.995.4218
URL. http://www.stern.nyu.edu/~wgreene
Email. wgreene at stern.nyu.edu

----- Original Message -----
From: "Philip A. Viton" <viton.1 at osu.edu>
Date: Wednesday, August 23, 2006 11:23 am
Subject: Re: [Limdep Nlogit List] Reading Excel data file without	variable names

> From the online help (under READ):
> "But, worksheet files must be read with ;NAMES (no list is needed) 
> in 
> the command."
> So reading-without-names apparently isn't possible. You could 
> always 
> dump the excel data to an ascii file and read it in that way: in 
> which case names are automatically assigned.
> At 12:47 PM 8/23/2006, you wrote:
> >Dear fellow limdep users
> >
> >How can I read an Excel data file without variable names. I tried 
> >with and without the ;names= option and came down with the error 
> message:>
> >     ;file=e:\agec524\students\datasets\excel\wage1.xls
> >     ;format=xls $
> >Error:   278: WKx/DIF/XLS.Numeric data found where var name was 
> expected.>
> >Please help. Thanks.
> >_______________________________________________
> >Limdep site list
> >Limdep at limdep.itls.usyd.edu.au
> >http://limdep.itls.usyd.edu.au
> ------------------------
> Philip A. Viton
> City Planning, Ohio State University
> 275 West Woodruff Avenue, Columbus OH 43210
> viton.1 at osu.edu
> _______________________________________________
> Limdep site list
> Limdep at limdep.itls.usyd.edu.au
> http://limdep.itls.usyd.edu.au

More information about the Limdep mailing list