Hi
Obviously I suffer from baby blues or whatever.. so much has been forgotten.. But at the moment I have following elements on my excel printing:
A Proc Template creating two table templates and conclusion page uses following definitions:
define selite;
generic=on;
style=data{url=$urli.};
end;
...
ods tagsets.excelxp file='c:\temp\tilaus.xls'
options( embedded_titles='yes' embedded_footnotes='yes' );
%macro printtaa;
;
%do times = 1 %to &kpl;
%let place=%scan(&names,×,*);
ods tagsets.excelxp options(sheet_name="&place");
...
and the data _null_ step where all that is calculated before will be put into ods destination. In the data _null_ step there are several set-statements, several merge-statements and other things.
Before defining the table template, a format has to be create for refferring the right sheets on the workbook. Only cntlin can be used, no macro variable references and generating the proc format code.
..
%do times = 1 %to &kpl;
%let part=%str(%')%scan(&names,×,*)%str(%');
start="%scan(&names,×,*)";
label="#'"||trim(left(compbl(start)))||"'!A1";
output;
%end;
... View more