Hello, I am working on a data set flattened using proc transpose. The resulting set has 34 columns or two variables. I would like to concatenate these columns into two (one for each variable). I used the CATX function in this manner: data want; length Medication $200 Response $200; set have; Medication=catx(",", Medication1-Medication34); Response=catx(",", Response1-Response34); drop Medication1-Medication34 Response1-Response34; run; but it didn't work producing to variables with all blanks. No error and no warning. Any suggestions/tips on where I went wrong? Also, if I were to do the same thing with numeric variables, which concatenation function would be the best to use? Thank you!
... View more