topic Prompt that dynamically provides a list of years that depends on the current year in SAS Enterprise Guide

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

Multipla99 — Fri, 25 Nov 2022 18:09:49 GMT

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?

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

AhmedAl_Attar — Tue, 29 Nov 2022 14:10:06 GMT

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;

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

AhmedAl_Attar — Tue, 29 Nov 2022 14:25:16 GMT

@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

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

Multipla99 — Tue, 29 Nov 2022 14:40:26 GMT

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?

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

AhmedAl_Attar — Tue, 29 Nov 2022 14:57:59 GMT

@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