I don't see any code in your screenshots, but I guess you need to define your library in the metadata so that it is automatically assigned by the stored process server.
To verify that the library definition is not the culprit, I'd create a simple STP that reads data from a dataset in that library (without explicit libname for that library in the STP) and test that.
AS per the update from SAS Technical support, To generate the values dynamically, the table used in the prompt should belongs to the same library of other tables used in the program, I already have the program in the same manner, then also it won't work.
May I get any additional information to resolve this issue.
Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.
If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.