Hi Cynthia, Thanks for the information. All my questions revolve around running Stored Processes from Excel through the Reports button. Pull data using SAS Data button - If I run an STP, I can have it create a dataset, but a couple of issues - one the user then needs to understand that they then need to use the Data button to browse to the appropriate Library and pull the data. The data can't be stored in a temporary Work library because the Work library that the stored process stores data in will not be the same as the one accessed by the end user. So now I have worry about cleaning out a library periodically. (correct me if I am wrong ) STP - through Reports Changing the options in Excel - SAS tab so that results format are CSV, but that means the end user needs to understand the STP they are using and if it is just data or if it is data plus graphs and remembering to switch the option to CSV and back again. Is there a way to automate that from the server side? I really would prefer that the Excel user not have to modify options or worry about what type of STP they are running etc. So bottom line, yes it works if I change the options in Excel. But as a broader approach, this isn't ideal. I would like non-SAS users who have MS add-in to be able to run any of the STP's without having to have pre-knowledge about how the data is returned to them. But, from what I can tell, this isn't possible. I am hoping I am wrong. Regards, Fred
... View more