Great. I have tried that but am having problems, getting errors with converting numerical to characters using the put function. Could you suggest how to do that? I tried the following below, but it will not let me simply format to $8. It wants a specific format, such as Dollar10. etc, which is not appropriate here. I am still learning SAS, and am relatively new, so bare with me a bit. Thanks. Data Survey2 ; Set Learn.Survey2 (Rename = (Ques1= NumQues1 Ques2= NumQues2 Ques3= NumQues3 Ques4= NumQues4 Ques5= NumQues5)) ; Proc Format ; Value QuesFmt $ 8. ; /*THIS GENERATES AN ERROR*/ run ; Ques1 = put(NumQues1, QuesFmt) ; Ques2 = put(NumQues2, QuesFmt) ; Ques3 = put(NumQues3, QuesFmt) ; Ques4 = put(NumQues4, QuesFmt) ; Ques5 = put(NumQues5, QuesFmt) ; Array QuesNum(5) $ (Ques1-Ques5) ; do i = 1 to 5(QuesNum) ; QuesNum{i} = translate(QuesNum{i},'54321','12345') ; end ; drop = i NumQues1 NumQues2 NumQues3 NumQues4 NumQues5; run ;
... View more