topic proc transpose want to keep format in SAS Programming

proc transpose want to keep format

kritima — Fri, 09 Sep 2016 12:00:32 GMT

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 — Fri, 09 Sep 2016 12:28:22 GMT

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 — Fri, 09 Sep 2016 12:28:23 GMT

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 — Sat, 10 Sep 2016 03:26:57 GMT

Or you could use PROC REPORT + CALL DEFINE()