@knveraraju91 wrote:
Dear,
I have two questions in my pgm below. First, the data step 'one' is giving me errors when i insert in the macro. Second, in the data step three, depends on how many "treat" variable values i need calculate character variables for the "value" variables. Please suggest. Thank you.
output needed:
a1 b1 c1
100 200 300
The output of proc transpose looks very much like the required output, only thing to do is dropping the variable _name_. Why do you think that you need macro code at all?
EDIT: Wait, i see you need the values of "treat" as names for the transposed columns. Try:
proc transpose data=one out=two(drop=_name_);
var value;
id treat;
run;
... View more