Hello
I am having a SAS EG project on 7.1.In that I have a prompt which is taking the values from one of the column in sql server table .That column is datetime .When user is going to run that EG project he is going to see different values in the drop down of the prompt and he need to select one
Prompt type is defined as Date .But when i am running that SAS EG project by selecting one value in that prompt I am getting the value of that prompt as Blank
I have tried to resolve the value of prompt by using %put
what could be the reason for getting the Blank value .
Prompt type does not have datetime option .The reason for blank value might be when we are taking the input in prompt it is datetime but the prompt type is date
please guide
If I select prompt type as timestamp then it does not give me the option to select the values from sql server table.The only option that comes up is to provide the default value only
Then I would create a SAS dataset from the MS SQL Server table, which you then register in metadata. Then you can adapt the types in the prompt as they are in the dataset.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.
Find more tutorials on the SAS Users YouTube channel.