topic dfPower Studio 8.2 address scrubbing question in SAS Data Management

dfPower Studio 8.2 address scrubbing question

ldpinkert — Wed, 06 Aug 2014 15:07:45 GMT

We are on the dfPowerStudio 8.2 version, but will soon be upgrading to Data Management Studio.

When we input a 2-line address into the Address Verification (US/Canada) node, the result from the address verification node is concatenating the input address line 2 to the first line of the address. We would like to be able to still have these lines separate after scrubbing. Is there a way to continue to keep these 2 lines separate after being scrubbed?

Ex: Input Address Line 1: 317 S Main St

Input Address Line 2: Apt 26

Input City - State: Milbank, SD

Input Zip: 57252

Result from Address Verification Node:

Address Line 1: 317 S Main St Apt 26

Address Line 2:

City: Milbank

State: SD

US_Zip: 57252

Re: dfPower Studio 8.2 address scrubbing question

skillman — Wed, 06 Aug 2014 16:44:13 GMT

ldpinkert,

Try using the Parsing node using the Address Definition for the Address Line 1 field. Output all available tokens then use an expression to concatenate the parsed tokens into Address Line 1 or Address Line 2:

/* Pre Expression */

string addr_1_update

string addr_2_update

addr_1_update = ''

addr_2_update = ''

/* Expression */

addr_1_update = `Street Number` & ' ' & `Pre-direction` & ' ' & `Street Name` & ' ' & `Street Type` & ' ' & `Post-direction`

addr_2_update = `Address Extension` & ' ' & `Address Extension Number`

-shawn

Re: dfPower Studio 8.2 address scrubbing question

ldpinkert — Wed, 06 Aug 2014 18:33:16 GMT

Thank you. That is helpful.