Date:         Thu, 28 Apr 2011 09:23:00 -0500
Reply-To:     SAS_learner <proccontents@GMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         SAS_learner <proccontents@GMAIL.COM>
Subject:      Re: Proc Report By variable problem
Comments: To: toby dunn <tobydunn@hotmail.com>
In-Reply-To:  <BLU152-w565BD2D4B16E64F230BF2ADE9B0@phx.gbl>
Content-Type: text/plain; charset=ISO-8859-1

Yeup Toby , It worked like magic

thanks for quick response

On Thu, Apr 28, 2011 at 9:12 AM, toby dunn <tobydunn@hotmail.com> wrote:

>  If your data is already sorted in the correct order but not in ascii sort
> order:
>
> by lbtest trt notsorted ;
>
>
>
> Toby Dunn
>
>
> "I'm a hell bent 100% Texan til I die"
>
> "Don't touch my Willie, I don't know you that well"
>
>
>
>
> > Date: Thu, 28 Apr 2011 09:06:03 -0500
> > From: proccontents@GMAIL.COM
> > Subject: Proc Report By variable problem
> > To: SAS-L@LISTSERV.UGA.EDU
>
> >
> > Hello all
> >
> >
> > my dataset is
> > Lbtest TRT TRTSORT
> > CCP Placebo 1
> > CCP LY 1 mg 2
> > CCP LY 3 mg 3
> > CCP LY 10 mg 4
> > CCP LY 30 mg 5
> > CCP LY 60 mg 6
> > CCP LY 120 mg 7
> >
> > I am creating a report with Lbtest and Trt as header . The problem is
> that
> > I say something like
> >
> > proc report data=all nocenter split='|' nowd headline missing spacing=0;
> > column Usubjid col2 anti_CCP RF_Plus mtxdose predfl hydroxfl dmardfl;
> > by lbtest trt ;
> >
> >
> > * title '#byval (lbtest) and (trt)';
> > compute before _page_/left;
> > line "Demographs Listings" @118 "&systime &sysdate9";
> > line "Randamization Population" @129 "&status";
> > line "Protocol H_YYYYYY";
> > line " ";
> > line 132*"-";
> > line " ";
> > endcomp;
> > compute after _page_/left;
> > line 132*"-";
> > line "";
> > line "Report: &out_path./l_dem_base_line.rtf";
> > endcomp;
> > run;
> >
> > If I use the above code in the report I am getting the 10 mg first and
> then
> > remaining . Is there a way bring the the Placebo first and other other
> > groups and use it in proc report
> >
> > Lab Test Name=CYCLIC CITRULLINATED PEPTIDE IGG ANTIBODY (CCP)
> > Treatment=LY2xxxxx 10mg
>