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.
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!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.
Select SAS Training centers are offering in-person courses. View upcoming courses for: