DATA Step, Macro, Functions and more

percent format

Accepted Solution Solved
Reply
Frequent Contributor
Posts: 114
Accepted Solution

percent format

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


Accepted Solutions
Solution
‎06-29-2017 09:00 AM
Super User
Posts: 6,946

Re: percent format

Add decimals to the format:

data a1;
set a;
format pct percent10.1;
pct=cost/overall;
run;
---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers

View solution in original post


All Replies
Solution
‎06-29-2017 09:00 AM
Super User
Posts: 6,946

Re: percent format

Add decimals to the format:

data a1;
set a;
format pct percent10.1;
pct=cost/overall;
run;
---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
Super User
Posts: 9,682

Re: percent format

  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;

☑ This topic is SOLVED.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 101 views
  • 0 likes
  • 3 in conversation