Sorry, I was lazy, yes, I did mean using SAS Web Report Studio. In in SAS Web Report Studio, I've attempted to create a SAS Web Report (usually has a suffix of .srx, what do people usually call this?). In that SAS Web Report, I have put in a Stored Process (as opposed to a table, or graph, etc). I want the Excel file created when the user visits this page. They have no access to SAS Enterpride Guide. I would be very happy to create plain HTML files, but I wouldn't know how to have a Stored Process execute? My example of C: drive was too simplistic in hindsight, it's actually going to a place on the network. The workspace server should have visibility of the spot that I'm attemping to export to. It doesn't have to be a Stored Process, it can be anything, I just couldn't think of a better way of doing this. Note, I already have a SAS Web Report, with a Stored Process that just lists all the data, the nice thing is it doesn't display thousands of records, but only the first 40. The user in turn clicks on the export button, and they get a zip file. They extract it, open the Excel file, and then save it as another Excel file. I felt that this was quite a long round-about way to get a listing of data in Excel. What I want is for a user to be able to visit something which in turns generates an Excel file (a dump of a SAS dataset) on the network. Whilst the Addin for Microsoft Office sounds ideal, I have two issues with it, licencing and even installing it. If licencing wasn't an issue, I would have contacted technical support for help on that. I don't want to generate a dump of the data everyday. Thanks.
... View more