Hi there, I have a question regarding a SAS Automation with using a prompt interface for filtering. But before coming to the question, I have some details about the environment: - SAS Base 9.4 with using the application SAS EG 6.1 (Server on Windows Server Edition 2012 and local machine running with Windows 7) and the Microsoft Office Add-In 6.1 - Sybase database connection Currently I receive requests to extract certain detailed data files for the end user with SAS, e.g. data sets with even more than 1,000,000 data lines and I want to allow the user to run the request by their own. The end user shall not interfere in any way with SAS (as much as possible). I have tried out certain ways of enabling the user to this data request: - First, I created a stored process to extract the data and add it to MS Excel via 'List Data' and ODS Output. The data lines are already split into certain Excel tabs to avoid the maximum capacity in Excel (not more than 1 mn lines per tab). However, the Excel file can now increase up to 740 MB, which is not suitable at all for the end user. - As a second option, I wanted to schedule the project as a vbs-file. This is working properly, also with the Export Task for a csv-file. But unfortunately, I have included a prompt for filtering and it will only take the one from the initial stored run. In addition, it seems only be possible at a local drive and not on a shared drive. (Remark: Currently, I am not allowed to use the SAS Management Console as the SAS set-up is still in a project phase and the company wants to the split the Admin work from the analysts) - The third option would be an auto executed process, while opening the SAS EG project. Unfortunately, the end user can mess up the project with additional or modified queries and I want to disable the end user from this task. At the end, I would like to have an auto executed SAS project with no obvious interaction with SAS. Do you have any suggestion for me? Thank you very much in advance J
... View more