I am trying to transform my data using sas so I can use it for other applications, my data is a list of all counties in Oregon and an ID number, here is an example:
County name ID
Baker County 21
Baker County 21
Baker County 45
Baker County 54
Brenton County 21
Brenton County 18
Brenton County 18
Brenton County 18
Brenton County 105
Brenton County 108
Coos county 21
Coos county 76
Coos county 76
Coos county 105
etc..
I want to put my data into this form:
18 21 45 54 76 105 108 etc...
Baker County 2 1 1
Brenton County 3 1 1 1
Coos County 1 1
etc...
Where i have a count for how many of those IDS are in each county, keep in mind that this is an example dataset and my dataset has about 500,000 rows with all counties and around 70 distinct IDs in total, so every county should have at least a few of every ID.
I am having trouble figuring out how to do this so any helps using sas or even if you have an idea of how to do it differently would be much appreciated. Thank you.