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.
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!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.
Select SAS Training centers are offering in-person courses. View upcoming courses for: