topic Re: How to create drop downs in SAS Procedures

How to create drop downs

BETO — Thu, 04 Jun 2015 20:51:16 GMT

hi I have a request that will allow the users to do drop downs

here is the raw data

REGION SITE. STATE. DISTRICT. MON TUE WED THURSDAY FRI. test

1. A1. tx. W.texas. 10. 0. 15. 24. 45. yes

what I need is to look like this I need to look at raw data a if day of week is greater than 12 it counts as one in this case 2 days ....what I need is for the person to select region 1 and the raw data will appear an once open. They can select district an it keeps going down in a hierachy to site Id ....I hope in make sense thanks for all the help

Region 1 times 2 times 3 times 4 times 5 times

1. One

Re: How to create drop downs

Cynthia_sas — Fri, 05 Jun 2015 22:24:21 GMT

Hi:

This sounds like the type of cascading prompt that you would build for a stored process. For example, here's a screen shot of the prompting interface that shows a different list of countries depending on the first prompt the users selected. Do you have the BI Platform and have you used the prompting interface?

cynthia

(Sorry, I can't seem to post an image right now. I will try to post the image in a bit.)

Re: How to create drop downs

Cynthia_sas — Mon, 08 Jun 2015 17:17:23 GMT

posting picture of cascading prompt example: