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
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.
Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!
Check out this tutorial series to learn how to build your own steps in SAS Studio.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.