Date:         Thu, 29 Oct 1998 08:33:36 -0700
Reply-To:     "Jeff J. Voeller" <atrocity@MY-DEJANEWS.COM>
Sender:       "SAS(r) Discussion" <SAS-L@UGA.CC.UGA.EDU>
From:         "Jeff J. Voeller" <atrocity@MY-DEJANEWS.COM>
Organization: Deja News Mail  (http://www.my-dejanews.com:80)
Subject:      Re: Problem with character in Sybase variable(column) name.
Comments: To: wawork@HOTMAIL.COM
Content-Type: text/plain; charset=us-ascii

On Wed, 28 Oct 1998 23:18:37   wawork wrote:
 
>Since there are two sybase variables with spp_id#_ as the first 8 characters,
>one of them must be renamed.  I tried using single and double quotes but SAS
>didn't like that either.
 
I'm not familiar with Sybase, but I wonder if:
 
1. Can you just let SAS do the renaming and live with the possibly less-than-optimal results?
 
2. This works with DB2 under MVS:
 
proc sql;
  connect to db2;
  create view work.testview as
  select * from connection to db2
  (select long_db2_var_name as "sasvar");
  disconnect from db2;
quit;
 
Everything within the parentheses is evaluated by DB2 rather than SAS--SAS never even "sees" it.  SAS only knows about the renamed variable, not the original.  I don't know if Sybase will allow the same thing or if using SQL rather than PROC ACCESS is practical for your application, though.
 
 
-----== Sent via Deja News, The Discussion Network ==-----
http://www.dejanews.com/  Easy access to 50,000+ discussion forums