Date: Tue, 21 Apr 2009 09:46:01 -0400
Reply-To: Stephane COLAS <scolas@DATAMETRIC.FR>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: Stephane COLAS <scolas@DATAMETRIC.FR>
Subject: Proc report : ratio in an across grouping
Content-Type: text/plain; charset=ISO-8859-1
Hi
With :
data test;
do country = "A","B","C";
do region =1,2,3,4,5;
do year=1,2;
do family="F1","F2";
turnover = ranuni(0); output;
end;end;
end;end;
run;
I check the results with that, you can see the turnover of each year
inside each family.
proc report data=test;
column country family,year,(turnover);
DEFINE country / group;
DEFINE year / across;
DEFINE family / across;
DEFINE turnover / sum;
run;
And now I'd like to add the % growth between year2 a and year1 inside each
family and I'm lost...
Stéphane.
|