TRANWRD

[Guerraje · Accepted solution]

OKAY! it looks great. I finally have the data long instead of wide and have dropped the word county from all of the names. The last thing I am unsure of how to add is how to drop the underscore that is inside some of the county names such as "RIO_GRANDE"

[Reeza]

Use the TRANSLATE function to convert the underscore to a space.
https://documentation.sas.com/doc/en/vdmmlcdc/8.1/lefunctionsref/p05ww22zp7lcg3n1bjk7v93tscyo.htm