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.
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
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.