08-24-2015 06:22 AM
Hello to all!
I have a need to pass the selected items in a list to a SAS stored process as a parameter. Is this somehow possible? If I could pass the selected items to the stored process, separated by comma for example, I would be very happy. In order not to make things to easy, there is also a need to pass start and stop time to the stored process and at the moment, these come from another data source. The passing of these two parameters work fine. In the image below, you can see what the tables look like.
Is it even possible to form sort of a string from the selected items in a list? Is there any possibility to pass parameters to a stored process from two data sources or tables? If the answer to these questions is a strict no, then I believe that an entire different solution for this problem should be considered.
The stored process executes a sql query to a mssql server using SQL Connector.