| Date: | Tue, 31 Mar 2009 05:03:38 -0400 |
|---|
| Reply-To: | Ben Powell <ben.powell@CLA.CO.UK> |
|---|
| Sender: | "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU> |
|---|
| From: | Ben Powell <ben.powell@CLA.CO.UK> |
|---|
| Subject: | Re: regular expression |
|---|
Substring alternative:
data have;
infile datalines dlm=':';
informat old $64. ;
input old $ ;
length new $64 ;
* Rule: 4 letters, optional '-', 5 digits;
new = prxchange( 's/(\d\d)(\D)/($1)$2/', -1, old );
new2 = substr(old,1,5)||"("||substr(old,6,2)||")";
datalines;
2053904
2442406
2607614
;
run;
|
