Date:         Thu, 28 Apr 2011 09:06:03 -0500
Reply-To:     SAS_learner <proccontents@GMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         SAS_learner <proccontents@GMAIL.COM>
Subject:      Proc Report By variable problem
Content-Type: text/plain; charset=ISO-8859-1

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