cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
vasasuser
‎10-30-2017
  • 4 Posts
  • 0 Likes Given
  • 0 Solutions
  • 0 Likes Received

Re: Match text strings in seperate datasets

by Calcite | Level 5 in SAS Programming
‎02-10-2017 04:22 PM
‎02-10-2017 04:22 PM
Thank you all for replies and good questions that inspire me to think more.   First, I believe this is a fuzzy string match that ignore cases, blanks, etc.   Second, I think it's better to produce result like this: Original text: "Harry met Sally at Walmart." Editted text: "edit_name met edit_name at edit_name." since there are cases when company names show up in person names.   The basic idea is to remove any people name, organization/company name, and ideally, location (street names or suffix/abbreation) from a sample text file. I built up a dictionary myself by compiling an excel file of company names and people names from census and other online sources, and then set up a sample text dataset with 10 records, 5 of which carry names and locations, 5 of which don't. I'd like to match the sample text dataset with my dictionaries and then replace them with "edit_name".   Any help on that? Thanks!         ... View more

Match text strings in seperate datasets

by Calcite | Level 5 in SAS Programming
‎02-10-2017 03:04 PM
‎02-10-2017 03:04 PM
I have a dataset with a list of organization, company names (dataset A) such as walmart, AT & T, Children's Place, Target, a dataset with popular people names (dataset B), and a dataset consisting of text like "Harry met Sally at Walmart." (dataset C)   How can I match text string "Walmart" from dataset C with company name in dataset A and replace it with "comp_name"? I'd also like to match and replace "Harry" and "Sally" from dataset C with "people_name".   Thanks! ... View more

Find and replace sensitive information in a text

by Calcite | Level 5 in SAS Programming
‎02-08-2017 10:07 AM
‎02-08-2017 10:07 AM
How can I label sequences of words in a text which are the names of things, such as person and company names, or locations.    I'd like to start with a simple project----I have a list of fortune 1000 company names, a sample data set with texts such as "Acari had an accident outside Children's Place near central ave in May."   I want to tokenize the text first, match the tokens with the list of 1000 company names and find the name (Children't Place), then replace it with string "company name".    I also have a list of all American people names, a list of street suffix/abbreviation. And I'd like to replace all people name with "person name" and street name with '"street name".   Ideally I want to find and replace any sensitive information: people name, company name, location, date, time, etc. with non-sensitive text strings.    Any suggestion? Thanks! ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎10-30-2017 11:09 PM
Quick links