Thank very much for your quick response. Here is the reason why I am
doing this. We did a survey by two methods. One is from online and
another part is by paper. For paper part, they scanned each answers
into four numbers and I need to translate the 4 numbers back to the
original meanings. Then I could merge the two parts together.
Just now, I tried your codes and it works for my example. However, my
original part didn't work. I changed the dataset name and I don't need
to change the work directory since it is there.
I thought my original logic is very similar to yours. However, the
weird thing is my results always only show length four.
Here is my codes:
Proc contents data=Pap_New2 out=temp (keep=name type) ;
proc sql noprint;
into :charvar separated by ' '
%put NOTE: name=&charvar;
data Pap_New3 (drop=i);
length &charvar $50;
array a(*) _character_;
do i = 1 to dim(a);
I really don't understand what's the problem here. It is so weired...