About DaveLarge

DaveLarge · ‎05-05-2020

hi all, im sure i done this in the past but can think for the life of me how i did this so i have 2 datasets where A=robust name and adresses B= contains a field that would have the name in example - a= Name Long Lat Midgar 34 64 B = possible name Details_1 Detail_2 75 MidGAR street need this And and this i need to join the tables where B.possible_name has A.Name in any format and any space within the field i think i used wildcard fuzzy matching but unable to replicate this so far any help would be great thank you in advance

DaveLarge · ‎04-13-2018

this is perfect thank you I also have to do the same with 8 digits that are already format as Char so exactly the same I want to take out the all the results where the 7th number from right is 8 ? can you help there thanks for your help on this its really helped out

DaveLarge · ‎04-13-2018

Hi, Thanks for the reply The field only holds 10 digits at most im looking to take out any results where the second digit in is 8 as below – it’s a numeric field so if the 9th number from the right is a 8 I want to delete it from the dataset test data below as is number amount count 7814544659 1000 5 1289456984 15000 2 488888 500 7 9856456444 538 7 4548884546 5786 9 4564564445 4226 10 want number amount count 1289456984 15000 2 488888 500 7 4548884546 5786 9 4564564445 4226 10

DaveLarge · ‎04-13-2018

Hi, Thanks for the reply The field only holds 10 digits at most im looking to take out any results where the second digit in is 8 as below – it’s a numeric field so if the 9th number from the right is a 8 I want to delete it from the dataset test data below as is number amout count 7814544659 1000 5 1289456984 15000 2 488888 500 7 9856456444 538 7 4548884546 5786 9 4564564445 4226 10 want number amout count 1289456984 15000 2 488888 500 7 4548884546 5786 9 4564564445 4226 10

DaveLarge · ‎04-12-2018

Hi all, been asked a new way of filtering out numbers from a dataset and i'm struggling to find the correct way to do this the ask is I have a field within a dataset with 10 numbers in that field EXP (1234567890) we know when the second number is 8 EXP (1823456790) we don't want this in the dataset and wish to remove it anyone got an idea ? thank you in advance

Online Status	Offline
Date Last Visited	‎01-06-2023 12:39 PM

joining 2 datasets fuzzy matching

Re: Using a where clause to filter out numbers within a dataset

Re: Using a where clause to filter out numbers within a dataset

Re: Using a where clause to filter out numbers within a dataset

Using a where clause to filter out numbers within a dataset

joining 2 datasets fuzzy matching

Re: Using a where clause to filter out numbers within a dataset

Re: Using a where clause to filter out numbers within a dataset

Re: Using a where clause to filter out numbers within a dataset

Using a where clause to filter out numbers within a dataset

SAS Inner Circle Panel