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
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 & 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;
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.
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 ?
@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.
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!
SAS' Charu Shankar shares her PROC SQL expertise by showing you how to master the WHERE clause using real winter weather data.
Find more tutorials on the SAS Users YouTube channel.