I tried to look around the community and other resources for an answer on this topic, but failed to locate an answer on this specific question in SAS Visual Analytics. The issue we're seeing is related to creating a zip code geo-variable on SAS Visual Analytics. Currently, we have several separate datasets that contain Zip Code columns, all of which seem to incorrectly match the shape-file when converting them into a geo-variable from a character variable. Here is some background information on the data: Data is imported into CAS via ODBC connection to Database. The column is imported as a character, not as a measure. This means that all values retain the leading zero into SAS VA. (See attached photo - "values not matched" section of edit prompt) Our shape file correctly maps a vast majority, if not all zip codes that do not have leading 0's. After investigating, we are certain it is the leading zeros. The proportion of non-matched values are always consistent with the proportion of zip codes having a leading zero. It's also been observed that Puerto Rico seems to have issues displaying zip codes, as well as New Jersey. An example would be a hierarchy that drills down to Bergen County in NJ, but no zip codes are displayed due to leading zeros in each zip code for that county. Our best hypothesis: We imported the shape file incorrectly, which led to those values not being matched in any case due to an improper column format in the shape file. The Zip Code values need to be in a proper format before conversion to Geo-variable.
... View more