Prompt that dynamically provides a list of years that depends on the current year

[Multipla99]

I would like to build a prompt in SAS EG 8.2 that gives the user a list of years to chose from. The list should include all years from, lets say t-3 to t+1, where t is the current year. As you can see in the example below I started out quite well. However, now I would like the "list of values" to be populated, dynamically, with the years  2019-2023, assuming that the current year is 2022. Next year, 2023, the "list of values" should be populated dynamically with 2020-2024 and so on.

How can I acheive this? 

 

[AhmedAl_Attar]

Hi @Multipla99 

Looking at your screen shot, I see two contradicting settings!
Method for populating prompt: User selects values from a static list
vs.

your requirement: the "list of values" should be populated dynamically

To achieve 100% automatic dynamic list of values,  You'll need to

1. Create a Dataset view 

data <lib>.dyn_years/view=<lib>.dyn_years;
   do year=(year(date())-3) to (year(date())+1);
       output;
   end;
run;

[AhmedAl_Attar]

@Multipla99 

Just to continue where I left-off

2. Register the newly created dataset view (<lib>.dyn_years) into your Metadata Server (If you have one), and save it in accessible Metadata folder

3. Change the Method for populating prompt to: User selects values from a dynamic list

4. Specify/select the newly created dataset view (<lib>.dyn_years) as the Data source:, and populate additional fields as needed.

Otherwise, I don't think there is automated way to convert static list into dynamic  

Hope this helps,

Ahmed

[Multipla99]

Thank you so much, AhmedAl_Attar, for helping me with this!

You say that I could save the suggested view in the accessible metadata folder. I definitely have a Metadata server, see below, but I don't know how to find the accessible Metadata folder. Is this folder something you can help me to locate?

 

[AhmedAl_Attar]

@Multipla99 

You'll have to coordinate with your SAS Administrator, as he/she should have access to SAS Management Console or other tools that would register Library references, tables, views, and security controls for your SAS environment