Date:         Mon, 2 Nov 2009 14:26:59 -0500
Reply-To:     SAS Swamy <sasswamy@GMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         SAS Swamy <sasswamy@GMAIL.COM>
Subject:      WHERE Statement - Variable

Hello,

I understand about the WHERE statement.
Can someone please help with the code  , how to store the value to a
variable based on a WHERE condition

proc print data=TEST_DATA1;
where vaccode = 'test';
run;

proc print data=TEST_DATA2;
where ELIG_TYPE = 'P';
run;

I am able to get the results with the above condition , I need to store
the value to a variable and calculate the percentage from the overall
count

for e-g

Total = 600 ( overall total )
test  = 22  ( only code = 'test' )
percentage 3.66

Thanks,
- swamy.