Date:         Tue, 7 Sep 2004 06:06:32 -0700
Reply-To:     Daniel Reyes <junkdalejreyes@YAHOO.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Daniel Reyes <junkdalejreyes@YAHOO.COM>
Subject:      Data mining help
Content-Type: text/plain; charset=us-ascii

I have a dataset ("FILE1") with values in field WSID
which have certain consturcts which I am trying to
tease out.

For all records which have WSID values which consist
of numeric digits OR blanks should go to file "STD."
(EX: "1" "2" "3" "54")

For all records which have WSID values which consist
of two or more alpha characters in a row should go to
file "NONSTD."
(EX: "AP" "BSMT" "SUPE" "FIRST" "ATTC" "1FG")

For all records which have WSID values that have a
numeric digit in character position 1 followed by an
"F" and any other alpha character should go to file
"NONSTD.
(EX: "1FL" "2FR" "2FL" "5FRONT")


For all records which have WSID values that have a
numeric digit in character position 1 followed by
alpha characters "ST" should go to file "NONSTD.
(EX: "1ST" "2ST" "7ST")

For all records which have WSID values that have a
numeric digit in character position 1 followed by one
alpha character and nothing else should go to file
"STD."
(EX: "1F" "2C" "8T" "5E" "6G")

All else should go to file "STD."

Hope someone can help me out.

Dan




__________________________________
Do you Yahoo!?
Yahoo! Mail - You care about security. So do we.
http://promotions.yahoo.com/new_mail