| 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 |
|---|
|
| 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;
|
