Date:         Tue, 8 Jul 2008 09:31:23 -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:  <7367b4e20807071421s7cdc2d31v4f979e6c4684011b@mail.gmail.com>
Content-Type: text/plain; charset=ISO-8859-1

Hello all,

Thank you everybody for the help with the macro , as per your suggestions I
would write back to L with the data and macro I am using to show why I want
to do this the way I am doing

thank you all



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

> I am not convinced that splitting data just to put it back together
> later is a good idea.
>
> On 7/7/08, SAS_learner <proccontents@gmail.com> wrote:
> > 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
> > > >
> > >
> >
> >
>