topic PROC TABULATE in SAS Procedures

PROC TABULATE

Jaheuk — Thu, 02 Jan 2020 08:47:19 GMT

dear all,

using <colpctsum> I get the percentage of a column with amounts.

great but HOW do I get tha value itself ( amount * colpctsum ) ??

Re: PROC TABULATE

ed_sas_member — Thu, 02 Jan 2020 09:05:09 GMT

Hi @Jaheuk

Could you please provide some sample data as well as the desired output?

Thank you!

Re: PROC TABULATE

Jaheuk — Thu, 02 Jan 2020 11:04:29 GMT

55,8 % of amount 984.555 = 549.283 euro, so an extra column with this value

I googled a lot, but I think it is not possible to add a calculated column

Re: PROC TABULATE

Kurt_Bremser — Thu, 02 Jan 2020 11:35:12 GMT

984.555 IS already 55,8% of 1.764.661, so applying the percentage again makes no sense.

Re: PROC TABULATE

ed_sas_member — Thu, 02 Jan 2020 11:43:17 GMT

Hi @Jaheuk

Totally agree with @Kurt_Bremser, 984.555 IS already 55,8% of 1.764.661.

But if you think that makes sense in your context, you can try this to get your report:

data have;
	input amount;
	datalines;
984555
109331
2933
378
620125
46038
1011
291
;
run;

proc sql;
	create table want as
	select a.amount,
		   a.amount / b.total as percent format=percent8.1,
		   a.amount * calculated percent as value
	from have as a, (select sum(amount) as total from have) as b;
quit;

proc print data=want noobs;
	sum amount percent value;
run;