topic Re: Stack data ODS excel - titles in SAS Programming

Stack data ODS excel - titles

DougHold — Fri, 20 Jan 2023 20:45:16 GMT

Here are 3 tables from sashelp.cars dataset. I would like to combine them into one excel report.

proc report data=sashelp.cars(obs=3) out=Porsche;   
	title "Porsche";
	where make = 'Porsche';
	column Make Model Type Origin DriveTrain MSRP;  

proc report data=sashelp.cars(obs=3) out=BMW;   
	title "BMW";
	where make = 'BMW';
	column Make Model Type Origin DriveTrain MSRP;

proc report data=sashelp.cars(obs=3) out=Audi;   
	title "Audi";
	where make = 'Audi';
	column Make Model Type Origin DriveTrain MSRP;
run;

However, I don't understand why the titles are all named as the last table 'Audi' when combined like this ?

ods excel file="Stacked.xlsx" 
options(sheet_interval='none' embedded_titles='yes');
proc report data=Porsche;
proc report data=BMW;
proc report data=Audi;
run;
ods excel close;

What I want is this, each table retaining it's proper title:

Re: Stack data ODS excel - titles

Reeza — Fri, 20 Jan 2023 20:52:40 GMT

TITLE statements stay in effect until you reset it.
Use:
TITLE;

To reset the title and have no title.
Your last set of code has no title statement so it uses the title from your last code as it hasn't been reset.

ods excel file="Stacked.xlsx"
options(sheet_interval='none' embedded_titles='yes');
title 'Porsche';
proc report data=Porsche;
title 'BMW';
proc report data=BMW;
title 'Audi';
proc report data=Audi;
run;
title; *reset;
ods excel close;

You may want to look into BY groups though as that could make this a lot easier:

title "#ByValue1";
proc report data=sashelp.cars;
by Make;
where make in ( 'Audi', 'BMW', 'Porsche');
column Make Model Type Origin DriveTrain MSRP;
run;

Re: Stack data ODS excel - titles

DougHold — Fri, 20 Jan 2023 21:30:09 GMT

Thanks for clarifying!