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?
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
April 27 – 30 | Gaylord Texan | Grapevine, Texas
Walk in ready to learn. Walk out ready to deliver. This is the data and AI conference you can't afford to miss.
Register now and lock in 2025 pricing—just $495!
Check out this tutorial series to learn how to build your own steps in SAS Studio.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.