topic Re: Prompts value not resolving in SAS EG7.1 in SAS Enterprise Guide

Prompts value not resolving in SAS EG7.1

shubham1 — Tue, 14 Jan 2020 14:06:20 GMT

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

Re: Prompts value not resolving in SAS EG7.1

Kurt_Bremser — Tue, 14 Jan 2020 14:09:57 GMT

Use prompt type "timestamp".

Re: Prompts value not resolving in SAS EG7.1

shubham1 — Tue, 14 Jan 2020 14:16:02 GMT

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

Re: Prompts value not resolving in SAS EG7.1

Kurt_Bremser — Tue, 14 Jan 2020 14:18:25 GMT

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.