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"
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!