Date:         Tue, 28 Jan 2003 18:08:55 +0000
Reply-To:     David Stone <david_p_stone@HOTMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         David Stone <david_p_stone@HOTMAIL.COM>
Subject:      Help on Proc Import for an Excel 2000 file
Content-Type: text/plain; format=flowed

I have an excel file that has a column with text and numbers and I would
like it to be imported as text.
If the first row is a number, it appears that a numeric format is assumed,
if it's text, then text is assumed.
The problem is that in each case, the opposite format is not loaded intp the
sas dataset.

eg.
VALUE        DATASET VALUE
==========================
march 2003   march 2003
200303
Q3           Q3

VALUE        DATASET VALUE
==========================
200303       200303
march 2003
Q3
==========================

I have tried everything with the excel file by selecting the column and
making the format text, but that doesn't work. The only thing that does work
is making 200303 => '200303. However, whenever this file is edited, I can
see the user replacing '200303 with 200304 and forgetting the quote.

Any suggestions ?

_________________________________________________________________
MSN 8 helps eliminate e-mail viruses. Get 2 months FREE*.
http://join.msn.com/?page=features/virus