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
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
Or are you using pass-through SQL?
On Tue, Jun 23, 2009 at 4:53 PM, Abc Unha <email@example.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?