Date:         Tue, 23 Jun 2009 17:13:21 -0500
Reply-To:     Joe Matise <snoopy369@GMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Joe Matise <snoopy369@GMAIL.COM>
Subject:      Re: How to check first few digits from Numeric variable
Comments: To: Abc Unha <abcunha@yahoo.com>
In-Reply-To:  <200906232153.n5NHAYTD023796@malibu.cc.uga.edu>
Content-Type: text/plain; charset=ISO-8859-1

You should be able to use Paul's macro in the PROC SQL statement, but
honestly CAT should work also I think.  Do you have SAS 9.1 or higher?  If
not then CAT won't be available I think, and you'd have to use TRIM or
something else.  Otherwise, just adjust the "eq :" to "like '111%' " and it
should work.

Or are you using pass-through SQL?

-Joe

On Tue, Jun 23, 2009 at 4:53 PM, Abc Unha <abcunha@yahoo.com> wrote:

> Hi Mike, Thanks,
> I need to check this condition in Proc SQL. I am joining two existsing
> table and need to check first three digits in numeric variable.
> And cat function is not working in proc sql statement.
> Is there anyother quick solution like that?
>