Date: Thu, 27 Sep 2001 15:40:34 -0400
Reply-To: "Dorfman, Paul" <Paul.Dorfman@BCBSFL.COM>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: "Dorfman, Paul" <Paul.Dorfman@BCBSFL.COM>
Subject: Re: Speed of =: vs. SUBSTR()...
Content-Type: text/plain; charset=iso-8859-1
>You have already seen some good advice about the use of
>SUBSTR versus IN: in the DATA step, but nobody seems to
>have mentioned that the colon operator is not available
>in SQL.
Ian,
I did mention it explicitly in my reply - but what makes me write at the
moment is NOT "I did! I did! You failed to notice!". The thing is, I
subsequently received a reply to this particular point from a very highly
esteemed birdie both of us know well and learned that in fact, the latest
version of SAS SQL does have the counterpart of the colon modifier. In the
case of the equality, it would be the mneumonic EQT operator, with GET, LET,
etc. corresponding to other operators. How recent that version of SAS might
be, I am fuzzy about, for in 8.1 available to me on any machine, it does not
work, instead getting smart on me and telling that I probably meant EQ
isntead of EQT. But since I doubt that the birdie is pulling my leg, please
try it in 8.2 and see what happens.
Kind regards,
=====================
Paul M. Dorfman
Jacksonville, FL
=====================
Blue Cross Blue Shield of Florida, Inc., and its subsidiary and
affiliate companies are not responsible for errors or omissions in this e-mail message. Any personal comments made in this e-mail do not reflect the views of Blue Cross Blue Shield of Florida, Inc.
| 
