Date: Thu, 28 Oct 2010 13:41:43 -0400
Reply-To: Suzanne McCoy <Suzanne.McCoy@CATALINAMARKETING.COM>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: Suzanne McCoy <Suzanne.McCoy@CATALINAMARKETING.COM>
Subject: Re: rolling up counts in PROC FREQ based regex patterns
Content-Type: text/plain; charset="us-ascii"
This is where DataFlux comes to the rescue if you have it in your software bundle.
From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of White, Svend A.
Sent: Thursday, October 28, 2010 1:32 PM
Subject: rolling up counts in PROC FREQ based regex patterns
I'm running frequencies on addresses to identify the most common
patterns of invalid street addresses.
What I'm wondering is this: Is there a way to instruct PROC FREQ to roll
up counts based on regular expression patterns (e.g., combine the counts
for "Rural Route 1" and "Rural Route 10", using a Perl regex like "Rural