Date:         Tue, 22 Feb 2000 12:38:11 -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:      Case-sensitivity in 6.12??
Comments: To: SAS-L@UGA.CC.UGA.EDU
Content-Type: text/plain; charset="us-ascii"

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.