Hello! I am trying to do a PROC SQL on two separate tables, however, I am missing a word within a variable so they cannot be merged. I need to add the text " County" exactly as shown to the end of my county variable, followed by ", Colorado". I tried CATX which added " Colorado" following a comma delimiter, but cannot add county. It must appear exactly as shown in the Goal example, with spaces included. Ideally, I'd like to concatenate my CT and county variable separated by a comma, and just add "County, Colorado" to the end, but the CATX function interrupts county and the text with another new comma. Goal: Census Tract 1, Chaffee County, Colorado Output so far: Census Tract 1, Chaffee, Colorado 'Census Tract 1' comes from the CT variable, and 'Chaffee' comes from the county variable. Code so far: CT_NEW = CATX(', ', CT, county, 'Colorado'); Run; I figured concatenating to be the best solution for this problem, but cannot seem to make it work. Thank you!
... View more