I'm building a web application that uses HtmSql. The first drop down list connects to a SAS data set and populates the drop down list with a list of values. I need the second drop down list to connect to the same SAS data set and populate the drop down list this time excluding the users selection from the first drop down list.
htmSQL is part of SAS/IntrNet and while SAS/IntrNet does use ODS, very little of htmSQL uses ODS. Usually, you create htmSQL data queries to create custom HTML forms based on SAS data sources.
I remember doing something similar to this when I had access to SAS/IntrNet. As I remember, we built one page, that was the first query -- perhaps querying for Region. Then the results of that query built a second form on a second page that showed what they had just selected and then gave them more choices. As I remember, we used hidden form fields to pass input from the first query and to the second form, so it could be used in a second htmSQL query -- then based on what came back from the second query, they had a choice of what they wanted to run -- and then we kicked off a Graph program using the Application Dispatcher.
For more help with SAS/IntrNet and with htmSQL, your best bet is to open a track with Tech Support.
Though I have no experience, the SUGI/SGF paper below mentions a two-level drill-down generated by HTMSQL in a single HTML document with multiple queries, although the HTML tags are suppressed. The SAS Support team know their stuff, so like Cynthia mentioned, your quickest route to success would likely be to open a track with your question and provide any / all details about requirements you have collected.