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.
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:
connect to db2;
create view work.testview as
select * from connection to db2
(select long_db2_var_name as "sasvar");
disconnect from db2;
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