SAS Programming

DATA Step, Macro, Functions and more
BookmarkSubscribeRSS Feed
mmkr
Quartz | Level 8

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;

3 REPLIES 3
PaigeMiller
Diamond | Level 26
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;
--
Paige Miller
mmkr
Quartz | Level 8

I don't want in to the table 

 

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

 

mmkr_0-1721132627035.png

 

PaigeMiller
Diamond | Level 26
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;
--
Paige Miller

sas-innovate-wordmark-2025-midnight.png

Register Today!

Join us for SAS Innovate 2025, our biggest and most exciting global event of the year, in Orlando, FL, from May 6-9. Sign up by March 14 for just $795.


Register now!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 3 replies
  • 536 views
  • 2 likes
  • 2 in conversation