Date:         Mon, 7 Jul 2008 16:53:08 -0400
Reply-To:     SAS_learner <proccontents@GMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         SAS_learner <proccontents@GMAIL.COM>
Subject:      Re: Sample 26140: Creating a new data set for each BY-Group in a
              data set
Comments: To: "data _null_," <datanull@gmail.com>
In-Reply-To:  <7367b4e20807071348o71fbf3f8qb31e917d4425b862@mail.gmail.com>
Content-Type: text/plain; charset=ISO-8859-1

Hello  data_null_ ,

Yes I would like to separate the big dataset that is coming out of either
Proc means (in my case after doing  _type_ = 3)  I want to cut the main
dataset into the number of datasets (by treatments ) and need to merge them
back to get into the table

thanks


On Mon, Jul 7, 2008 at 4:48 PM, data _null_, <datanull@gmail.com> wrote:

> Why do you think you need to do this?  Unless you need to send the
> data to separate individuals or locations it is surely better to keep
> all the data together.
>
> On 7/7/08, SAS_learner <proccontents@gmail.com> wrote:
> > hello guys,
> >
> > Similar to Sample 26140 (http://support.sas.com/kb/26/140.html)   in my
> > dataset there can be n different treatments ( Numeric) and I want to make
> > them into different datasets.Some how It does not  allowing me to do, I
> am
> > not sure what I am doing wrong
> > This is when I changed the trtgrp1  to character (Which I do not want to
> )
> > but still no luck
> >
> > Data aa_trans;
> >   set aa_trans;
> >   Trtgrp2 =  trtgrp1*1  /*It was not converting straight away */ ;
> >  Trtgrp3 =  Trim(Left((Put(Input(Trtgrp2 ,best12.),$4.))) ;
> > Run;
> >
> > %macro
> > break(byval);
> >
> >   data &byval;
> >      set aa_trans(where=(trtgrp3="&byval"));
> >
> > run;
> >
> > %mend;
> >
> > Proc Sort data =  aa_trans ;;
> > By trtgrp1;
> > Run;
> > data _null_;
> >        Set  aa_trans ;
> >    By trtgrp1 ;
> >    if First.trtgrp1 then
> > Call Execute(%nrstr('%break(!!trim(trtgrp1)!!')'));
> > Run;
> > Quit;
> >
> > Even after changing it to character it is still not working any Ideas ??
> > Thanks for the help
> >
>