I have two datasets which I would like to join by name. Unfortunately the string name is the only identifier they have in common. What would be the most efficient way to join them as exactly as possible? Here is a sample data, I have 140,000 and 26,000 obs each. Thank you!
Code:
* Example generated by -dataex-. To install: ssc install dataex clear input str140 fund_name "1290 Funds: 1290 Convertible Securities Fund; Class A Shares" "1290 Funds: 1290 Convertible Securities Fund; Class I Shares" "1290 Funds: 1290 Convertible Securities Fund; Class R Shares" "1290 Funds: 1290 Diversified Bond Fund; Class A Shares" "1290 Funds: 1290 Diversified Bond Fund; Class I Shares" "1290 Funds: 1290 Diversified Bond Fund; Class R Shares" "1290 Funds: 1290 DoubleLine Dynamic Allocation Fund; Class A Shares" "1290 Funds: 1290 DoubleLine Dynamic Allocation Fund; Class I Shares" "1290 Funds: 1290 DoubleLine Dynamic Allocation Fund; Class R Shares" "1290 Funds: 1290 GAMCO Small/Mid Cap Value Fund; Class A Shares" "1290 Funds: 1290 GAMCO Small/Mid Cap Value Fund; Class C Shares" "1290 Funds: 1290 GAMCO Small/Mid Cap Value Fund; Class I Shares" "1290 Funds: 1290 GAMCO Small/Mid Cap Value Fund; Class R Shares" "1290 Funds: 1290 GAMCO Small/Mid Cap Value Fund; Class T Shares" "1290 Funds: 1290 Global Equity Managers Fund; Class A Shares" "1290 Funds: 1290 Global Equity Managers Fund; Class I Shares" "1290 Funds: 1290 Global Equity Managers Fund; Class R Shares" "1290 Funds: 1290 Global Talents Fund; Class A Shares" "1290 Funds: 1290 Global Talents Fund; Class I Shares" "1290 Funds: 1290 Global Talents Fund; Class R Shares" "1290 Funds: 1290 High Yield Bond Fund; Class A Shares" "1290 Funds: 1290 High Yield Bond Fund; Class C Shares" "1290 Funds: 1290 High Yield Bond Fund; Class I Shares" "1290 Funds: 1290 High Yield Bond Fund; Class R Shares" "1290 Funds: 1290 High Yield Bond Fund; Class T Shares" "1290 Funds: 1290 Low Volatility Global Equity Fund; Class I Shares" "1290 Funds: 1290 Multi-Alternative Strategies Fund; Class A Shares" "1290 Funds: 1290 Multi-Alternative Strategies Fund; Class I Shares" "1290 Funds: 1290 Multi-Alternative Strategies Fund; Class R Shares" "1290 Funds: 1290 Retirement 2020 Fund; Class I Shares" "1290 Funds: 1290 Retirement 2025 Fund; Class I Shares" "1290 Funds: 1290 Retirement 2030 Fund; Class I Shares" "1290 Funds: 1290 Retirement 2035 Fund; Class I Shares" "1290 Funds: 1290 Retirement 2040 Fund; Class I Shares" "1290 Funds: 1290 Retirement 2045 Fund; Class I Shares" "1290 Funds: 1290 Retirement 2050 Fund; Class I Shares" "1290 Funds: 1290 Retirement 2055 Fund; Class I Shares" "1290 Funds: 1290 Retirement 2060 Fund; Class I Shares" "1290 Funds: 1290 SmartBeta Equity Fund; Class A Shares" "1290 Funds: 1290 SmartBeta Equity Fund; Class C Shares" "1290 Funds: 1290 SmartBeta Equity Fund; Class I Shares" "1290 Funds: 1290 SmartBeta Equity Fund; Class R Shares" "1290 Funds: 1290 SmartBeta Equity Fund; Class T Shares" "1290 Funds: 1290 Unconstrained Bond Managers Fund; Class A Shares" "1290 Funds: 1290 Unconstrained Bond Managers Fund; Class I Shares" "1290 Funds: 1290 Unconstrained Bond Managers Fund; Class R Shares" "1784 Asset Allocation Fund" "1784 Connecticut Tax Exempt Income Fund" "1784 Growth Fund" "1784 Growth and Income Fund" "1784 Income" "1784 Institutional US Treasury Money Market" "1784 International Equity Fund" "1784 Massachusetts Tax Exempt Income Fund" "1784 Prime Money Market Fund" "1784 Prime Money Market/Investor" "1784 Rhode Island Tax Exempt Income Fund" "1784 Short Term Income Fund" "1784 Tax Exempt Medium Term Income Fund" "1784 Tax-Free Money Market Fund" "1784 US Government Medium Term Income Fund" "1784 US Treasury Money Market" "1838 Fixed Income Fund" "1838 Investment Advisors Funds: 1838 Fixed Income Fund" "1838 Investment Advisors Funds: 1838 International Equity Fund" "1838 Investment Advisors Funds: 1838 Large Cap Equity Fund" "1838 Investment Advisors Funds: 1838 Small Cap Equity Fund" "1838 Small Cap Equity Fund" "1st Source Monogram Diversified Equity Fund" "1st Source Monogram Income Equity Fund" "1st Source Monogram Income Fund" "1st Source Monogram Intmed Tax Free Bond" "1st Source Monogram Special Equity Fund" "360 Funds: Crow Point Alternative Income Fund" "360 Funds: Crow Point Defined Risk Global Equity Income Fund; Class A Shares" "360 Funds: Crow Point Defined Risk Global Equity Income Fund; Class I Shares" "360 Funds: Crow Point Global Tactical Allocation; Institutional Class Shares" "360 Funds: Crow Point Global Tactical Allocation; Investor Class Shares" "360 Funds: EAS Crow Point Alternatives Fund; Class A Shares" "360 Funds: EAS Crow Point Alternatives Fund; Class C Shares" "360 Funds: EAS Crow Point Alternatives Fund; Class I Shares" "360 Funds: Eagle Rock Floating Rate Fund; Institutional Class Shares" "360 Funds: FinTrust Income and Opportunity Fund; Class A Shares" "360 Funds: FinTrust Income and Opportunity Fund; Institutional Class Shares" "360 Funds: Foundry Micro Cap Value Fund; Institutional Class Shares" "360 Funds: Foundry Small Cap Value Fund; Institutional Class Shares" "360 Funds: HedgeRow Income and Opportunity Fund; Class A Shares" "360 Funds: HedgeRow Income and Opportunity Fund; Institutional Class Shares" "360 Funds: IMS Capital Value Fund; Institutional Class Shares" "360 Funds: IMS Dividend Growth Fund; Institutional Class Shares" "360 Funds: IMS Strategic Income Fund; Institutional Class Shares" "360 Funds: Powell Alternative Income Strategies Fund; Investor Class Shares" "360 Funds: RVX Emerging Markets Equity Fund; Institutional Class Shares" "360 Funds: Snow Capital Dividend Plus Fund; Class A Shares" "360 Funds: Snow Capital Dividend Plus Fund; Class I Shares" "360 Funds: Snow Capital Focused Value Fund; Class A Shares" "360 Funds: Snow Capital Focused Value Fund; Class I Shares" "360 Funds: Snow Capital Hedged Equity Fund; Class A Shares" "360 Funds: Snow Capital Hedged Equity Fund; Class I Shares" "360 Funds: Snow Capital Inflation Advantaged Equities Fund; Class A Shares" end
Code:
* Example generated by -dataex-. To install: ssc install dataex clear input str43 fundname "1290 Convertible Securities A" "1290 Convertible Securities I" "1290 Convertible Securities R" "1290 Diversified Bond A" "1290 Diversified Bond I" "1290 Diversified Bond R" "1290 DoubleLine Dynamic Allocation A" "1290 DoubleLine Dynamic Allocation I" "1290 DoubleLine Dynamic Allocation R" "1290 GAMCO Small/Mid Cap Value A" "1290 GAMCO Small/Mid Cap Value I" "1290 GAMCO Small/Mid Cap Value R" "1290 GAMCO Small/Mid Cap Value T" "1290 Global Talents A" "1290 Global Talents I" "1290 Global Talents R" "1290 High Yield Bond A" "1290 High Yield Bond I" "1290 High Yield Bond R" "1290 High Yield Bond T" "1290 Low Volatility Global Equity I" "1290 Multi-Alternative Strategies A" "1290 Multi-Alternative Strategies I" "1290 Multi-Alternative Strategies R" "1290 Retirement 2020 I" "1290 Retirement 2025 I" "1290 Retirement 2030 I" "1290 Retirement 2035 I" "1290 Retirement 2040 I" "1290 Retirement 2045 I" "1290 Retirement 2050 I" "1290 Retirement 2055 I" "1290 Retirement 2060 I" "1290 SmartBeta Equity A" "1290 SmartBeta Equity I" "1290 SmartBeta Equity R" "1290 SmartBeta Equity T" "13D Activist A" "13D Activist C" "13D Activist I" "1789 Growth and Income C" "1789 Growth and Income P" "1919 Financial Services A" "1919 Financial Services C" "1919 Financial Services I" "1919 Maryland Tax-Free Income A" "1919 Maryland Tax-Free Income C" "1919 Maryland Tax-Free Income I" "1919 Socially Responsive Balanced A" "1919 Socially Responsive Balanced C" "1919 Socially Responsive Balanced I" "361 Domestic Long/Short Equity I" "361 Domestic Long/Short Equity Investor" "361 Domestic Long/Short Equity Y" "361 Global Equity Absolute Return I" "361 Global Equity Absolute Return Inv" "361 Global Equity Absolute Return Y" "361 Global Long/Short Equity I" "361 Global Long/Short Equity Investor" "361 Global Long/Short Equity Y" "361 Global Managed Futures Strategy I" "361 Global Managed Futures Strategy Inv" "361 Macro Opportunity I" "361 Macro Opportunity Inv" "361 Managed Futures Strategy I" "361 Managed Futures Strategy Inv" "361 US Small Cap Equity I" "361 US Small Cap Equity Inv" "361 US Small Cap Equity Y" "7Twelve Balanced 3" "7Twelve Balanced 4" "AAAMCO Ultrashort Financing I" "AAAMCO Ultrashort Financing Y" "AAM/Bahl & Gaynor Income Growth A" "AAM/Bahl & Gaynor Income Growth C" "AAM/Bahl & Gaynor Income Growth I" "AAM/HIMCO Global Enhanced Dividend A" "AAM/HIMCO Global Enhanced Dividend C" "AAM/HIMCO Global Enhanced Dividend I" "AAM/HIMCO Short Duration A" "AAM/HIMCO Short Duration C" "AAM/HIMCO Short Duration I" "AAM/Insight Select Income A" "AAM/Insight Select Income C" "AAM/Insight Select Income I" "AAM/Insight Select Income Y" "AAM/Phocas Real Estate A" "AAM/Phocas Real Estate I" "AAMA Equity" "AAMA Income" "AB All China Equity A" "AB All China Equity Advisor" "AB All Market Income A" "AB All Market Income Advisor" "AB All Market Income C" "AB All Market Real Return 1" "AB All Market Real Return 2" "AB All Market Real Return A" "AB All Market Real Return Advisor" "AB All Market Real Return C" end
0 Response to Matching string
Post a Comment