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
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.
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.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.