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;
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.