How to use multiple condition in sas for a report

[blyssz]

I have a dataset which contains State, Section and School Name and rest of the data.
For 50 states, there are 45 schools and one school may have branches in one or more than one state with different sections. There are 4 sections:
Primary, Secondary, Middle and Senior.
Ex: School A can have primary branch in AK and Secondary Branch in IL or School B can have Primary Branches in CA, OH and IL.

Now I need to design a report in SAS where first I need to select the State and section and School (Something like dropdown menu in Access form or pivot table in excel) .If I select State, then It should display only those sections which exists in that state and only those schools which exists for the combination of particular State and Section.
Ex: If I select State as IL, then in the next list for Section it should display only Primary, Secondary and for school, it should display A and B only out of 45 schools.
Then based on the particular combination of State, Section and School, it should display the rest of data report for that combination.


Is it possible in SAS or do I need to export my data in other database like access to create such report?