topic Re: how to add two titles seperately in a dataset in SAS Programming

how to add two titles seperately in a dataset

septemberbulb — Wed, 18 Jan 2017 13:50:02 GMT

Hello,

I want to combine two dataset: PL and PLC vertically,

so I use the

data all;

set PL PLC;

run;

I hope the output will show: a title for PL and a title for PLC in one dataset , does anyone know how and where can I add that please?

Thank you

Re: how to add two titles seperately in a dataset

Reeza — Wed, 18 Jan 2017 14:05:13 GMT

Titles don't exist within a dataset, only for reports.

Look at Example 2

https://support.sas.com/documentation/cdl/en/lestmtsref/69738/HTML/default/viewer.htm#p10gcmrmf83iaxn1ilrx4pra969n.htm

You will need a variable to differentiate the datasets, look at the INDSNAME option to capture the name of the dataset.

Data all;

length source dsname $50.;

set pl plc INDSNAME=source;

dsname=source;

run;

Re: how to add two titles seperately in a dataset

Astounding — Wed, 18 Jan 2017 15:01:27 GMT

Reeza's tools can help, but you may need some programming as well. You may need to add a variable to the data set that holds the text you want to insert into the title (possibly the entire text, as in this example below).

data want;

set PL (in=in1) PLC (in=in2);

length title_text $ 50;

if in1 then title_text = 'I want to use this title for the PL observations';

else title_text = 'Exceptions were also added by the PLC observations';

run;

Then you can use this text as titles by adding a BY statement and #BYVAL:

proc print data=want;

by title_text notsorted;

title '#BYVAL1';

run;

So SAS isn't really built to do what you ask, but you can work around that even without using ODS.

Re: how to add two titles seperately in a dataset

septemberbulb — Wed, 18 Jan 2017 15:39:20 GMT

thank you. learned a lot