Hi everyone, I have a data set in excel that has Owner City, Owner state, and owner zip in separate columns. I needed to combine these 3 columns into one with a comma separating owner city from owner state and then a space in between owner state and owner zip. Here is the code I have. SAS has correctly combined all columns into 1, which is named combined. Owner city is separated from owner state with a comma, but owner state is not separated from owner zip. This is an example of what is coming back to me. Augusta, GA30909. I need it to look like Augusta, GA 30909. Thank you to anyone willing to help!! data aik.props_new1; set aik.props_news; combined= cats(Owner_City, ' , ' Owner_State, ' ' , Owner_Zip); run;
... View more