HI I am trying to create text prompt with multiple values from dynamic list. But when comes to select data source I can't see how to go to sas server  so I can select variable from dataset i have create by importing excel sheet.   when I click to data source only I can see SAS Folders which doesn't have my files. Is that something I have to create stored process for that? Any help appreciate.   Thanks ... View more

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? ... View more