topic Re: Title in PDF file in SAS Programming

Title in PDF file

Num19 — Tue, 09 Jan 2018 08:18:15 GMT

Hi, I would like to insert a title in each page of my PDF file depending on values from a variable, I tried this :

PROC SORT DATA=tab;
BY var1;
RUN;

ODS PDF FILE="C:\Users\User\Desktop\File.pdf" STYLE=PEARL STARTPAGE=BYGROUP;
title CATX(" - ","Results of the game", var1);
PROC PRINT DATA=tab (FIRSTOBS=2) sumlabel="Totals" label NOOBS;
VAR var2-var5;
BY var1;
sum var2-var4;
RUN;
ODS PDF CLOSE;

However I have literally this title :

CATX(" - ","Results of the game", var1)

instead of :

Results of the game - game 1

(For the first game for example)

Thanks for your help.

Re: Title in PDF file

PeterClemmensen — Tue, 09 Jan 2018 08:32:44 GMT

You can not use functions in a title statement like that.

Do somethind like this

data _null_;
	MyTitle=CATX(" - ","Results of the game", var1);
	call symputx("MyTitle", MyTitle);
run;

title "&MyTitle.";

Re: Title in PDF file

Num19 — Tue, 09 Jan 2018 08:42:40 GMT

I have a title like : "Results of the game - .

var1=game1 "

at each page.

Re: Title in PDF file

RW9 — Tue, 09 Jan 2018 08:58:11 GMT

Use By Grouping - it is a key feature of SAS and will make your coding life much easier (and not coding in upper case or mixed case will help my eyesight!!!):

ods pdf file="c:\users\user\desktop\file.pdf" style=pearl startpage=bygroup;
proc print data=tab (firstobs=2) sumlabel="Totals" label noobs;
  var var2-var5;
  by var1;
  title "Results of the game - #byvar1";
  sum var2-var4;
run;
ods pdf close;

Note specifically the #byvar1, you could also use #byval1.

Re: Title in PDF file

Num19 — Tue, 09 Jan 2018 09:32:08 GMT

It stil does'nt work, I have a title like this one :

Results of the game - #byvar1

Thank you for your help.

Re: Title in PDF file

RW9 — Tue, 09 Jan 2018 09:48:24 GMT

It should work, try:

options nobyline;

ods pdf file="s:\temp\file.pdf" style=pearl startpage=bygroup;

proc sort data=sashelp.class out=class;
  by sex;
run;

proc print data=class (firstobs=2) sumlabel="Totals" label noobs;
  var _all_;
  by sex;
  title "Results of the game - #byval1";
run;
ods pdf close;

Oh, and "it doesn't work" - doesn't help. Post your code in full and test data which shows the operation as a datastep.

Re: Title in PDF file

Num19 — Tue, 09 Jan 2018 10:07:55 GMT

Yes it does, thank you.