Announcement

Collapse
No announcement yet.
X
Collapse
  • Page of 1
  • Filter
  • Time
  • Show
Clear All
new posts
  • #1

    help with counting

    Dear Statalist,

    I'm having problem counting a large dataset. The number of observations is about 100,000.

    I want to count that, with each investor, the number of LeadManager it has within the 1826 days, and the number of leadmanager should not include the repetitive counts.

    Thanks so much!

    Code:
    * Example generated by -dataex-. For more info, type help dataex
clear
input int IssueDate str36 StockName str31 Investor str35 LeadManager
21810 "DATADOG INC."                   "1 NORTH WEALTH SERVICES, LLC"  "Jefferies & Co Inc"            
21810 "DATADOG INC."                   "1 NORTH WEALTH SERVICES, LLC"  "Morgan Stanley & Co"           
21810 "DATADOG INC."                   "1 NORTH WEALTH SERVICES, LLC"  "Credit Suisse"                 
21810 "DATADOG INC."                   "1 NORTH WEALTH SERVICES, LLC"  "Goldman Sachs & Co"            
21810 "DATADOG INC."                   "1 NORTH WEALTH SERVICES, LLC"  "JP Morgan (JPM)"               
21810 "DATADOG INC."                   "1 NORTH WEALTH SERVICES, LLC"  "Barclays Capital"              
21810 "DATADOG INC."                   "1 NORTH WEALTH SERVICES, LLC"  "RBC Capital Markets"           
19928 "ADVANCED DRAINAGE SYSTEMS INC." "12 WEST CAPITAL MGMT, L.P."    "CITIGROUP"                     
19928 "ADVANCED DRAINAGE SYSTEMS INC." "12 WEST CAPITAL MGMT, L.P."    "Barclays Capital"              
19928 "ADVANCED DRAINAGE SYSTEMS INC." "12 WEST CAPITAL MGMT, L.P."    "RBC Capital Markets"           
19928 "ADVANCED DRAINAGE SYSTEMS INC." "12 WEST CAPITAL MGMT, L.P."    "Deutsche Bank Securities Corp" 
21362 "NEURONETICS INC."               "12 WEST CAPITAL MGMT, L.P."    "William Blair & Co"            
21362 "NEURONETICS INC."               "12 WEST CAPITAL MGMT, L.P."    "Piper Jaffray Inc"             
20117 "SHAKE SHACK INC."               "12 WEST CAPITAL MGMT, L.P."    "Goldman Sachs & Co"            
20117 "SHAKE SHACK INC."               "12 WEST CAPITAL MGMT, L.P."    "Jefferies & Co Inc"            
20117 "SHAKE SHACK INC."               "12 WEST CAPITAL MGMT, L.P."    "Morgan Stanley & Co"           
20117 "SHAKE SHACK INC."               "12 WEST CAPITAL MGMT, L.P."    "Barclays Capital"              
20117 "SHAKE SHACK INC."               "12 WEST CAPITAL MGMT, L.P."    "JP Morgan (JPM)"               
21300 "SMARTSHEET INC."                "12 WEST CAPITAL MGMT, L.P."    "RBC Capital Markets"           
21300 "SMARTSHEET INC."                "12 WEST CAPITAL MGMT, L.P."    "JP Morgan (JPM)"               
21300 "SMARTSHEET INC."                "12 WEST CAPITAL MGMT, L.P."    "Jefferies & Co Inc"            
21300 "SMARTSHEET INC."                "12 WEST CAPITAL MGMT, L.P."    "Morgan Stanley & Co"           
19948 "C1 FINANCIAL INC"               "1492 CAPITAL MANAGEMENT, LLC"  "Raymond James & Associates Inc"
19948 "C1 FINANCIAL INC"               "1492 CAPITAL MANAGEMENT, LLC"  "Keefe Bruyette & Woods Inc"    
21216 "ONE STOP SYSTEMS INC."          "1492 CAPITAL MANAGEMENT, LLC"  "Roth Capital Partners Inc"     
19739 "RSP PERMIAN INC."               "1492 CAPITAL MANAGEMENT, LLC"  "JP Morgan (JPM)"               
19739 "RSP PERMIAN INC."               "1492 CAPITAL MANAGEMENT, LLC"  "RBC Capital Markets"           
19739 "RSP PERMIAN INC."               "1492 CAPITAL MANAGEMENT, LLC"  "UBS Investment Bank"           
19739 "RSP PERMIAN INC."               "1492 CAPITAL MANAGEMENT, LLC"  "Barclays Capital"              
19739 "RSP PERMIAN INC."               "1492 CAPITAL MANAGEMENT, LLC"  "TUDOR-PICKERING"               
19739 "RSP PERMIAN INC."               "1492 CAPITAL MANAGEMENT, LLC"  "Raymond James & Associates Inc"
20037 "THE JOINT CORP."                "1492 CAPITAL MANAGEMENT, LLC"  "Feltl & Co"                    
20037 "THE JOINT CORP."                "1492 CAPITAL MANAGEMENT, LLC"  "Roth Capital Partners Inc"     
21361 "THE LOVESAC CO."                "1492 CAPITAL MANAGEMENT, LLC"  "Roth Capital Partners Inc"     
19094 "FORUM ENERGY TECHNOLOGIES INC." "1798 GLOBAL PTNR (CAYMAN) LTD" "Deutsche Bank Securities Corp" 
19094 "FORUM ENERGY TECHNOLOGIES INC." "1798 GLOBAL PTNR (CAYMAN) LTD" "Credit Suisse"                 
19094 "FORUM ENERGY TECHNOLOGIES INC." "1798 GLOBAL PTNR (CAYMAN) LTD" "BOA-MERRILL"                   
19094 "FORUM ENERGY TECHNOLOGIES INC." "1798 GLOBAL PTNR (CAYMAN) LTD" "CITIGROUP"                     
19094 "FORUM ENERGY TECHNOLOGIES INC." "1798 GLOBAL PTNR (CAYMAN) LTD" "JP Morgan (JPM)"               
18786 "FUSION-IO INC."                 "1798 GLOBAL PTNR (CAYMAN) LTD" "Morgan Stanley & Co"           
18786 "FUSION-IO INC."                 "1798 GLOBAL PTNR (CAYMAN) LTD" "Goldman Sachs & Co"            
18786 "FUSION-IO INC."                 "1798 GLOBAL PTNR (CAYMAN) LTD" "Credit Suisse"                 
18786 "FUSION-IO INC."                 "1798 GLOBAL PTNR (CAYMAN) LTD" "JP Morgan (JPM)"               
19276 "REALOGY HOLDINGS CORP."         "1798 GLOBAL PTNR (CAYMAN) LTD" "Goldman Sachs & Co"            
19276 "REALOGY HOLDINGS CORP."         "1798 GLOBAL PTNR (CAYMAN) LTD" "Barclays Capital"              
19276 "REALOGY HOLDINGS CORP."         "1798 GLOBAL PTNR (CAYMAN) LTD" "JP Morgan (JPM)"               
19276 "REALOGY HOLDINGS CORP."         "1798 GLOBAL PTNR (CAYMAN) LTD" "Credit Suisse"                 
18828 "SUNCOKE ENERGY INC."            "1798 GLOBAL PTNR (CAYMAN) LTD" "BOA-MERRILL"                   
18828 "SUNCOKE ENERGY INC."            "1798 GLOBAL PTNR (CAYMAN) LTD" "Credit Suisse"                 
18828 "SUNCOKE ENERGY INC."            "1798 GLOBAL PTNR (CAYMAN) LTD" "Goldman Sachs & Co"            
19844 "ARES MANAGEMENT LP"             "1832 ASSET MANAGEMENT L.P."    "Morgan Stanley & Co"           
19844 "ARES MANAGEMENT LP"             "1832 ASSET MANAGEMENT L.P."    "JP Morgan (JPM)"               
19844 "ARES MANAGEMENT LP"             "1832 ASSET MANAGEMENT L.P."    "BOA-MERRILL"                   
19844 "ARES MANAGEMENT LP"             "1832 ASSET MANAGEMENT L.P."    "Wells Fargo"                   
19844 "ARES MANAGEMENT LP"             "1832 ASSET MANAGEMENT L.P."    "Goldman Sachs & Co"            
20935 "FLOOR & DECOR HOLDINGS INC."    "1832 ASSET MANAGEMENT L.P."    "Credit Suisse"                 
20935 "FLOOR & DECOR HOLDINGS INC."    "1832 ASSET MANAGEMENT L.P."    "Barclays Capital"              
20935 "FLOOR & DECOR HOLDINGS INC."    "1832 ASSET MANAGEMENT L.P."    "Merrill Lynch & Co Inc"        
20935 "FLOOR & DECOR HOLDINGS INC."    "1832 ASSET MANAGEMENT L.P."    "UBS Investment Bank"           
20935 "FLOOR & DECOR HOLDINGS INC."    "1832 ASSET MANAGEMENT L.P."    "Goldman Sachs & Co"            
20935 "FLOOR & DECOR HOLDINGS INC."    "1832 ASSET MANAGEMENT L.P."    "Piper Jaffray Inc"             
20935 "FLOOR & DECOR HOLDINGS INC."    "1832 ASSET MANAGEMENT L.P."    "Wells Fargo"                   
20935 "FLOOR & DECOR HOLDINGS INC."    "1832 ASSET MANAGEMENT L.P."    "Jefferies & Co Inc"            
20850 "INVITATION HOMES INC."          "1832 ASSET MANAGEMENT L.P."    "JP Morgan (JPM)"               
20850 "INVITATION HOMES INC."          "1832 ASSET MANAGEMENT L.P."    "Morgan Stanley & Co"           
20850 "INVITATION HOMES INC."          "1832 ASSET MANAGEMENT L.P."    "Wells Fargo"                   
20850 "INVITATION HOMES INC."          "1832 ASSET MANAGEMENT L.P."    "Goldman Sachs & Co"            
20850 "INVITATION HOMES INC."          "1832 ASSET MANAGEMENT L.P."    "Deutsche Bank Securities Corp" 
20850 "INVITATION HOMES INC."          "1832 ASSET MANAGEMENT L.P."    "Merrill Lynch & Co Inc"        
20850 "INVITATION HOMES INC."          "1832 ASSET MANAGEMENT L.P."    "RBC Capital Markets"           
20850 "INVITATION HOMES INC."          "1832 ASSET MANAGEMENT L.P."    "Credit Suisse"                 
20838 "KEANE GROUP INC."               "1832 ASSET MANAGEMENT L.P."    "CITIGROUP"                     
20838 "KEANE GROUP INC."               "1832 ASSET MANAGEMENT L.P."    "Merrill Lynch & Co Inc"        
20838 "KEANE GROUP INC."               "1832 ASSET MANAGEMENT L.P."    "Morgan Stanley & Co"           
20838 "KEANE GROUP INC."               "1832 ASSET MANAGEMENT L.P."    "JP Morgan (JPM)"               
19886 "MEMORIAL RESOURCE DVLP CORP."   "1832 ASSET MANAGEMENT L.P."    "RBC Capital Markets"           
19886 "MEMORIAL RESOURCE DVLP CORP."   "1832 ASSET MANAGEMENT L.P."    "BOA-MERRILL"                   
19886 "MEMORIAL RESOURCE DVLP CORP."   "1832 ASSET MANAGEMENT L.P."    "CITIGROUP"                     
19886 "MEMORIAL RESOURCE DVLP CORP."   "1832 ASSET MANAGEMENT L.P."    "Raymond James & Associates Inc"
19886 "MEMORIAL RESOURCE DVLP CORP."   "1832 ASSET MANAGEMENT L.P."    "Barclays Capital"              
19886 "MEMORIAL RESOURCE DVLP CORP."   "1832 ASSET MANAGEMENT L.P."    "Goldman Sachs & Co"            
19886 "MEMORIAL RESOURCE DVLP CORP."   "1832 ASSET MANAGEMENT L.P."    "BMO Capital Markets"           
19886 "MEMORIAL RESOURCE DVLP CORP."   "1832 ASSET MANAGEMENT L.P."    "Wells Fargo"                   
19753 "NEW HOME CO INC."               "1832 ASSET MANAGEMENT L.P."    "CITIGROUP"                     
19753 "NEW HOME CO INC."               "1832 ASSET MANAGEMENT L.P."    "JP Morgan (JPM)"               
19753 "NEW HOME CO INC."               "1832 ASSET MANAGEMENT L.P."    "Credit Suisse"                 
20193 "PARTY CITY HOLDCO INC."         "1832 ASSET MANAGEMENT L.P."    "Credit Suisse"                 
20193 "PARTY CITY HOLDCO INC."         "1832 ASSET MANAGEMENT L.P."    "JP Morgan (JPM)"               
20193 "PARTY CITY HOLDCO INC."         "1832 ASSET MANAGEMENT L.P."    "Goldman Sachs & Co"            
20193 "PARTY CITY HOLDCO INC."         "1832 ASSET MANAGEMENT L.P."    "Merrill Lynch & Co Inc"        
20193 "PARTY CITY HOLDCO INC."         "1832 ASSET MANAGEMENT L.P."    "Deutsche Bank Securities Corp" 
20193 "PARTY CITY HOLDCO INC."         "1832 ASSET MANAGEMENT L.P."    "Barclays Capital"              
20193 "PARTY CITY HOLDCO INC."         "1832 ASSET MANAGEMENT L.P."    "Morgan Stanley & Co"           
19745 "SANTANDER CONSUMER USA HLDGS"   "1832 ASSET MANAGEMENT L.P."    "JP Morgan (JPM)"               
19745 "SANTANDER CONSUMER USA HLDGS"   "1832 ASSET MANAGEMENT L.P."    "Barclays Capital"              
19745 "SANTANDER CONSUMER USA HLDGS"   "1832 ASSET MANAGEMENT L.P."    "RBC Capital Markets"           
19745 "SANTANDER CONSUMER USA HLDGS"   "1832 ASSET MANAGEMENT L.P."    "Morgan Stanley & Co"           
19745 "SANTANDER CONSUMER USA HLDGS"   "1832 ASSET MANAGEMENT L.P."    "Deutsche Bank Securities Corp" 
19745 "SANTANDER CONSUMER USA HLDGS"   "1832 ASSET MANAGEMENT L.P."    "Goldman Sachs & Co"            
19745 "SANTANDER CONSUMER USA HLDGS"   "1832 ASSET MANAGEMENT L.P."    "CITIGROUP"                     
end
format %tdnn/dd/CCYY IssueDate
    Tags: None
  • #2



    See e.g. https://www.statalist.org/forums/for...nge-by-inrange for using rangerun (SSC) in conjunction with tabulate.

    Something like

    Code:
    egen LM = group(LeadManager)

capture program drop myprog 

program myprog
qui tab LM
gen ndistinct = r(r)
end

rangerun myprog, use(LM) inter(IssueDate -1826 0) by(Investor)
    "within the 1826 days" is ambiguous and might mean -1826 -1 or -1825 0 and so on.
    • 1 like

    Comment

    • #3
      Thanks Nick! It works.

      Comment

      Previous Next
      Working...
      X