Help using Base SAS procedures

How to create drop downs

Reply
Regular Contributor
Posts: 240

How to create drop downs

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

2

3

4

5

SAS Super FREQ
Posts: 8,864

Re: How to create drop downs

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.)

SAS Super FREQ
Posts: 8,864

Re: How to create drop downs

Posted in reply to Cynthia_sas

posting picture of cascading prompt example:cascading_prompt3.png

Ask a Question
Discussion stats
  • 2 replies
  • 255 views
  • 3 likes
  • 2 in conversation