Date:         Tue, 14 Dec 2004 12:47:37 -0500
Reply-To:     Lu Liu <Lu.Liu@TALBOTS.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Lu Liu <Lu.Liu@TALBOTS.COM>
Subject:      How to get substr of integer data type
Content-Type: text/plain; charset="iso-8859-1"

Hi,

I have an integer column and data is always 3 digits.  I want to get data from this field if the last two digits are 86, 87, 88 or 89.  I know I can use SUBSTR, INDEX if the data type is character, but what function can I use for numeric data type?  Or do I need to convert the value to character first?

Thank you very much for your help!
Lu