Date: Thu, 10 Jan 2008 09:58:38 -0500
Reply-To: Muthia Kachirayan <muthia.kachirayan@GMAIL.COM>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: Muthia Kachirayan <muthia.kachirayan@GMAIL.COM>
Subject: Re: test character string for certain format
Content-Type: text/plain; charset=ISO-8859-1
You can use
ANYDIGIT() and NOTDIGIT() functions.
On Jan 10, 2008 9:00 AM, Takeadoe <firstname.lastname@example.org> wrote:
> Good morning,
> I've got a field that is supposed to contain Ohio driver's licenses.
> All Ohio DL are of the following format AANNNNNN - two letters
> followed by 6 numbers. This field contains values such as 0, 00T8,
> and of course valid DLs such as RK678901. Can some one help me figure
> out how to classify each record as valid or invalid based on these
> Thank you very much!