So then it looks as if you need a blank between the data set names. That's what CATX() would give you.
Not really sure why people are so hard on you. It looks like you're just taking peoples code, run it and if there is an error you just post the problem again without first spending some time doing some investigation and RTM on you own. But let's assume it's just a case of being confused and not being on the level yet to help yourself.
Looking at the problem you had when you used catx(): "data CCD_1; setCD_11 CD_12 CD_13 CD_14 CD_15 CD_16 CD_17 CD_18 CD_19 CD_110; rename..." then the blank between the SET statement and the first data set was missing.
The reason for this is that the cats() function as used in the call execute code bit "execute(cats('data CCD_',put(j,8.),'; set ', names ,'; rename COL1=C;'));" removes all the leading and trailing blanks when concatenating the string and therefore the trailing blank in '; set ' gets removed. That's why it's not working.
I find it often easier to construct the command outside of the call execute() block and then pass in the whole command string as a single variable. This allows you to "putlog" your variable first so you can easily check what you want call execute() to process for you without having to run it.
Code like below should do (untested):
data want;
length cmd $ 300;
do j=1 to 11;
cmd='';
do i = 1 to 10;
cmd = catx(' ',cmd,cats("CD_",J,I));
end;
cmd='data CCD_'||put(j,8.)||'; set '||strip(names)||'; rename COL1=C; run;';
putlog cmd;
call execute(cmd);
end;
run;
Above shows you how you could create the command. You will now of course have to work a bit more in order to get what you've described in your initial post. This code only creates target data set "CCD_10".
