percentage calculation

[nr1]

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%

[ChrisBrooks]

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;

[Reeza]

proc freq data=have;

where particulars ne 'Total Transaction';

table particulars / out=want outpercent;

freq count ;

run;