Date:         Thu, 10 Jan 2008 09:38:00 -0500
Reply-To:     "Fehd, Ronald J. (CDC/CCHIS/NCPHI)" <rjf2@CDC.GOV>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         "Fehd, Ronald J. (CDC/CCHIS/NCPHI)" <rjf2@CDC.GOV>
Subject:      Re: test character string for certain format
In-Reply-To:  <271feebd-4fe6-4f67-87a9-9600f531bb2c@j78g2000hsd.googlegroups.com>
Content-Type: text/plain; charset=us-ascii

> From: Takeadoe
> 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
> criteria?

Here is code I use to verify UserIds
of which mine is RJF2

/*iVerifyUserId.sas
description: verify UserId is in AAA0--ZZZ9
purpose    : use same code to check UserId
******* ................................ */
if     not verify(substr(UserId,1,3),'ABCDEFGHIJKLMNOPQRSTUVWXYZ')
   and not verify(substr(UserId,4,1),'0123456789')
   then output;

Ron Fehd  the macro maven  CDC Atlanta GA USA RJF2 at cdc dot gov