04-25-2013 05:36 AM
I was wondering if it's possible to create an excelfile with this on top in the sheet
|Ontheffing Roerende Voorheffing - &&B&i._Naam|
|Datum Beslissing : 22/03/2013|
followed with a dataset or if there is no data in the dataset "nihil".
|dataset or nihil|
Hope someone can help me.
05-16-2013 05:33 AM
I thin you can find the solution here..Just try with the options in excelxp
Check the below links for samples and training,
05-17-2013 05:35 AM
Thanks for the help.
This is my code and it works fine.
ODS Listing close;
ODS html3 body='/sas/prd/data/2013/Excel/CIT.xls' style=statdoc; /*(1)*/
title c=brown bold "titel 1";
file print ODS=(Var=(a b c d e f));
put a b c d e f;
ODS html3 close;
(1) ODS html3 body='&Excel' style=statdoc; doesn't work
anyone who can help me to add the '-sign before and after the &Excel variable?
05-17-2013 08:05 AM
I used this to add the '-signs
%let Excel= %str(%'&path/Excel/&&E&i._Excel%');
but then I get this error when using it in
ODS listing close;
ODS html3 body=&Excel;
ERROR 22-322: Syntax error, expecting one of the following: a name, a suoted string
ods html3 body="&Excel";
These two little changes made it work.
Thanks a lot.
Need further help from the community? Please ask a new question.