Hi there, I have 2 columns that I want to merge into 1 column. Each column has 40,000 obs in it, all of which I want to keep. I want to merge RefPer and Quid into RefQuid. All of Refper's obs are in this format: 201911, 201912 etc. All of Quid's obs are in this format: Q12345. So the obs in RefQuid should all look something like this: 201911Q12345 I have tried several variations of the following: DATA finalval RefQuid = CATS(RefPer, Quid); run; I keep recieving this error message: ERROR 22-322: Syntax error, expecting one of the following: A name, a quoted string, (, /. ;. _data_ _last_, _null. What am I doing wrong? Is there another way to merge two columns together? Thank you.
... View more