Date:         Mon, 25 Sep 2006 13:02:17 -0500
Reply-To:     SAS_learner <proccontents@GMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         SAS_learner <proccontents@GMAIL.COM>
Subject:      how to tell SAS to ignore macro option
Content-Type: text/plain; charset=ISO-8859-1; format=flowed

 hello guys,

I using a piece of code where I am doing same thing for two different
conditions. First I calculating totals for my header for all regions and
then I am doing same thing for different regions, As of now my code for

for all regions

 proc sort data = HEADER(where =(&population = '1' ))
out= V_AE(KEEP= PT TREAT_R ) nodupkey;
by PT TREAT_R;
run;
..........
..........


for different regions I am doing like this

%macro region(reg = );
proc sort data = HEADER(where =(&population = '1' and &reg = ))
out= V_AE(KEEP= PT TREAT_R ) nodupkey;
by PT TREAT_R;
run;
.......
............
%mend;
and I am calling this macro using

Data _Null_ ;
Set temp;
 Call Execute( '%nrstr( %region ( reg = '|| REGION||, 'nam  = '||reg|| '))'
) ;
Run ;


what I want to do is there way to tell SAS that if I do not supply anything
to the region then it should ignore the region and calculate for all the
regions like the code for the all regions
other wise it has to do for individual regions

thanks