02-23-2017 06:16 AM
HI I want to create prompt with multiple value. So I have batch list which I want in macro variable in EG. SO basically similar to proc sql with into process , I want to achieve in EG with prompt.
I tried to create prompt with type text and select from dynamic list and multiple value but when I try to browse for data source for column which I have in dataset cteared in process flow it doesn't appear.
when I click it shows sas folder but can't see serve so I can select that dataset.
I don't want to create SP as only using this project and I am only using.
Is there any other way I can acheive this?
03-02-2017 06:03 AM
Only registered (permanent) data sets can be used in a dynamic prompt...that is why you cannot find any work data sets from your project when you browse for a prompt data source