Please clarify your question. I assume the second part is your have data? If so then your first example is not a transpose, you are just moving some data across. Unfortunately that example data does not match the have data either, ok category 0 = count 100, but where do you get category 0 for the next row being 200 as it is 700 in your example? Post exact data, as a datastep, and an example of the reuquired output for that data. As an example something like this gets near, but with the differences between the two given data doesn't match:
data have;
input vars $ num count x;
datalines;
Var_1 0 100 3100
Var_1 1 200 3200
Var_1 2 300 3300
Var_1 3 400 3400
Var_1 4 500 3500
Var_1 5 600 3600
Var_2 0 700 3700
Var_2 1 800 3800
Var_2 2 900 3900
Var_2 3 1000 4000
Var_2 4 1100 4100
Var_2 5 1200 4200
;
run;
data want (drop=vars num);
set have;
array var_{5} 8.;
select(vars);
when ('Var_1') var_{1}=num;
when ('Var_2') var_{2}=num;
when ('Var_3') var_{3}=num;
when ('Var_4') var_{4}=num;
when ('Var_5') var_{5}=num;
otherwise;
end;
run;
