Date:         Wed, 29 Mar 2006 12:37:52 -0800
Reply-To:     "Mogens A. Krogh" <MKROGH@DSR.KVL.DK>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         "Mogens A. Krogh" <MKROGH@DSR.KVL.DK>
Organization: http://groups.google.com
Subject:      Re: from excel to sas, character variables
Comments: To: sas-l@uga.edu
Content-Type: text/plain; charset="iso-8859-1"

Try to change the mixed-option from 'NO' to 'YES' like in this example:

Regards,
Mogens A. Krogh
DVM, PhD-student
www.kvl.dk


PROC IMPORT OUT= WORK.TEST
            DATAFILE= "P:\Filer\test.xls"
            DBMS=EXCEL REPLACE;
     SHEET="Ark1$";
     GETNAMES=YES;
     MIXED=YES;            <-----Change here!!!
     SCANTEXT=YES;
     USEDATE=YES;
     SCANTIME=YES;
RUN;