Date:         Wed, 23 Feb 2000 10:03:30 -0500
Reply-To:     Victor Kamensky <kamensky@AECOM.YU.EDU>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Victor Kamensky <kamensky@AECOM.YU.EDU>
Subject:      Re: Case-sensitivity in 6.12-PROBLEM SOLVED
Comments: To: SAS-L@UGA.CC.UGA.EDU
Content-Type: text/plain; charset="us-ascii"

Hi,SAS-L-ers!
Thanks to  Andre WIELKI,who was the only person answering.
Fortunately he was wrong.  Me too.
The problem has a simple solution:
load the following patch:
http://www.sas.com/techsup/download/pc/v6_excel97patch.zip
and everything works( it was suggested by SI tech support).
I completely forgot that on my second computer the
patch was already installed.  So, two version on
the same computer WAS NOT the reason.

Victor Kamensky
Programmer
Albert Einstein College of Medicine
At 08:48 AM 2/23/00 -0500, you wrote:
>
>X-Sender: wielki@mailhost.ined.fr
>X-Mailer: QUALCOMM Windows Eudora Pro Version 4.0.2
>Date: Tue, 22 Feb 2000 18:45:24 +0100
>To: Victor Kamensky <kamensky@aecom.yu.edu>
>From: "Andre Wielki" <wielki@ined.fr>
>Subject: Re: Case-sensitivity in 6.12??
>
>Victor,
>
>i agree about the bad quality of import of excel tables throught the wizard
>windows 6.12 ts050 = addon situation
>here in france
>in the case of variable name in lower case   even with french accentuation
>
>also in the case of multiple line in the first case lines
>
>also in the case of empty data cases in the beginning of a column
>after  the head with the future name of variable...
>if you have 6,7 or 10 empty cases then all your column will be empty
>
>and so on    probably a lot more
>
>my solution after 15 days of work    taking statransfer software
>inside which there is no problem
>
>
>At 12:38 22/02/00 -0500, you wrote:
>>Hi,SAS-L-ers!
>>I run PROC IMPORT on 6.12, WIN98,
>>with EXCEL 97 addition.
>>The EXCEL file has 1 variable:id, it-s name (id) typed in lower case
>>(and just 2 lines-one with the name and 1 with a value).
>>(see PROC CONTENTS output below).
>>But procedures and data step cannot recognize this
>>variable(see log below).
>>Everything works fine if I do one of the 2 things:
>>1) type the variable name(ID) in upper case in EXCEL file;
>>2) run the same program on another computer;
>>   The difference between the two computers is the following:
>>   a)on the first computer (where error occurs)
>>   version 8 is installed together with version 6.12
>>   b) on the second computer,where program runs fine,
>>      just version 6.12 is installed.
>>My assumption:
>>Looks like Version 8 is case-censitive some place,
>>it goes to a place in Windows and somehow affects
>>version 6.12.
>>Am I correct?
>>How can I fix the problem?
>>Victor Kamensky
>>Programmer
>>Albert Einstein College of Medicine
>>
>>
>>250  proc import out=TEST
>>251      datafile="c:\SASTEST\TEST.xls"
>>252        dbms=Excel97 replace
>>253        ;
>>NOTE: .TEST was successfully created.
>>NOTE: The PROCEDURE IMPORT used 0.05 seconds.
>>
>>254  run;
>>255  PROC CONTENTS DATA= TEST;RUN;
>>
>>255  PROC CONTENTS DATA= TEST;RUN;
>>#    Variable    Type    Len    Pos    Format    Informat    Label
>>--------------------------------------------------------------
>>1    id          Char      4      0    $4.       $200.
>>NOTE: The PROCEDURE CONTENTS used 0.0 seconds.
>>
>>
>>256  PROC FREQ DATA= TEST;TABLE ID;RUN;
>>ERROR: Variable ID not found.
>>
>>NOTE: The SAS System stopped processing this step because of errors.
>>NOTE: The PROCEDURE FREQ used 0.0 seconds.
>>
>
>___________
>WIELKI  Andre
>INED - Service Informatique
>133 Bd Davout,
>75 020 Paris  FRANCE
>Tel: 01 56 06 21 54
>
>