Help with SAS Program on Duplicates Names

anilreddam1 — Tue, 07 May 2019 20:19:17 GMT

Dear All,

I have a Dataset which has CompanyNames in it. However the challenge here is that Company names slightly differ to each other although all belongs to one company only. For example if you see below 1 800 FLOWERS and 1 800 FLOWERS COM CL A and 1-800-FLOWERS.COM INC and 1-800-FLOWERS.COM INC-CL A and 1-800-FLOWERS.COM INC. CLASS are all same.

Hence I am trying to bring all these names under one name so that they are consistent. In this case it will be 1 800 FLOWERS.

Please help me how to achieve this task through SAS program. For easy access I have made the program readily available here.

I truly appreciate your timely help.

Data Fix_CompanyNames;

input Company $28.;

Infile cards;

cards;

1 800 FLOWERS

1 800 FLOWERS COM CL A

1-800-FLOWERS.COM INC

1-800-FLOWERS.COM INC-CL A

1-800-FLOWERS.COM INC. CLASS

1347 PPTY INS HLDGS INC

180 DEGREE CAP CORP

180 DEGREE CAPITAL CORP

1ST CONSTITUTION BANCORP

1ST SOURCE CORP

1ST SOURCE CORP COM

21VIANET GROUP INC

21VIANET GROUP INC - ADR

21VIANET GROUP INC ADR

21VIANET GROUP INC-ADR

22ND CENTURY GROUP INC

22ND CENTY GROUP INC

2U INC

3-D SYS CORP DEL

3-D SYS CORP DEL COM NEW

3D SYSTEMS CORP

3M CO

3M COMPANY

500 COM LTD

500.COM LTD

51JOB INC

51JOB INC ADR

51JOB INC-ADR

51JOBS INC-ADR

58 COM INC

58 COM INC ADR

58 COM INC-ADR

58.COM INC

58.COM INC A ADR

58.COM INC ADR

58.COM INC-ADR

58.COM-ADR

8 X 8 INCORPORATED

8 X 8, INCORPORATED

8POINT3 ENERGY PARTNERS LP

8X8 INC

8X8 INC NEW

8X8 INC NEW COM

A H BELO CORP

A H BELO CORP-A

A MARK PRECIOUS METALS INC

A SCHULMAN INC

A-MARK PRECIOUS METALS INC

SCHULMAN INC.

A.O. SMITH

A10 NETWORKS INC

AAC HLDGS INC

AAC HOLDINGS INC

AAON INC

AAON INC COM PAR $0.004

AAR CORP

AAR CORP COM

AAR CORPORATION

AARON'S

AARON'S INC

AARONS INC

AAWW 1.875 6/24

AAWW 2.25 06/22

ABAXIS INC

ABAXIS INCORPORATED

ABB LIMITED ADR

ABB LTD

ABB LTD ADR

ABB LTD-ADR

ABB LTD-SPON ADR

ABBOTT LABORATORIES

ABBOTT LABS

ABBOTT LABS COM

ABBVIE INC

ABBVIE INC COM

ABBVIE INC.

ABEONA THERAPEUTICS INC

ABERCROMBIE & FITCH

ABERCROMBIE & FITCH CO

ABERCROMBIE & FITCH CO CL A

ABERCROMBIE & FITCH CO-CL A

ABERCROMBIE & FITCH COMPANY-

ABERCROMBIE &#38 FITCH

ABERDEEN ASIA PACIFIC INCOM

ABERDEEN AUSTRALIA EQTY FD I

ABERDEEN CHILE FD INC

ABERDEEN CHILE FUND INC

ABERDEEN EMERG

ABERDEEN GLOBAL INCOME FD IN

ABERDEEN GREATE

ABERDEEN ISRAE

ABERDEEN ISRAEL FUND INC

ABERDEEN JAPAN

ABERDEEN LATIN

ABERDEEN LATIN AMER EQTY FD

ABERDEEN SG FD

ABERDEEN SINGAPORE FD INC

ABILITY INC

ABIOMED INC

ABIOMED INC COM

ABIOMED INC.

ABLYNX NV

ABLYNX NV - ADR

ABM INDS INC

ABM INDS INC COM

ABM INDUSTRIES INC

ABR 5.375 11/15/20

ABRAXAS PETE CORP

ABRAXAS PETE CORP COM

ABRAXAS PETROLEUM CORP

ABSOLUTE SHS TR

AC IMMUNE SA

ACACIA COMMUNIC

ACACIA COMMUNICATIONS INC

ACACIA RESEARCH - ACACIA TEC

ACACIA RESEARCH CORP

ACACIA RESH CORP

ACADEMY FDS TR

ACADIA HEALTHCAR

ACADIA HEALTHCARE

ACADIA HEALTHCARE CO INC

ACADIA HEALTHCARE COMPANY IN

ACADIA PHARMACEUTICALS INC

