topic Re: Proc Report percentgae of column based on column total in SAS Enterprise Guide

Proc Report percentgae of column based on column total

DME790 — Wed, 13 Dec 2017 01:06:18 GMT

Hi All,

I need to calculate the percentage of each an observation within that variable.

I have this cade at the moment


data test;
	Input QUEUE_CD $ Bay Network;
	Datalines;
ABS 1 22949
ACD 1 3767
ACE 2 967
ACR 18 20513
ADV 5 92382
ALD 1 1764
ALE 17 13243
ALY 2 5128
CCB 1 25006
CHK 3295 25129

;
Run;


Proc Report data=test;
	Column queue_cd Bay Network BayPercent;
	Define Queue_CD / Display 'Queue';
		Define Bay / Display 'Baylink' Analysis sum f=comma9.;
		Define Network / Display 'Network' Analysis sum f=comma9.0;
		Define BayPercent / Computed 'Bay Percent of Network' f=percent9.2;
			Compute BayPercent;
				BayPercent = Bay.sum / Network.sum;
					Endcomp;
		Rbreak after / summarize;
RUN;

which gives me the output of Need to add the Bay Percent into the Proc Report

Any help appreciated.

Cheers

Dean

Re: Proc Report percentgae of column based on column total

RM6 — Wed, 13 Dec 2017 04:02:55 GMT

a compute block to get the total of bay before all the computation will suffice


Proc Report data=test;
	Column queue_cd Bay BayPct Network BayPercent;
	Define Queue_CD / Display 'Queue';
		Define Bay / Display 'Baylink' Analysis sum f=comma9.;
		Define BayPct / Computed 'Bay Percent' f=percent9.2;
		Define Network / Display 'Network' Analysis sum f=comma9.0;
		Define BayPercent / Computed 'Bay Percent of Network' f=percent9.2;
			
			 compute  before; 
				 Bay_tot = Bay.sum; 
				 endcomp;

			Compute BayPct;
				BayPct = Bay.sum / Bay_tot;
					Endcomp;
			Compute BayPercent;
				BayPercent = Bay.sum / Network.sum;
					Endcomp;
		Rbreak after / summarize;
RUN;

Re: Proc Report percentgae of column based on column total

Ksharp — Wed, 13 Dec 2017 12:34:38 GMT


data test;
	Input QUEUE_CD $ Bay Network;
	Datalines;
ABS 1 22949
ACD 1 3767
ACE 2 967
ACR 18 20513
ADV 5 92382
ALD 1 1764
ALE 17 13243
ALY 2 5128
CCB 1 25006
CHK 3295 25129

;
Run;


Proc Report data=test nowd;
	Column queue_cd Bay Bay_Percent Network BayPercent;
	Define Queue_CD / Display 'Queue';
		Define Bay / Display 'Baylink' Analysis sum f=comma9.;
		Define Bay_Percent / Computed 'Bay Percent' f=percent9.2;

		Define Network / Display 'Network' Analysis sum f=comma9.0;
		Define BayPercent / Computed 'Bay Percent of Network' f=percent9.2;
			Compute BayPercent;
				BayPercent = Bay.sum / Network.sum;
			Endcomp;

			compute before;
             sum=bay.sum;
			endcomp;
			Compute Bay_Percent;
				Bay_Percent = Bay.sum / sum;
			Endcomp;

		Rbreak after / summarize;
RUN;