topic Re: Proc report Conditional body of text in SAS Programming

Proc report Conditional body of text

mmkr — Tue, 16 Jul 2024 11:55:13 GMT

data check;
input name $ age;
cards;
abc 10
def 11
ghj 23
kld 45
;
run;

ods pdf file="test.pdf" bookmarklist=none ;
proc report data=check;
columns name age;
define name / "Name";
define age / "Age";

/*if age is greater than 19 */

/*then i want body of text says Age is greater than 19 you can enter */

run;
ods pdf close;

Re: Proc report Conditional body of text

PaigeMiller — Tue, 16 Jul 2024 12:12:39 GMT

proc format;
    value agef 19-high='Age is greater than 19';
run;

ods pdf file="test.pdf" bookmarklist=none ;
proc report data=check;
columns name age;
define name / "Name";
define age / "Age" format=agef.;
run;
ods pdf close;

Re: Proc report Conditional body of text

mmkr — Tue, 16 Jul 2024 12:24:00 GMT

I don't want in to the table

I want text in the body of the report like below !!

Re: Proc report Conditional body of text

PaigeMiller — Tue, 16 Jul 2024 13:08:11 GMT

ods pdf file="test.pdf" bookmarklist=none ;
proc report data=check;
    columns name age;
    define name / "Name";
    define age / "Age";
run;

proc sql noprint;
    select max(age) into :maxage from check;
quit;
%if &maxage>19 %then %do; 
    ods escapechar='^';
    ods text ="^{style [just=c]}Age is greater than 19" ;
%end;
ods pdf close;