Sample 68286: SAS® Visual Analytics on SAS® Viya® geographic tables for U.S. county geographic data providers
SAS Visual Analytics on SAS Viya does not include geographic data at the U.S county level. This Sample note provides a SAS data table (.sas7bdat) for use with geographic data providers (custom geographic polygons) to implement U.S. counties using the state and county Federal Information Processing System (FIPS) code in the county ID.
To use the data from this Sample note in your environment, download the appropriate version of the data from the Downloads tab. Next, import the data into SAS® Cloud Analytic Services (CAS) and then define a geographic data provider within the geography data item dialog box. For more information, see the Working with Geography Data Items section in the SAS Visual Analytics documentation that includes information about creating a geographic data provider.
US_COUNTIES Data Details:
The format for U.S. county ID in the US_COUNTIES geographic data provided is US-00999, where ‘00’ is the state FIPS code and ‘999’ is the county FIPS code.
Here is an example of the US_COUNTIES table showing U.S.county ID as US-<StateFIPS><CountyFIPS>. The table includes two different columns for county names, as well as state name and abbreviation.

US_COUNTIES Table Contents:
Observations 103174
Encoding utf-8 Unicode (UTF-8)
Variable Type Len Label
centroid_X Num 8 Centroid Longitude
centroid_Y Num 8 Centroid Latitude
County_Name1 Char 29
County_Name2 Char 30
DENSITY Num 4
ID Char 15
SEGMENT Num 8
sequence Num 8
state Char 25
State_Abbr Char 2
X Num 8
Y Num 8
These sample files and code examples are provided by SAS Institute
Inc. "as is" without warranty of any kind, either express or implied, including
but not limited to the implied warranties of merchantability and fitness for a
particular purpose. Recipients acknowledge and agree that SAS Institute shall
not be liable for any damages whatsoever arising out of their use of this material.
In addition, SAS Institute will provide no support for the materials contained herein.
These sample files and code examples are provided by SAS Institute
Inc. "as is" without warranty of any kind, either express or implied, including
but not limited to the implied warranties of merchantability and fitness for a
particular purpose. Recipients acknowledge and agree that SAS Institute shall
not be liable for any damages whatsoever arising out of their use of this material.
In addition, SAS Institute will provide no support for the materials contained herein.
SAS® Visual Analytics on SAS Viya geographic tables for U.S. county geographic data providers (custom polygons).
| Date Modified: | 2021-08-25 09:10:50 |
| Date Created: | 2021-08-19 20:28:21 |
Operating System and Release Information
| SAS System | SAS Visual Analytics (on SAS Viya) | Cloud Foundry | 8.3.1 | | Viya | |
| Linux for x64 | 8.3.1 | | Viya | |
| Microsoft® Windows® for x64 | 8.3.1 | | Viya | |