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?