Desktop productivity for business analysts and programmers

percentage calculation

Reply
New Contributor nr1
New Contributor
Posts: 4

percentage calculation

Dear all,

 

I have a report with has

particulars                count

Success Transaction 100

Failure Transaction    20

Total Transaction    120 

 

My Requirement is i need a new column Percentage.

particulars             count  percentage

Sucess Transaction 100    83%

Failure Transaction 20       16%

Super Contributor
Posts: 460

Re: percentage calculation

Assuming you have your input data in a data set (and it's not really good practice to hold the total in with the disaggregate) then load the total in a macro variable and a simple data step will do the rest like so

 

data have;
	length particulars $30;
	infile datalines dlm=",";
	input particulars count;
	datalines;
Success Transaction,100
Failure Transaction,20
Total Transaction,120
;
run;

proc sql noprint;
	select count into :numtot
	from have
	where particulars="Total Transaction";
quit;

data want;
	set have(where=(particulars ne "Total Transaction"));
	percentage=(count/&numtot)*100;
run;

 

 

Super User
Posts: 20,222

Re: percentage calculation

proc freq data=have;

where particulars ne 'Total Transaction';

 

table particulars / out=want outpercent;

freq count ;

run;

Ask a Question
Discussion stats
  • 2 replies
  • 149 views
  • 0 likes
  • 3 in conversation