|
SAS_learner,
Yeah, from the limited problem description, it seems you could simple
rename '_type_' to 'trtgrp' and merge the proc means output directly
with the original data set. But even this may be more work than you need
(i.e. a proc sql with groups might suffice). If you provide your
original problem, ideally with some example data, we could be more
constructive with our suggestions.
Regards,
Scott Bucher
-----Original Message-----
From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of
data _null_,
Sent: Monday, July 07, 2008 5:21 PM
To: SAS-L@LISTSERV.UGA.EDU
Subject: Re: Sample 26140: Creating a new data set for each BY-Group in
a data set
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
> > >
> >
>
>
|
