Desktop productivity for business analysts and programmers

insert value in a table with prompt

Reply
Occasional Contributor
Posts: 5

insert value in a table with prompt

I would like the following to happen:

When I run my SAS project, I want to see a pop-up where I can fill in a reference date, a start date and an end date. And I want those three values to occur in a table like this:

 

   REF                BEGIN           END

1 01/02/2018     02/02/2018     20/02/2018

 

Is this possible?

 

I made three tables with all dates between 1996 and today on which I used my prompt but I don't think this the right way...

 

Thanks in advance

 

 

 

Super User
Posts: 10,557

Re: insert value in a table with prompt

Create the three prompts as data prompts, and use a data step like this:

data want;
ref = "&ref"d;
begin = "&begin"d;
end = "&end"d;
format ref begin end ddmmyy10.;
run;

The prompts need to be named ref, begin and end, respectively.

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
How to convert datasets to data steps
How to post code
Ask a Question
Discussion stats
  • 1 reply
  • 126 views
  • 0 likes
  • 2 in conversation