Hello all, So my group is switching over to SAS for their analysis and reporting, which I am very excited about, because I will be writing basically everything from scratch (yay!). However, I am running in to a couple issues implementing enhancements that senior management have requested. So far I have created the framework for a multi sheet workbook to be outputted into Excel that has been formatted and looks great, imo. But, we are going to be adding "TextBoxes" on all sheets after the Trending worksheets in the workbook. I have created a simple VBA macro to accomplish this, and can share that code with the analysts in my group to add to their PERSONAL.XLSB macro worksheet so it can be called anytime. First Question: Is there a way for me to add a TextBox into my output directly from SAS? I am trying to move away from VBA, which our group's previous reporting relied heavily upon. Next, there needs to be a few sheets created/added to the beginning of the workbook, which will serve as a Summary and Data Observation tabs. I would like these worksheets to be pre-formatted so the overall look of the workbook is consistent, but I am not sure how to implement this. Second Question: Is it possible to send my output to an Excel Template that has those 2/3 beginning sheets already included, and just insert the remaining 10-20 sheets after those? I know that there is the %exportxl macro floating around out there, but would still like to ask (even though it has probably been asked a million times, sorry). Is it possible for me to create a "report template" via PROC REPORT or a DATA _NULL_ step to create the outline for those first couple sheets, and then fill in the sections from our internal databases and the monthly external data sets we receive? As of now, the plan is to run an X Command at the end of the program to open to Workbook, and then hopefully figure out how to transfer my VBA code to a VBScript so I can then call that from within SAS. But I would rather just use SAS for everything. None of the analysts in my group have any experience with SAS, so they will be using EG 7.15 for running these reports and performing ad hoc analysis (with SAS 9.4 TS1M3), and for the time being we will not be on the SAS GRID. I apologize if I am not being clear in my questions or not supplying enough information. Thank you in advance for any assistance!
... View more