Date:         Fri, 11 Jun 2004 18:40:38 +0100
Reply-To:     "Ravikumar. J" <ravi_pune@YAHOO.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
Comments:     To: Ed Heaton <EdHeaton@WESTAT.COM>
From:         "Ravikumar. J" <ravi_pune@YAHOO.COM>
Subject:      Re: in SQL
Comments: To: SAS-L@LISTSERV.VT.EDU
In-Reply-To:  <446DDE75CFC7E1438061462F85557B0F03D8798F@remail2.westat.com>
Content-Type: text/plain; charset=iso-8859-1

Yes.  Using colon in Proc SQL doesnt work.  Instead you could
probably use and SQL like this ...

Proc sql ;
    Select string from test where (string like "t%") ;
Quit ;

Cheers
Ravi




 --- Ed Heaton <EdHeaton@WESTAT.COM> wrote: > /* Mark, given the
following data set... */
> Data test ;
>     Input string $ ;
> Cards4 ;
> one
> two
> three
> four
> five
> six
> seven
> eight
> nine
> ten
> ;;;;
> Proc sql ;
>  /* This SELECT statement using EQ: does not work. */
>     Select string from test where ( string eq: "t" ) ;
>  /* But neither does the one using =:. */
>     Select string from test where ( string =: "t" ) ;
> Quit ;
> Data new ;
>     Set test ;
>  /* However, EQ: does seem to work in a DATA step. */
>     Where ( string eq: "t" ) ;
> Run ;
>
> /*
> Ed
>
> Edward Heaton, SAS Senior Systems Analyst,
> Westat (An Employee-Owned Research Corporation),
> 1600 Research Boulevard, RW-3541, Rockville, MD 20850-3195
> Voice: (301) 610-4818                  Fax: (301) 610-5128
> mailto:EdHeaton@Westat.com             http://www.Westat.com
> */
>
> -----Original Message-----
> From: Terjeson, Mark [mailto:TERJEM@DSHS.WA.GOV]
> Sent: Thursday, June 10, 2004 7:05 PM
> To: SAS-L@LISTSERV.UGA.EDU
> Subject: =: in SQL
>
>
> Did I see recently somewhere the letter operators
> for SQL for the equivalent of   =:  i.e. the colon
> modifier capability in SQL as EQN or something?
>
>
> Mark

________________________________________________________________________
Yahoo! India Matrimony: Find your partner online. http://yahoo.shaadi.com/india-matrimony/