3 weeks ago
I’m trying to understand http://support.sas.com/kb/61/209.html.
I was able to work with the counties on the example interface. Although the interface has an obvious bug of showing numbers next to the counties. I’d like to display just the counties. My data table includes student admission data with just the county name, no numbers. Where as the sample data has county plus the odd number code. So when I used my data with the tables from the documentation only Washington showed up. I’m not sure why Washington showed up. Oddly when I removed the (number) or the last eight characters of US_counties1, I don’t notice a difference. Maybe I need to register the updated table in some way or I’m doing the steps in Option two wrong. My data doesn’t include an ID column. I’m not sure what that is for in the steps so I stopped at step 4.
Change the Geography role on the geo region map to ID. “
3 weeks ago
Can't help with VA part but that odd number code you mention in "Where as the sample data has county plus the odd number code." is a FIPS county identifier. The first two characters are the FIPS State code and the following 3 are the county identifier within the state.
These codes are not odd, they have been around for a very long time. Long enough that SAS has several functions that use or return them: STFIPS, FIPNAME, FIPNAMEL, FIPSTATE, STATENAME and STNAMEL. Notice that the ID column also uses the same 5 character code
Does your data have state and county variables? If it turns out that you need the 5 character FIPS you can use the SASHELP.ZIPCODE data set to get the county fip, numeric variable County in the data set along with the STFIPS function to create it.