Prompts value not resolving in SAS EG7.1

[shubham1]

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

[Kurt_Bremser]

Use prompt type "timestamp".

[shubham1]

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 

[Kurt_Bremser]

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.