Hi SAS Experts,
Am tryng to get the percentage, but it is rounding up to the nearesr whole value i dont want to get the whole vale. Below is my code and data.
data a;
input cost overall;
datalines;
10000 260000
20400 560970
;
run;
data a1;
set a;
format pct percent10.;
pct=cost/overall;
run;
desired result.
10000 260000 3.8
20400 560970 3.6
Thanks & regards,
Sanjay
Add decimals to the format:
data a1;
set a;
format pct percent10.1;
pct=cost/overall;
run;
Add decimals to the format:
data a1;
set a;
format pct percent10.1;
pct=cost/overall;
run;
If you don't want get rounded, try PROC FORMAT. data a; input cost overall; datalines; 10000 260000 20400 560970 ; run; proc format; picture fmt low-high='00.9%' (multi=1000); run; data a1; set a; format pct fmt.; pct=cost/overall; run;
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.