I'm looking to see if there is a command that I can easily get the summary stats.
BA_Street1 - hq street address (HQ = Headquarters)
BA_City hq city
BA_State state hq
BA_Zip zip hq
ba_street_change ba_city_change ba_state_change ba_zip_change these are all the dummies, when == 1 means there was an HQ change from one year to another.
date
CIK unique indentifier for each company.
I want to see summary stats for how many companies have changed their HQ. that means how many have changed, what years, what percentatge. And other stats that could be nice to see.
the way I was doing it was:
count if ba_street_change == 1 , then from this number I would do the percentatges (for all the dummies). But that doesn't look to nice.
Would there be a way to create a table with all of these descriptive summary stats?
Code:
* Example generated by -dataex-. To install: ssc install dataex clear input str40 BA_Street1 str30 BA_City str8 BA_State str10 BA_Zip float(ba_street_change ba_city_change ba_state_change ba_zip_change) int date long CIK "1100 N WOOD DALE RD" "WOOD DALE" "IL" "60191" 0 0 0 0 2009 1750 "1100 N WOOD DALE RD" "WOOD DALE" "IL" "60191" 0 0 0 0 2010 1750 "1100 N WOOD DALE RD" "WOOD DALE" "IL" "60191" 0 0 0 0 2011 1750 "1100 N WOOD DALE RD" "WOOD DALE" "IL" "60191" 0 0 0 0 2012 1750 "1100 N WOOD DALE RD" "WOOD DALE" "IL" "60191" 0 0 0 0 2013 1750 "1100 N WOOD DALE RD" "WOOD DALE" "IL" "60191" 0 0 0 0 2014 1750 "1100 N WOOD DALE RD" "WOOD DALE" "IL" "60191" 0 0 0 0 2015 1750 "100 ABBOTT PARK ROAD" "ABBOTT PARK" "IL" "60064-3500" 0 0 0 0 2009 1800 "100 ABBOTT PARK ROAD" "ABBOTT PARK" "IL" "60064-3500" 0 0 0 0 2010 1800 "100 ABBOTT PARK ROAD" "ABBOTT PARK" "IL" "60064-3500" 0 0 0 0 2011 1800 "100 ABBOTT PARK ROAD" "ABBOTT PARK" "IL" "60064-3500" 0 0 0 0 2012 1800 "100 ABBOTT PARK ROAD" "ABBOTT PARK" "IL" "60064-3500" 0 0 0 0 2013 1800 "100 ABBOTT PARK ROAD" "ABBOTT PARK" "IL" "60064-3500" 0 0 0 0 2013 1800 "100 ABBOTT PARK ROAD" "ABBOTT PARK" "IL" "60064-3500" 0 0 0 0 2014 1800 "100 ABBOTT PARK ROAD" "ABBOTT PARK" "IL" "60064-3500" 0 0 0 0 2015 1800 "ONE HOLLOW LANE" "LAKE SUCCESS" "NY" "11042" 0 0 0 0 2009 2034 "ONE HOLLOW LANE" "LAKE SUCCESS" "NY" "11042" 0 0 0 0 2010 2034 "ONE HOLLOW LANE" "LAKE SUCCESS" "NY" "11042" 0 0 0 0 2011 2034 "4 TRI HARBOR COURT" "PORT WASHINGTON" "NY" "11050" 1 1 0 1 2012 2034 "4 TRI HARBOR COURT" "PORT WASHINGTON" "NY" "11050" 0 0 0 0 2013 2034 "4 TRI HARBOR COURT" "PORT WASHINGTON" "NY" "11050" 0 0 0 0 2014 2034 "4 TRI HARBOR COURT" "PORT WASHINGTON" "NY" "11050" 0 0 0 0 2015 2034 "4400 POST OAK PKWY STE 2700" "HOUSTON" "TX" "77027" 0 0 0 0 2009 2178 "4400 POST OAK PKWY STE 2700" "HOUSTON" "TX" "77027" 0 0 0 0 2010 2178 "4400 POST OAK PKWY STE 2700" "HOUSTON" "TX" "77027" 0 0 0 0 2011 2178 "4400 POST OAK PKWY STE 2700" "HOUSTON" "TX" "77027" 0 0 0 0 2012 2178 "17 S. BRIAR HOLLOW LN." "HOUSTON" "TX" "77027" 1 0 0 0 2013 2178 "17 S. BRIAR HOLLOW LN." "HOUSTON" "TX" "77027" 0 0 0 0 2014 2178 "17 S. BRIAR HOLLOW LN." "HOUSTON" "TX" "77027" 0 0 0 0 2015 2178 "ONE AMD PL" "SUNNYVALE" "CA" "94088-3453" 0 0 0 0 2009 2488 "ONE AMD PL" "SUNNYVALE" "CA" "94088-3453" 0 0 0 0 2010 2488 "ONE AMD PL" "SUNNYVALE" "CA" "94088-3453" 0 0 0 0 2011 2488 "ONE AMD PL" "SUNNYVALE" "CA" "94088-3453" 0 0 0 0 2012 2488 "ONE AMD PL" "SUNNYVALE" "CA" "94088-3453" 0 0 0 0 2013 2488 "ONE AMD PL" "SUNNYVALE" "CA" "94088-3453" 0 0 0 0 2014 2488 "ONE AMD PL" "SUNNYVALE" "CA" "94088-3453" 0 0 0 0 2015 2488 "6601 S. BERMUDA RD." "LAS VEGAS" "NV" "89119" 0 0 0 0 2009 2491 "6601 S. BERMUDA RD." "LAS VEGAS" "NV" "89119" 0 0 0 0 2010 2491 "6601 S. BERMUDA RD." "LAS VEGAS" "NV" "89119" 0 0 0 0 2011 2491 "6601 S. BERMUDA RD." "LAS VEGAS" "NV" "89119" 0 0 0 0 2012 2491 "6601 S. BERMUDA RD." "LAS VEGAS" "NV" "89119" 0 0 0 0 2013 2491 "6601 S. BERMUDA RD." "LAS VEGAS" "NV" "89119" 0 0 0 0 2014 2491 "6601 S. BERMUDA RD." "LAS VEGAS" "NV" "89119" 0 0 0 0 2014 2491 "7201 HAMILTON BLVD" "ALLENTOWN" "PA" "18195-1501" 0 0 0 0 2009 2969 "7201 HAMILTON BLVD" "ALLENTOWN" "PA" "18195-1501" 0 0 0 0 2010 2969 "7201 HAMILTON BLVD" "ALLENTOWN" "PA" "18195-1501" 0 0 0 0 2011 2969 "7201 HAMILTON BLVD" "ALLENTOWN" "PA" "18195-1501" 0 0 0 0 2012 2969 "7201 HAMILTON BLVD" "ALLENTOWN" "PA" "18195-1501" 0 0 0 0 2013 2969 "7201 HAMILTON BLVD" "ALLENTOWN" "PA" "18195-1501" 0 0 0 0 2014 2969 "7201 HAMILTON BLVD" "ALLENTOWN" "PA" "18195-1501" 0 0 0 0 2015 2969 "1925 W. FIELD COURT, SUITE 300" "LAKE FOREST" "IL" "60045" 0 0 0 0 2009 3116 "2500 MILLBROOK DRIVE" "BUFFALO GROVE" "IL" "60089" 1 1 0 1 2009 3116 "1925 W. FIELD COURT, SUITE 300" "LAKE FOREST" "IL" "60045" 1 1 0 1 2010 3116 "1925 W. FIELD COURT, SUITE 300" "LAKE FOREST" "IL" "60045" 0 0 0 0 2011 3116 "1925 W. FIELD COURT, SUITE 300" "LAKE FOREST" "IL" "60045" 0 0 0 0 2012 3116 "1925 W. FIELD COURT, SUITE 300" "LAKE FOREST" "IL" "60045" 0 0 0 0 2013 3116 "1925 W. FIELD COURT, SUITE 300" "LAKE FOREST" "IL" "60045" 0 0 0 0 2013 3116 "1925 W. FIELD COURT, SUITE 300" "LAKE FOREST" "IL" "60045" 0 0 0 0 2014 3116 "1925 W. FIELD COURT, SUITE 300" "LAKE FOREST" "IL" "60045" 0 0 0 0 2015 3116 "1925 W. FIELD COURT, SUITE 300" "LAKE FOREST" "IL" "60045" 0 0 0 0 2015 3116 "3120 FORRER STREET" "CINCINNATI" "OH" "45209" 0 0 0 0 2009 3197 "3120 FORRER STREET" "CINCINNATI" "OH" "45209" 0 0 0 0 2009 3197 "3120 FORRER STREET" "CINCINNATI" "OH" "45209" 0 0 0 0 2010 3197 "3120 FORRER STREET" "CINCINNATI" "OH" "45209" 0 0 0 0 2011 3197 "4625 RED BANK ROAD, SUITE 200" "CINCINNATI" "OH" "45227" 1 0 0 1 2012 3197 "4625 RED BANK ROAD, SUITE 200" "CINCINNATI" "OH" "45227" 0 0 0 0 2013 3197 "4625 RED BANK ROAD, SUITE 200" "CINCINNATI" "OH" "45227" 0 0 0 0 2014 3197 "4625 RED BANK ROAD, SUITE 200" "CINCINNATI" "OH" "45227" 0 0 0 0 2015 3197 "700 MILAM ST." "HOUSTON" "TX" "77002" 0 0 0 0 2009 3570 "700 MILAM ST." "HOUSTON" "TX" "77002" 0 0 0 0 2010 3570 "700 MILAM ST." "HOUSTON" "TX" "77002" 0 0 0 0 2011 3570 "700 MILAM ST." "HOUSTON" "TX" "77002" 0 0 0 0 2012 3570 "700 MILAM ST." "HOUSTON" "TX" "77002" 0 0 0 0 2012 3570 "700 MILAM ST." "HOUSTON" "TX" "77002" 0 0 0 0 2013 3570 "700 MILAM ST." "HOUSTON" "TX" "77002" 0 0 0 0 2013 3570 "700 MILAM ST." "HOUSTON" "TX" "77002" 0 0 0 0 2014 3570 "700 MILAM ST." "HOUSTON" "TX" "77002" 0 0 0 0 2015 3570 "800 CABIN HILL DRIVE" "GREENSBURG" "PA" "15601" 0 0 0 0 2009 3673 "800 CABIN HILL DRIVE" "GREENSBURG" "PA" "15601" 0 0 0 0 2010 3673 "800 CABIN HILL DRIVE" "GREENSBURG" "PA" "15601" 0 0 0 0 2011 3673 "20 SYLVAN ROAD" "WOBURN" "MA" "01801" 0 0 0 0 2009 4127 "20 SYLVAN ROAD" "WOBURN" "MA" "01801" 0 0 0 0 2009 4127 "20 SYLVAN ROAD" "WOBURN" "MA" "01801" 0 0 0 0 2010 4127 "20 SYLVAN ROAD" "WOBURN" "MA" "01801" 0 0 0 0 2010 4127 "20 SYLVAN ROAD" "WOBURN" "MA" "01801" 0 0 0 0 2011 4127 "20 SYLVAN ROAD" "WOBURN" "MA" "01801" 0 0 0 0 2011 4127 "20 SYLVAN ROAD" "WOBURN" "MA" "01801" 0 0 0 0 2012 4127 "20 SYLVAN ROAD" "WOBURN" "MA" "01801" 0 0 0 0 2012 4127 "20 SYLVAN ROAD" "WOBURN" "MA" "01801" 0 0 0 0 2013 4127 "20 SYLVAN ROAD" "WOBURN" "MA" "01801" 0 0 0 0 2013 4127 "20 SYLVAN ROAD" "WOBURN" "MA" "01801" 0 0 0 0 2014 4127 "20 SYLVAN ROAD" "WOBURN" "MA" "01801" 0 0 0 0 2014 4127 "20 SYLVAN ROAD" "WOBURN" "MA" "01801" 0 0 0 0 2015 4127 "20 SYLVAN ROAD" "WOBURN" "MA" "01801" 0 0 0 0 2015 4127 "7100 GRADE LN BLDG 4" "LOUISVILLE" "KY" "40232" 0 0 0 0 2009 4187 "7100 GRADE LN BLDG 4" "LOUISVILLE" "KY" "40232" 0 0 0 0 2010 4187 "7100 GRADE LN BLDG 4" "LOUISVILLE" "KY" "40232" 0 0 0 0 2011 4187 "7100 GRADE LN BLDG 4" "LOUISVILLE" "KY" "40232" 0 0 0 0 2011 4187 "7100 GRADE LN BLDG 4" "LOUISVILLE" "KY" "40232" 0 0 0 0 2012 4187 "7100 GRADE LN BLDG 4" "LOUISVILLE" "KY" "40232" 0 0 0 0 2013 4187 end
0 Response to Help with Summary stats dummy variable
Post a Comment