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 |
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 |
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.