topic Re: How to automatically add data set name on output title in ODS and Base Reporting

How to automatically add data set name on output title

Robois — Thu, 25 Jul 2019 09:50:07 GMT

Hi!

I would like SAS 9.4 to put automatically the name of the data set I'm running on the title of SAS output/results viewer. How to do it?

This is an example of the code I'm running:

libname Experiment 'O:\MAINFOLDER\SUBFOLDER\SAS library';
PROC IMPORT OUT= Experiment.measurements DATAFILE= "O:\MAINFOLDER\SUBFOLDER\filename.xlsx"
DBMS=XLSX REPLACE;
SHEET="SAS";
GETNAMES=YES;
RUN;

PROC PRINT data=Experiment.measurements;
title 'Data set Experiment.measurements all observations';
run;

So how do I make SAS automatically to change the title text marked with red to match the current data set I'm running? It's to time consuming to change all the titles manually when changing from one data set to another!

Thanks for any help

Re: How to automatically add data set name on output title

andreas_lds — Thu, 25 Jul 2019 10:12:32 GMT

Maybe i missed something, but aren't libref limited to 8 chars and datasets to 32 chars?

SAS saves the name of the last dataset created by datastep or proc in the macro-variable SYSLAST. So changing the title-statement to

title "Dataset &SYSLAST all obs";

should solve the problem.

Re: How to automatically add data set name on output title

Robois — Thu, 25 Jul 2019 11:02:43 GMT

The &SYSLAST macro-variable didn't work. It just returns a output with title 'Data set &SYSLAST all observations'. Any other ideas?

You are probably right about the character limits. However, I just made those up just for this example, so in reality I use different - shorter - names.

Re: How to automatically add data set name on output title

Cynthia_sas — Thu, 25 Jul 2019 14:31:06 GMT

The difference between your TITLE statement and the solution TITLE statement is that you used single quotes. &SYSLAST will NOT resolve when it is enclosed within single quotes. It needs to be resolved within double quotes.

Cynthia