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 > > > > > > >