Hello Krusader. You can certainly use the below code to get the All Possible values in your output.. In my Case I have created Propmt for State Name so you can make the changes accordingly. ( I will have option to select more the one state or can select _ALL_VALUES_ ) PROC SQL; CREATE TABLE WORK.QUERY_FOR_STATEVIEW AS SELECT DISTINCT t1.STATE FROM SASORCL.SAS_BI_VW_SALESVIEW t1 WHERE %_eg_WhereParam( t1.STATE, state, IN, TYPE=S, IS_EXPLICIT=0 ); QUIT; Note: Make sure you are using where clause for "In A List" operator not "=" operator.. Let me know if you need anymore infor for the same. Regards; Jim
... View more