Value if _page_ value into another value??

Discussion in 'SAS (Statistical Analysis Software)' started by SAS_learner, Dec 4, 2007.

  1. SAS_learner

    SAS_learner Guest

    I am trying to get my Mtitle and Footer with in the dataset Instead of
    getting them as title and Footnotes the reason My boss requested (there is
    Other reason ) For that I am doing something like this

    My Problem is trying to get Titles in the Dataset, When I trying something
    like this The second title is Over writing the First one. But I need my
    Report some thing like this . Is there is something similar to *compute
    before _page_ or can I have value of _page_ into some other value.*

    MYPHARMA
    Page 1 of 3 .
    PEN 20007


    Table 14.1.4
    Demographic
    Characteristics
    Modified Intent-To-Treat
    Subjects

    /* CREATE REPORT */
    ods rtf file = "&dir1.T14_1_2_MXXX_1303.RTF" style=autoexec;
    title "" ;
    Footnote"" ;
    proc report data= &Program. nowd missing split='?'
    style(header)=[protectspecialchars=off];
    columns ("&border" (page _userFoot _PageNo _lastLine Sec Row Col0 Col2_1
    Col2_1 Col2_2 Col2_3 Col2_4 ));
    define _userFoot / order Noprint ;
    define _PageNo / order Noprint ;
    define _lastLine / order Noprint ;
    define page/ order order=internal noprint;
    define Sec/ order noprint;
    define Row/ order noprint;
    define Col0 / display "Variable" style=[cellwidth=2.1in]
    style(header)=[just=left];
    define Col2_1 /display "Placebo?(N=%cmpres(&all_plac.))" center
    style=[cellwidth=1.3in];
    define Col2_2 /display "XXX 12 mg?(N=%left(&all_m12.))" center
    style=[cellwidth=1.3in];
    define Col2_3 /display "XXX 24 mg?(N=%left(&all_m24.))" center
    style=[cellwidth=1.3in];
    define Col2_4 /display "All?Subjects?(N=%left(&tot.))" center
    style=[cellwidth=1.3in];
    compute after page ;
    line "^R/RTF'\brdrt\brdrhair'";
    endcomp;
    compute after _PageNo /style={just = r font_size=9 pt};
    Page_Count = "(Page "||trim(left(put(page,4.)))||" of &maxpage.)";
    line Page_Count $;
    endcomp;

    compute after _userFoot /style={just = l font_size=9 pt};
    line " ";
    line "Note: Age = (((date of consent - date of birth) + 1)/365.25);";
    line "^S={protectspecialchars=off} BMI = (weight [kg]/(height
    [m])\super 2\nosupersub).";
    endcomp;
    *compute before _page_ */ style=[just=L font_size=9 pt];
    line "MY_PHARMA Pharmaceuticals ";
    line "PEN 203";
    endcomp;
    *compute before _page_* / style=[just=c font_size=9 pt];
    line "Table 14.1.4";;
    line "Demographic Characteristics";
    line "(Modified Intent-To-Treat Subjects )";
    endcomp;
    break after page /page;
    run;
    ods _ALL_ close;
    run;
    ods rtf close;
    run;quit;
     
    SAS_learner, Dec 4, 2007
    #1
    1. Advertisements

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.