I have data for 353 local authorities over 20 quarters and one of my variables is a dummy variable that takes the value 1 or zero if that local authority is a unitary authority or not and this does not change over time.
Is there a way to easily count how many separate local authorities are unitary? I predict around 55 are unitary but as the data is in long format this is tedious to count. All of the local authorities below are unitary, but for many in my sample this dummy takes the value 0. 'acode' is just a numeric identity for each local authority.
Code:
* Example generated by -dataex-. To install: ssc install dataex clear input str43 name float acode byte unitarydummy "Hartlepool Borough Council" 6000001 1 "Hartlepool Borough Council" 6000001 1 "Hartlepool Borough Council" 6000001 1 "Hartlepool Borough Council" 6000001 1 "Hartlepool Borough Council" 6000001 1 "Hartlepool Borough Council" 6000001 1 "Hartlepool Borough Council" 6000001 1 "Hartlepool Borough Council" 6000001 1 "Hartlepool Borough Council" 6000001 1 "Hartlepool Borough Council" 6000001 1 "Hartlepool Borough Council" 6000001 1 "Hartlepool Borough Council" 6000001 1 "Hartlepool Borough Council" 6000001 1 "Hartlepool Borough Council" 6000001 1 "Hartlepool Borough Council" 6000001 1 "Hartlepool Borough Council" 6000001 1 "Hartlepool Borough Council" 6000001 1 "Hartlepool Borough Council" 6000001 1 "Hartlepool Borough Council" 6000001 1 "Hartlepool Borough Council" 6000001 1 "Middlesbrough Borough Council" 6000002 1 "Middlesbrough Borough Council" 6000002 1 "Middlesbrough Borough Council" 6000002 1 "Middlesbrough Borough Council" 6000002 1 "Middlesbrough Borough Council" 6000002 1 "Middlesbrough Borough Council" 6000002 1 "Middlesbrough Borough Council" 6000002 1 "Middlesbrough Borough Council" 6000002 1 "Middlesbrough Borough Council" 6000002 1 "Middlesbrough Borough Council" 6000002 1 "Middlesbrough Borough Council" 6000002 1 "Middlesbrough Borough Council" 6000002 1 "Middlesbrough Borough Council" 6000002 1 "Middlesbrough Borough Council" 6000002 1 "Middlesbrough Borough Council" 6000002 1 "Middlesbrough Borough Council" 6000002 1 "Middlesbrough Borough Council" 6000002 1 "Middlesbrough Borough Council" 6000002 1 "Middlesbrough Borough Council" 6000002 1 "Middlesbrough Borough Council" 6000002 1 "Redcar and Cleveland Borough Council" 6000003 1 "Redcar and Cleveland Borough Council" 6000003 1 "Redcar and Cleveland Borough Council" 6000003 1 "Redcar and Cleveland Borough Council" 6000003 1 "Redcar and Cleveland Borough Council" 6000003 1 "Redcar and Cleveland Borough Council" 6000003 1 "Redcar and Cleveland Borough Council" 6000003 1 "Redcar and Cleveland Borough Council" 6000003 1 "Redcar and Cleveland Borough Council" 6000003 1 "Redcar and Cleveland Borough Council" 6000003 1 "Redcar and Cleveland Borough Council" 6000003 1 "Redcar and Cleveland Borough Council" 6000003 1 "Redcar and Cleveland Borough Council" 6000003 1 "Redcar and Cleveland Borough Council" 6000003 1 "Redcar and Cleveland Borough Council" 6000003 1 "Redcar and Cleveland Borough Council" 6000003 1 "Redcar and Cleveland Borough Council" 6000003 1 "Redcar and Cleveland Borough Council" 6000003 1 "Redcar and Cleveland Borough Council" 6000003 1 "Redcar and Cleveland Borough Council" 6000003 1 "Stockton-on-Tees Borough Council" 6000004 1 "Stockton-on-Tees Borough Council" 6000004 1 "Stockton-on-Tees Borough Council" 6000004 1 "Stockton-on-Tees Borough Council" 6000004 1 "Stockton-on-Tees Borough Council" 6000004 1 "Stockton-on-Tees Borough Council" 6000004 1 "Stockton-on-Tees Borough Council" 6000004 1 "Stockton-on-Tees Borough Council" 6000004 1 "Stockton-on-Tees Borough Council" 6000004 1 "Stockton-on-Tees Borough Council" 6000004 1 "Stockton-on-Tees Borough Council" 6000004 1 "Stockton-on-Tees Borough Council" 6000004 1 "Stockton-on-Tees Borough Council" 6000004 1 "Stockton-on-Tees Borough Council" 6000004 1 "Stockton-on-Tees Borough Council" 6000004 1 "Stockton-on-Tees Borough Council" 6000004 1 "Stockton-on-Tees Borough Council" 6000004 1 "Stockton-on-Tees Borough Council" 6000004 1 "Stockton-on-Tees Borough Council" 6000004 1 "Stockton-on-Tees Borough Council" 6000004 1 "Darlington Borough Council" 6000005 1 "Darlington Borough Council" 6000005 1 "Darlington Borough Council" 6000005 1 "Darlington Borough Council" 6000005 1 "Darlington Borough Council" 6000005 1 "Darlington Borough Council" 6000005 1 "Darlington Borough Council" 6000005 1 "Darlington Borough Council" 6000005 1 "Darlington Borough Council" 6000005 1 "Darlington Borough Council" 6000005 1 "Darlington Borough Council" 6000005 1 "Darlington Borough Council" 6000005 1 "Darlington Borough Council" 6000005 1 "Darlington Borough Council" 6000005 1 "Darlington Borough Council" 6000005 1 "Darlington Borough Council" 6000005 1 "Darlington Borough Council" 6000005 1 "Darlington Borough Council" 6000005 1 "Darlington Borough Council" 6000005 1 "Darlington Borough Council" 6000005 1 end
0 Response to Count how many units have the dummy variable=1
Post a Comment