topic Re: Create dynamic HTML drop down list from sas table in stored proc in SAS Programming

Create dynamic HTML drop down list from sas table in stored proc

JackieR — Tue, 08 Sep 2020 12:50:51 GMT

Hi all

i have a list of questions with a number of various answers in a SAS dataset and i am creating a stored procedure where i need to list the questions with their respective drop down list for the user to select an answer.

The data looks as follows:

Q_ID Question Drop down selection

1 Question1 Selection1

1 Question1 Selection2

1 Question1 Selection3

2 Question2 Selection1

2 Question2 Selection2

2 Question2 Selection3

3 Question3 Selection1

3 Question3 Selection2

I would like the questions to be dynamic in that if a value on the table is changed, it would reflect on the stored proc. I would not want to hard code 100 odd questions each time a value changes.

Re: Create dynamic HTML drop down list from sas table in stored proc

ChrisNZ — Wed, 09 Sep 2020 01:30:55 GMT

> I would like the questions to be dynamic

Where do the questions and drop-down lists appear? In a browser in an HTML form?

Re: Create dynamic HTML drop down list from sas table in stored proc

andreas_lds — Wed, 09 Sep 2020 07:37:05 GMT

You can use datasets as source for drop-down-lists, the datasets have to be registered in the metadata. This is documented in the Stored Processes: Developer’s Guide