Hello -
On Dataflux DMS 2.7 I am trying to run Standardization -> U.S. Address Verification within a single Data Job. Single Input and Output from and to flat files(.xlsx Input, .csv Output). In the output file I noticed that a number of rows were offset one column to the right. Upon investigation, these rows appeared to have failed Standardization, but I'm not sure why.
A few example data below:
1320 N BROADWAY - Suite #3
1320 N BROADWAY #1
2211 11TH AVE APT #B
2211 11TH AVE APT #A
I'm not sure if it's failing because of the # sign? I understand it is a reserved character for regex. If that is the problem, how do I fix it? If not, whats's happening and how do I fix that? Thank you much!
Hi,
Can you provide some more details?
If you are using the "Standardization" node, you can use the QKB customization editor (Find it under Administration > Quality Knowledge Bases > QKB CI) to open the standardization definition and see the transformations used against some sample input you provide. If it is indeed a regex problem, you can use the Regex Library Editor to make modification to regex libraries used in the QKB standardization definition.
Ron
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.