BookmarkSubscribeRSS Feed
deleted_user
Not applicable
Hi..

I am using ods tagsets.excelxp in Enterprise guide 4.2 to generate excel report . i have to display page numbers for each page in the excel report.

Please let me know how to do that.

Thanks in advance.
2 REPLIES 2
Cynthia_sas
SAS Super FREQ
Hi:
Page Numbers, etc are controlled via Excel popup windows or dialog boxes. Since your printing interface is between Excel and the printer, TAGSETS.EXCELXP has some suboptions that will allow you to insert the correct field codes for page numbering into the XML generated by TAGSETS.EXCELXP.

To see the complete list of suboptions that you can use, submit the DOC= suboption as shown below (only the invocation statement is shown):
[pre]
ods tagsets.excelxp file="c:\temp\file.xls" options(doc='Help');
[/pre]

I believe the relevant suboptions are Print_Header and Print_Footer. Some previous forum postings on the subject are:
http://support.sas.com/forums/thread.jspa?messageID=51124잴
http://support.sas.com/forums/thread.jspa?messageID=51021읍

cynthia
deleted_user
Not applicable
Thanks.. It is working well.

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

How to Concatenate Values

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.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 2 replies
  • 839 views
  • 0 likes
  • 2 in conversation