compare two names to find a match

[sasphd]

hello, 

I had a file that contain two names column. I want to find the perfect match. I want then to compare the column Fund_name with the column Fund_name_CRSP to find the most similar name for each secid. comme match by secid. 

secid	Fund_name	Inception_date	CRSP_FUNDNO	FIRST_OFFER_DT	FUND_NAME_CRSP
F000000DL0	Macquarie IPO China Concentrated Core A1	2007-03-08	31345	2007-03-08	Vanguard International Equity Index Funds: Vanguard FTSE All-World ex US Index Fund; Investor Shares
F000000DL0	Macquarie IPO China Concentrated Core A1	2007-03-08	49091	2007-03-08	Fidelity Rutland Square Trust II: Strategic Advisers Fidelity International Fund
F000000DL0	Macquarie IPO China Concentrated Core A1	2007-03-08	49091	2007-03-08	Fidelity Rutland Square Trust II: Strategic Advisers International II Fund
F000000DL0	Macquarie IPO China Concentrated Core A1	2007-03-08	49093	2007-03-08	Fidelity Rutland Square Trust II: Strategic Advisers US Opportunity II Fund
F000000JLW	WCM Hippocrates A USD	2005-11-25	16966	2005-11-25	Jennison Sector Funds, Inc: Jennison Health Sciences Fund; Class X Shares
F000000JLW	WCM Hippocrates A USD	2005-11-25	16966	2005-11-25	JennisonDryden Sector Funds: Jennison Health Sciences Fund; Class X Shares
F000000JLW	WCM Hippocrates A USD	2005-11-25	16966	2005-11-25	Prudential Sector Funds, Inc: Prudential Jennison Health Sciences Fund; Class X Shares
F000000JLW	WCM Hippocrates A USD	2005-11-25	16967	2005-11-25	Jennison Sector Funds, Inc: Jennison Health Sciences Fund; Class M Shares
F000000JLW	WCM Hippocrates A USD	2005-11-25	16967	2005-11-25	JennisonDryden Sector Funds: Jennison Health Sciences Fund; Class M Shares
F000000JLW	WCM Hippocrates A USD	2005-11-25	16967	2005-11-25	Prudential Sector Funds, Inc: Prudential Jennison Health Sciences Fund; Class M Shares
F000000JLW	WCM Hippocrates A USD	2005-11-25	16968	2005-11-25	Jennison Sector Funds, Inc: Jennison Health Sciences Fund; Class L Shares
F000000JLW	WCM Hippocrates A USD	2005-11-25	16968	2005-11-25	JennisonDryden Sector Funds: Jennison Health Sciences Fund; Class L Shares
F000000JLW	WCM Hippocrates A USD	2005-11-25	16968	2005-11-25	Prudential Sector Funds, Inc: Prudential Jennison Health Sciences Fund; Class L Shares
F000000KTA	Macquarie Asia New Stars A1	2007-12-05	36620	2007-12-05	Federated Equity Funds: Federated Kaufmann Large Cap Fund; Class A Shares
F000000KTA	Macquarie Asia New Stars A1	2007-12-05	36621	2007-12-05	Federated Equity Funds: Federated Kaufmann Large Cap Fund; Class C Shares
F000000KTA	Macquarie Asia New Stars A1	2007-12-05	36622	2007-12-05	Federated Equity Funds: Federated Kaufmann Large Cap Fund; Class K Shares
F000000KTA	Macquarie Asia New Stars A1	2007-12-05	36622	2007-12-05	Federated Equity Funds: Federated Kaufmann Large Cap Fund; Class R Shares
F000000KTA	Macquarie Asia New Stars A1	2007-12-05	36623	2007-12-05	Federated Equity Funds: Federated Kaufmann Large Cap Fund; Institutional Shares
F000000KTA	Macquarie Asia New Stars A1	2007-12-05	36938	2007-12-05	ING Funds Trust: ING Institutional Prime Money Market Fund; Class IS shares

[RichardDeVen]

Can you offer some guidance by ranking the best to worst matches for the four rows of F000000DL0?

[sasphd]

I have checked and there is no match in the sample I give. if there is no match I want that the output table that indicate no match will like this

secid	Fund_name	Inception_date	CRSP_FUNDNO	FIRST_OFFER_DT	FUND_NAME_CRSP
F000000DL0					.
F000000JLW					.

however this is an example where we find a match

secid	Fund_name	Inception_date	CRSP_FUNDNO	FIRST_OFFER_DT	FUND_NAME_CRSP
F000002KYY	JHancock Disciplined Value R4	2009-05-22	46807	2009-05-22	John Hancock Funds III: John Hancock Disciplined Value Fund; Class R3 Shares
F000002KYY	JHancock Disciplined Value R4	2009-05-22	46808	2009-05-22	John Hancock Funds III: John Hancock Disciplined Value Fund; Class R4 Shares
F000002KYY	JHancock Disciplined Value R4	2009-05-22	46809	2009-05-22	John Hancock Funds III: John Hancock Disciplined Value Fund; Class R5 Shares
F000002KYY	JHancock Disciplined Value R4	2009-05-22	46810	2009-05-22	John Hancock Funds III: International Core Fund; Class R3 Shares
F000002KYY	JHancock Disciplined Value R4	2009-05-22	46811	2009-05-22	John Hancock Funds III: International Core Fund; Class R4 Shares
F000002KYY	JHancock Disciplined Value R4	2009-05-22	46812	2009-05-22	John Hancock Funds III: International Core Fund; Class R5 Shares
F000002KYY	JHancock Disciplined Value R4	2009-05-22	46813	2009-05-22	John Hancock Investment Trust: John Hancock Fundamental Large Cap Core Fund; Class R1 Shares
F000002KYY	JHancock Disciplined Value R4	2009-05-22	46813	2009-05-22	John Hancock Investment Trust: John Hancock Large Cap Equity Fund; Class R1 Shares