proc transpose want to keep format

[kritima]

Dear all,

I have a question .

I have one dataset with numeric format. I use transpose and the format have not same as original.

Any suggestion?

data input;
set data_plot;
     format all_cid pass fail comma22.0 fail_rate goal comma22.2;

label fail_rate = Fail Rate(%);
label all_cid = Total;
label pass = Pass;
label fail = Fail;
label goal = goal;

run;

proc transpose data=input out=output (drop = _NAME_);
id xaxis ;
var all_cid pass fail fail_rate goal;
run;

i attach my input file and output file which i want to see

this is the current result which is wrong

[Reeza]

A column in SAS can only have one format, numeric or percent. 

You can convert the values or character using a PUT statement and apply the format of choice. 

[Reeza]

A column in SAS can only have one format, numeric or percent. 

You can convert the values or character using a PUT statement and apply the format of choice. 

[Ksharp · Accepted solution]

Or you could use PROC REPORT + CALL DEFINE()