ACADIA PHARMACEUTICALS INC C

ACADIA REALTY

ACADIA REALTY TRUS

ACADIA REALTY TRUST

ACADIA RLTY TR

ACADIA RLTY TR COM SH BEN IN

ACASTI PHARMA INC

ACCELERATE DIAGNOSTICS INC

ACCELERON PHARMA

ACCELERON PHARMA INC

ACCENTURE LTD BERMUDA CL A

ACCENTURE PLC

ACCENTURE PLC (A) ADR

ACCENTURE PLC CL A

ACCENTURE PLC CLASS A

ACCENTURE PLC IRELAND

ACCENTURE PLC IRELAND SHARES

ACCENTURE PLC IRELAND SHS

ACCENTURE PLC-A

ACCENTURE PLC-CL A

ACCESS NATIONAL CORP

ACCESS NATIONAL CORP COM

ACCESS NATL CORP

ACCLERATE DIAGNOSTICS INC

ACCO BRANDS CORP

ACCURAY INC

ACELRX PHARMACEUTICALS INC

ACER THERAPEUTICS INC

ACETO CORP

ACETO CORP COM

ACHAOGEN INC

ACHIEVE LIFE SCIENCE INC

ACHIEVE LIFE SCIENCES INC

ACHILLION PHARMACEUTICALS

ACHILLION PHARMACEUTICALS IN

ACHILLION PHARMACTCLS

ACI WORLDWIDE INC

ACLARIS THERAPE

ACLARIS THERAPEUTICS INC

ACME UTD CORP

ACNB CORP

ACOR 1.75 21

ACORDA THERAPEUTICS INC

ACORN INTL INC

ACRE RLTY INVS INC

ACT 5.5 03/01/18

ACTINIUM PHARMACEUTICALS INC

ACTIVE WEIGHTING FDS ETF TR

ACTIVISION BLIZ

ACTIVISION BLIZZ

ACTIVISION BLIZZARD INC

ACTUA CORP

ACTUA CORPORATION

ACTUANT CORP

ACTUANT CORP CL A NEW

ACTUANT CORP CLASS A

ACTUANT CORP-A

ACUITY BRANDS INC

ACUITY BRANDS INC COM

ACUITY BRANDS INC COM USD0 0

ACUSHNET HOLDINGS CORP

ACXIOM

ACXIOM CORP

ACXIOM CORP COM

ACXIOM CORPORATION

ADAM NAT RES FD INC

ADAMAS PHARMA

ADAMAS PHARMACEUTICALS INC

ADAMIS PHARMACEUTICALS CORP

ADAMIS PHARMACEUTICALS INC C

ADAMS DIVERSIFI

ADAMS DIVERSIFIED EQUITY

ADAMS DIVERSIFIED EQUITY FD

ADAMS DIVERSIFIED EQUITY FUN

ADAMS EXPRESS

ADAMS NATURAL

ADAMS NATURAL RESOURCES FUND

ADAMS RES & ENERGY INC

ADAMS RESOURCES & ENERGY INC

ADAPTIMMUNE THERAPEUTICS - A

ADAPTIMMUNE THERAPEUTICS PLC

ADAPTIMMUNE THERAPEUTICS-ADR

ADCARE HEALTH SYSTEMS

ADCARE HEALTH SYSTEMS INC

ADDUS HOMECARE CORP

ADDVANTAGE TECHNOLOGIES GP I

ADDVANTAGE TECHNOLOGIES GRP

ADECOAGRO S A

ADECOAGRO SA

;

run;

Re: Help with SAS Program on Duplicates Names

ballardw — Tue, 07 May 2019 20:44:41 GMT

Is there any other data associated with these names such as address, city, state, Tax identification number, Employer identification number or similar?

You may need that to "tie break" if you have a name like "Smith and Sons" or "Smith & Sons". If one is in New York and the other in Oklahoma City likely not to be the same even if the name is very similar or identical.

Re: Help with SAS Program on Duplicates Names

anilreddam1 — Tue, 07 May 2019 20:57:15 GMT

Thank you so much for your quick response. But these Company Names are not tied with any other unique identifiers. Just wondering would it still be achievable thru SAS program or we have to deal with Manually ?

Re: Help with SAS Program on Duplicates Names

Reeza — Tue, 07 May 2019 21:57:07 GMT

@anilreddam1 wrote:

Thank you so much for your quick response. But these Company Names are not tied with any other unique identifiers. Just wondering would it still be achievable thru SAS program or we have to deal with Manually ?

What accuracy level do you need for the results?

If it's 100% accuracy, you'll need to do it manually but you can use various methods to help that happen a lot easier.

topic Help with SAS Program on Duplicates Names in New SAS User

Help with SAS Program on Duplicates Names

Re: Help with SAS Program on Duplicates Names

Re: Help with SAS Program on Duplicates Names

Re: Help with SAS Program on Duplicates Names