|
Can you use dbms=xls ?
If you can, I think that it will accept a Guessingrows=
statement.
Otherwise, you have to set guessingrows in the Windows registry.
Art
---------On Mon, 15 Aug 2011 11:18:38 -0700, df ss <tggsun@YAHOO.COM> wrote:
>Hello SASor,
>We have data was save in Excel looks like this:
>
>
>
>
>
>
>ID
>var1
>
>001
>11
>
>002
>14
>
>003
>�
>
>004
>13
>
>005
>15
>
>006
>11
>
>007
>12
>
>008
>10
>
>009
>12
>
>010
>a
>
>011
>b
>
>012
>c
>
>013
>13
>
>014
>11
>
>015
>d
>�
>I ran the following code:
>PROC IMPORT OUT= WORK.try
>����������� DATAFILE= "C:\try.xls"
>����������� DBMS=EXCEL REPLACE;
>���� RANGE="try$";
>���� GETNAMES=YES;
>���� MIXED=YES;
>���� SCANTEXT=YES;
>���� USEDATE=YES;
>���� SCANTIME=YES;
>RUN;
>�
>I hope the var1 should be�set as character format. But it seems the
MIXED=YES; doesn't work. I'm using SAS 9.2 TS Level 2MO on�Window XP. I
don't know if SAS provide a hot fix for this. Or I have to save the data as
text format then load it into SAS.
>Thanks,
>�
>DD SF
| 
