topic Re: percentage calculation in SAS Enterprise Guide

percentage calculation

nr1 — Sat, 04 Nov 2017 07:47:27 GMT

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%

Re: percentage calculation

ChrisBrooks — Sat, 04 Nov 2017 10:24:49 GMT

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;

Re: percentage calculation

Reeza — Sat, 04 Nov 2017 15:55:58 GMT

proc freq data=have;

where particulars ne 'Total Transaction';

table particulars / out=want outpercent;

freq count ;

run;