Hi,
I want to print the title only once on the top of the worksheet but title is being printed after each page break.How to print only on top of the work sheet?
I used embed_titles_once option but still the title is printed after each block
As shown below title is being printed after each block which i don't want. I want to print only once on top of the sheet
I am using Proc report and ods excel xp tagset
ods escapechar='^';
OPTIONS FORMCHAR="|----|+|---+=|-/\<>*" nobyline missing=0;
ods tagsets.excelxp file = "test..xls" ;
ods tagsets.ExcelXP options(autofit_height="yes" autofit_width="yes" sheet_interval="none"
absolute_column_width='12,6,9,8,8' embedded_titles="yes" embed_titles_once="yes" sheet_name="Stats");
title "Report Date &Dt";
proc report data=Final split='*' ls=200 missing
style(header)={background=mediumblue foreground=white fontsize=12pt fontweight=bold vjust=b}
style(summary)={background=mediumblue foreground=white fontweight=bold};
column ordr type units dollars ;
define ordr / order order=data noprint;
define tyoe / order order=data ;
define units / order order=data ;
define dollars / order order=data ;
break after ordr / page;
compute before _page_ / style=Header{background=mediumblue foreground=white fontsize=12pt fontweight=bold};
line ' ';
endcomp;
run;
What version of tagsets are you using? You can see the version after you execute a tagsets code.
You're a version out of date.
Get the update here:
https://support.sas.com/rnd/base/ods/odsmarkup/index.html
See if that helps to resolve your issue. If not, post back.
NOTE: This is the Excel XP tagset (Compatible with SAS 9.1.3 and above, v1.131, 04/23/2015
I updated the tagset but still getting the same issue
Can you use ?
ods text='XXXXXXXXXXXXXXXXXX';
I think i Can't
By default the title will appear on each PAGE of output that proc report generates: break after ordr / page; creates the pages.
Since your tagsets options puts all of the proc report logical pages on a single physical page then you get that result.
IS there any way to overcome that
Use ODS TEXT instead of TITLE as @Ksharp suggested.
I tried it but in ods excel xp tagset it's not working
Currently the work around I did was for the first row on the dataset created a title statement and printed it using compute before _page_ block so that it prints only for the first table
If you post your code with a dataset we can run, ie sashelp.class or sashelp.cars then we can try and help you debug.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.