Date:         Wed, 5 Jul 2006 14:20:29 -0400
Reply-To:     SUBSCRIBE SAS-L Chandra Gadde <ddraj2015@GMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         SUBSCRIBE SAS-L Chandra Gadde <ddraj2015@GMAIL.COM>
Subject:      Re: Create dataset names from variable values
Comments: To: Toby Dunn <tobydunn@HOTMAIL.COM>

Here is another way..

data one;
input ID Region $ Reg_ID;
cards;
01 North 1
02 North 1
03 South 2
04 South 2
05 East 3
06 East 3
07 West 4
08 West 4
03 West 4
04 West 6
;
run;

%macro mymacro(dsn= );
data &dsn;
 set one (where = (Region = "&dsn"));
run;
%mend mymacro;

%mymacro(dsn=North);
%mymacro(dsn=South);
%mymacro(dsn=East);
%mymacro(dsn=West);

Gadde