Date: Thu, 27 Sep 2001 13:57:49 -0600
Reply-To: Jack Hamilton <JackHamilton@FIRSTHEALTH.COM>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: Jack Hamilton <JackHamilton@FIRSTHEALTH.COM>
Subject: Re: Speed of =: vs. SUBSTR()...
Content-Type: text/plain; charset=us-ascii
Yes, it works in 8.2. I was going to send SAS-L a note about it, but
1) You beat me to it, and
2) There's no equivalent to "in:", or if there is it's not documented (and it's not INT).
--
JackHamilton@FirstHealth.com
Development Manager, Technical Group
METRICS Department, First Health
West Sacramento, California USA
>>> "Dorfman, Paul" <Paul.Dorfman@BCBSFL.COM> 09/27/2001 12:40 PM >>>
>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.
| 
