The SAS Output Delivery System and reporting techniques

charts and Data in Seperate Excel Sheets

Reply
N/A
Posts: 0

charts and Data in Seperate Excel Sheets

Hi
is there anyway to create multiple sheet excel file with bunch of charts in these sheets through SAS . This report will be generated monthly and emailed to the users. The issue I am facing is
1. With excelXp tagset I can create multiple sheets but I can't create Charts
2.With MSoffice2k I Can create charts but not multiple sheets directly. Through hardway I know can create multiple html files and then combine them later. But Since the report I am working on has no luxury of opening the files manualy and saving( Reports get generated automattcally in unix and emailed), Is there any other way to do this .

Eagely waiting for some response :-)
Suren
Ask a Question
Discussion stats
  • 0 replies
  • 105 views
  • 0 likes
  • 1 in conversation