Date:         Thu, 28 Aug 2003 16:57:12 -0400
Reply-To:     "L. Bertolini" <bertolini.1@OSU.EDU>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         "L. Bertolini" <bertolini.1@OSU.EDU>
Organization: Ohio State University
Subject:      Re: Creating multiple datasets from one dataset
Content-Type: text/plain; charset=us-ascii; format=flowed

Another possibility, which may or may not be feasible and/or desirable,
depending on what you intend to do with the 37 datasets, is to
create a view for each:

E.g. (untested)

proc sql;
  create view ALB  as select * from master where x = 'ALB';
  create view GLUC as select * from master.where x='GLUC';
   . . .

run;

You could use the techniques, that previous respondents have
posted, to generate the SQL.

sas programmer wrote:

>Hi
>
>I have a dataset with a variable which has 37 distinctive values (i.e
>after doing a proc sort with nodupkey ).
>
>Each value has multiple observations.
>
>What i need to do is create 37 different datasets for each distinctive
>value of the variable
>
>
>example
>
>TEST
>
>ALB
>ALB
>GLUC
>GLUC
>RET
>RET
>WBC
>WBC
>WBC
>RBC
>RBC
>RBC
>
>The test variable above has  5 values if i need to create 5 datasets
>for each value how can i do that.
>
>SAS programmer
>