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
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
Thank you. That is helpful.
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!Need to connect to databases in SAS Viya? SAS’ David Ghan shows you two methods – via SAS/ACCESS LIBNAME and SAS Data Connector SASLIBS – in this video.
Find more tutorials on the SAS Users YouTube channel.