The ODS ExcelXP tagset is pretty powerful stuff. Hidding columns, changing the print layout to landscape, updating the spreadsheet names, defining the default column width and row height, etc – it’s all available using options within the ExcelXP setup….
Tag: Stored Processes
Combining Graphs/Procs with Custom HTML in a SAS Stored Process
The %STPBegin and %STPEnd macros are pretty powerful pieces of code for SAS Stored Processes. They embed all sorts of information on devices, where content is located, and just make everything work. However for creating those fancy custom HTML forms or…
ODS Graphics in ActiveX
Using ActiveX in SAS graphics provides users with more functionality, options, and pretty colors than Jpeg, gif, etc (check out these examples). The issue is that ActiveX requires a device driver installed on the viewing machine, similar to Flash….
Uploading a File (via the Web) into SAS
I must recommend that you check out this example from pg 70 of the SAS Stored Process Developers Guide. http://support.sas.com/documentation/cdl/en/stpug/61271/PDF/default/stpug.pdf
This is a pretty sweet example of how to upload a file from your mach…