Hi everyone,

I am trying to drop duplicates in my dataset and keep one of them.

I know the command
Code:
duplicates drop name modate, force
but this deletes all duplicates and does not keep one of them.

I also tried this command
Code:
by name (modate), sort: keep if _n == _N
as I saw this on a similar post here in the forum but it seems that this code does not work for my data.

Code:
* Example generated by -dataex-. To install: ssc install dataex
clear
input long funding str67 name float modate
  1180043 "Equity Crowdfunding - Baanx Group"                         719
  3250126 "Venture Round - FeedStock Ltd"                             719
   676819 "Seed Round - Yimba"                                        719
  5000000 "Venture Round - SalaryFits"                                719
  6500000 "Series A - ABAKA Holdings"                                 719
  1800000 "Convertible Note - Genesis Global"                         719
  2818000 "Seed Round - Rebank"                                       719
   328084 "Pre Seed Round - Bequest"                                  719
    55757 "Grant - symmetrical.ai"                                    719
  9431306 "Series A - Portify"                                        719
 14048466 "Series A - FintechOS"                                      719
  1172339 "Equity Crowdfunding - Currensea"                           719
   651321 "Seed Round - Visible Capital"                              719
  1734669 "Equity Crowdfunding - Oval Money"                          719
 15000000 "Debt Financing - PrimaDollar"                              719
 90000000 "Initial Coin Offering - Setcoin Group"                     719
 20000000 "Series C - Rapyd"                                          719
  2763239 "Equity Crowdfunding - B-North"                             719
 20000000 "Series A - Hastee"                                         719
323495197 "Post-IPO Debt - Funding Circle"                            719
   250000 "Pre Seed Round - Clarity HQ"                               719
  1000000 "Seed Round - Claro Money"                                  719
 12912373 "Seed Round - Uncapped"                                     719
167860846 "Series H - Zopa"                                           719
250000000 "Debt Financing - Hastee"                                   719
  3411598 "Seed Round - Rossum"                                       718
   320875 "Seed Round - Ember"                                        718
  3229707 "Seed Round - Insurtech Gateway"                            718
   646389 "Seed Round - Finverity"                                    718
 10358669 "Venture Round - Funding Xchange"                           718
  3000000 "Venture Round - Plum Fintech"                              718
  4000000 "Venture Round - Chaser"                                    718
  5000000 "Series A - Globacap"                                       718
 12156644 "Series A - IMMO Investment Technologies"                   718
  3205099 "Seed Round - Digital Debt Capital Markets"                 718
  4499397 "Angel Round - Chip Financial"                              718
   858853 "Equity Crowdfunding - The House Crowd"                     718
  1617704 "Seed Round - Diaspora"                                     718
 77631213 "Series A - Pollinate Networks"                             717
 15526243 "Series A - Freetrade"                                      717
  6450473 "Debt Financing - TotallyMoney"                             717
  6450473 "Seed Round - M∙QUBE"                                 717
  4900000 "Seed Round - Koyo"                                         717
655000000 "Venture Round - Greensill Capital"                         717
  3206748 "Series A - Oval Money"                                     717
 38761292 "Venture Round - Starling Bank"                             717
   688004 "Series A - 3S Money"                                       717
  4550349 "Equity Crowdfunding - ANNA : Absolutely No Nonsense Admin" 717
  2572910 "Seed Round - Proportunity"                                 717
   854838 "Seed Round - Thirdfort"                                    717
 74010023 "Series B - Tide"                                           717
    52500 "Seed Round - KodyPay"                                      717
  4619479 "Equity Crowdfunding - Chip Financial"                      717
   688338 "Seed Round - Armadillo Financial Technologies"             717
100000000 "Series C - Rapyd"                                          717
  2500000 "Seed Round - CRED Investments"                             717
  4915998 "Series A - DeadHappy"                                      716
 44383075 "Series C - Moneyfarm"                                      716
 18000000 "Series A - FIDEL API"                                      716
  1955000 "Seed Round - skew."                                        716
  4000000 "Venture Round - Digital Fineprint (DFP)"                   716
  4369849 "Series A - MishiPay"                                       716
  2000000 "Seed Round - Bottlepay"                                    716
  3073094 "Equity Crowdfunding - Plum Fintech"                        716
  4000000 "Venture Round - Cazana"                                    716
  1252315 "Seed Round - Tumelo"                                       716
 12425663 "Series B - Netwealth"                                      716
  2485133 "Seed Round - TreasurySpring"                               716
  1600000 "Pre Seed Round - Kudimoney"                                716
  1233551 "Seed Round - Storm2"                                       716
  1938730 "Equity Crowdfunding - Creditspring"                        716
  1235756 "Seed Round - Finance Unlocked"                             716
  1600000 "Pre Seed Round - Kuda Bank"                                716
   166000 "Seed Round - Equipment Connect"                            716
135803643 "Venture Round - Sonovate"                                  716
     1235 "Pre Seed Round - DarQube"                                  716
    37692 "Equity Crowdfunding - Squirrel"                            716
  8600000 "Series A - PrimaryBid"                                     716
 10000000 "Series A - Railsbank"                                      716
  7195358 "Equity Crowdfunding - Curve"                               716
    49377 "Grant - Zlick"                                             716
  1816225 "Equity Crowdfunding - goHenry"                             716
   542925 "Pre Seed Round - ResonanceX"                               716
   425550 "Pre Seed Round - Appital"                                  716
  3700000 "Venture Round - Project Imagine"                           716
  1459027 "Seed Round - Pomelo Pay"                                   716
   121586 "Pre Seed Round - HELPFUL"                                  716
  2614188 "Seed Round - Penfold"                                      715
   250000 "Pre Seed Round - Claro Money"                              715
   100997 "Seed Round - AreOne.com"                                   715
   303975 "Pre Seed Round - Elfin Market"                             715
   547156 "Seed Round - Whitehall Finance"                            715
    24182 "Pre Seed Round - Bond180"                                  715
   400000 "Seed Round - wamo"                                         715
 10000000 "Venture Round - VeganNation"                               715
 15000000 "Venture Round - LendInvest"                                715
   904508 "Seed Round - Knoma"                                        715
 12060108 "Grant - iwoca"                                             715
 11000000 "Series A - flatfair"                                       715
 12060108 "Grant - Currencycloud"                                     715
end
format %tm modate