02-06-2018 11:57 AM
I'm building a task where I want to create a where clause based on a data and variable selection (I've re-used the Filter Data supplied task). I want to create an IN clause but there seems to be no way of doing it.
I can fill a DISTINCT object with the variable values but this only allows one value to be selected. A COMBOBOX is also out of the question as this is also a single selection object.
Has anyone managed to fill a SELECT object with the variable values? I've only managed to get it to add in the variable name when I want to get the list of distinct values from that variable name.
Anyone got any ideas?
02-06-2018 08:59 PM
02-07-2018 04:04 AM
Thanks for the reply. I'll have a look at the Query Utility but I actually need this as part of a larger custom task. So the selection of a where clause is one part of the whole custom task. Unless there's a way of calling existing tasks from within a custom task (analogous to a macro).
02-07-2018 03:10 PM
The feature that you are looking for in an object to construct a custom task is currently not available in SAS Studio. We will consider adding this feature in a future release. Thank you for your feedback.
With regarding to your other question, you cannot call an existing task from a custom task. However, you can run an existing task and a custom task together using a Process Flow in SAS Studio.