E Scrub Dirty Data

E-Scrub - Cleanse Your Data

Having problems taking data from your production transaction or customer client file(s) to produce mailing labels or to include in a Word document for addressing to your clients/customers?

Or, maybe you would like to clean your data file(s) so similiar phrases are standardized/normalized.

We have developed a series of SAS modules/macros to "scrub/clean" your data so it can be used to produced "good" mailing labels and/or standardize/normalize your critical client file(s).

For Example:

For cost estimate or consultation contact:

Charles Patridge
PDPC, Ltd.
172 Monce Road
Burlington, CT 06013 USA
Phone: 860-673-9278 or 860-675-9026
Preferred method of communications is Email:
Web: www.sconsig.com

For some additional data scrubbing tools, services and/or products - see below

US Postal Services Zip Code Products and Pricing

USPS Address Standards

USPS Products, Services and Publications

Need to Look Up a Zip Code or Address ??? - Click Here

http://ftp.census.gov/geo/www/gazetteer/places.html
U.S. Census Bureau Gazetteer Place and Zipcode Files

November 1997 Recommended Official U.S. Postal Service Standard

  • Street Suffix Abbreviations - for $10.00 you can receive these 505 abbreviations in both a CSV and EXCEL spreadsheet format.
  • Business Word Abbreviations - for $25.00 you can receive these 5616 abbreviations in both a CSV and Excel spreadsheet format.
  • Both Street and Business Word Abbreviations - for $30

See below for a sample of each of these files.

Email: in order to get these files.

However, you will be required to first make a payment by check. Please make your check payable and forward to:

Charles Patridge
Business and Street Abbreviations
172 Monce Road
Burlington, CT 06013 USA

Phone: 860-673-9278

Please be sure to fill out this form and include it with your check so I can forward you these files to your email address.

November 1997 U.S. Postal Service Standard:

_____ $10.00 for Street Suffix Abbreviations only (505 records)
_____ $25.00 for Business Word Abbreviations only (5616 records)
_____ $30.00 for Both

 Name: ______________________________________
Phone: _____________________________________
Email: _____________________________________
A sample of the files:
November 1997 Recommended Official Postal Service
Standard Street Suffix Abbreviations
Primary Street
Suffix Name		 Commonly Used Street
Suffix or Abbreviation		 Postal Service Standard
Suffix Abbreviation
ALLEY ALLEE ALY
ALLEY ALLEY ALY
ALLEY ALLY ALY
ALLEY ALY ALY
ANNEX ANEX ANX
ANNEX ANNEX ANX
ANNEX ANNX ANX
ANNEX ANX ANX
ARCADE ARC ARC
ARCADE ARCADE ARC
AVENUE AV AVE
AVENUE AVE AVE
AVENUE AVEN AVE
AVENUE AVENU AVE
AVENUE AVENUE AVE
AVENUE AVN AVE
AVENUE AVNUE AVE
November 1997 Postal Service Standard
Business Word Abbreviations
Common
Presentation		 Postal
Service
Standard
ABACUS ABCS
ABCS ABCS
ABOVE ABV
ABV ABV
ABRASIVE ABR
ABR ABR
ABRSV ABR
ABROAD ABRD
ABRD ABRD
ABSOLUTE ABSLT
ABSLT ABSLT
ABSTRACT ABSTRCT
ABSTRCT ABSTRCT
ACADEMIC ACDMC
ACDMC ACDMC
ACADEMY ACDMY
ACAD ACDMY
ACDMY ACDMY
ACADEM ACDMY

November 1997 Recommended Official Postal Service
Standard Secondary Unit Designators Abbreviations
Description Approved Abbreviation
APARTMENT APT
BASEMENT BSMT
BUILDING BLDG
DEPARTMENT DEPT
FLOOR FL
FRONT FRNT
HANGER HNGR
KEY KEY
LOBBY LBBY
LOT LOT
LOWER LOWR
OFFICE OFC
PENTHOUSE PH
PIER PIER
REAR REAR
ROOM RM
SIDE SIDE
SLIP SLIP
SPACE SPC
STOP STOP
SUITE STE
TRAILER TRLR
UNIT UNIT
UPPER UPPR
November 1997 Two-Letter State
and Possession Abbreviations
State/Possession Abbreviation
Alabama AL
Alaska AK
American Samoa As
Arizona AZ
Arkansas AR
California CA
Colorado CO
Connecticut CT
Delaware DE
District of Columbia DC
Federated State of Miconesia FM
Florida FL
Georgia GA
Guam GU
Hawaii HI
Idaho ID
Illinois IL
Indiana IN
Iowa IA
Kansas KS
Kentucky KY
Louisiana LA
Maine ME
Marshall Islands MH
Maryland MD
Massachusetts MA
Michigan MI
Minnesota MN
Mississippi MS
Missouri MO
Montana MT
Nebraska NE
Nevada NV
New Hampshire NH
New Jersey NJ
New York NY
North Carolina NC
North Dakota ND
Northern Mariana Islands MP
Ohio OH
Oklahoma OK
Oregon OR
Palau PW
Pennsylvania PA
Puerto Rico PR
Rhode Island RI
South Carolina SC
South Dakota SD
Tennessee TN
Texas TX
Utah UT
Vermont VT
Virgin Islands VI
Virginia VA
Washington WA
West Virginia WV
Wisconsin WI
Wyoming WY
Armed Forces Europe,
the Middle East,
and Canada		 AE
Armed Forces Pacific AP
Armed Forces Americas
(except Canada)		 AA
November 1997 Geographic Directional
Geographic Directional Abbreviation
North N
East E
South S
West W
Northeast NE
Southeast SE
Northwest NW
Southwest SW

Last Updated on 04/06/2000
By Charles Patridge
Email:
Visitor #