Hi SKG,   Is not it the same thing you asked in another thread, which I've responded here: https://communities.sas.com/t5/SAS-Visual-Analytics/How-to-display-current-and-previous-years-data-on-corsstab/m-p/300010#M5437 ?   Thanks, Renato ... View more

Hi SKG,   The first thing you need to do is have a column (category) with values Shipping Date and Order Date to populate the dropdown. I don't think you have that column (do you?). Assuming you don't have that column, I've given you two ways that you can get that column, and based on your previous inquiry, it seemed to me that you were trying to use the second method when you said "Can you please elaborate the last method?". The second method requires a calculated column that uses a random number. I thought there was a function for that in VA, but it seems that I was wrong. I apologize for that.   So let me start over... Are there other category columns in your data? If you have, you can create a custom category that randomly maps a few values to "Shipping Date", and the rest of the values to "Order Date". This little trick will give you a new column with the values that you need for the dropdown. It doesn't make sense to use this dropdown with interaction neither as a section or report filter, and that's why I've explained you to use parameter, which you seem to be done already.   If this is still confusing, please send a sample of your data.   Thanks, Renato ... View more

Hi SKG,   Could you pleas provide more details?   Thanks, Renato ... View more

What calculated column did you use to populate the dropdown? Could you please send me its expression?   Thanks, Renato ... View more

Hi @SKG,   The first thing you need to do is have a column (category) with values Shipping Date and Order Date to populate the dropdown. You can either create a tiny table with one column and two rows for that, and add that table to your report, or you can create a calculated item based on a random number between 0 and 1 that returns "Shipping Date" if number < 0.5 or "Order Date" otherwise. As you can imagine, this method is only statiscally safe if the number of rows you have in your table is not too small.   The next step is to assing a character parameter to the dropdown and use that parameter to derive a calculated column (e.g. Date) that returns the value of Shipping Date or Order Date, depending on the parameter value, something like this: if 'parameter'p = "Shipping Date" return 'Shipping Date'n else 'Order Date'n   Now you can use the new Date column to populate the slider.   Best, Renato ... View more

Hi @gauravp1993,   This is the default prompt interface behavior. If you want, you can implement your own prompt interface (as a HTML form for example) that is part of your stored process output. In other words, your stored process would have to programatically create the HTML form with the prompts needed and stream it back to the calling application as part of the stored process logic. Streaming is accomplished by writing to _WEBOUT. It would be something like this:   %global param_1; %global param_N; ods listing close; ods html body=_webout; * code that streams HTML form here; * code that creates visual output based on parameters here (SAS procs, etc.); ods html close;   Here is an example of what the code that streams HTML form could be. Observe that is contains a submit button that re-executes the stored process with the selected parameter: data _null_; format infile $char512.; input; infile = resolve(_infile_); file _webout; put infile; cards4; <FORM ACTION="&_URL" METHOD="post"> <INPUT TYPE="HIDDEN" NAME="_program" VALUE="&_PROGRAM" /> <b>Select a region:</b> <SELECT NAME="param_1"> <OPTION VALUE="Africa">Africa <OPTION VALUE="Asia">Asia <OPTION VALUE="Central America/Caribbean">Central America/Caribbean <OPTION VALUE="Eastern Europe">Eastern Europe <OPTION VALUE="Middle East">Middle East <OPTION VALUE="Pacific">Pacific <OPTION VALUE="South America">South America <OPTION VALUE="United States">United States <OPTION VALUE="Western Europe">Western Europe </SELECT> <HR> <INPUT TYPE="SUBMIT" VALUE="Execute"> </FORM> ;;;; run;   The values displayed in the select tag above could have been dinamically defined, based on your data (you are running a datastep).   You can (or maybe should) add logic to make sure the default prompt values displayed in your HTML form are set according to the stored process parameter values (macro variables &param_1, etc. in the example above).   I hope it helps.   Best, Renato ... View more

Just to clarify, does it mean that if you provide a default value for your stored process parameters in VA it solves the problem?   Thanks, Renato ... View more

If you see the question mark icon, you must be running in the classic mode.   If your stored process has parameters that are flagged as required, you must provide those default parameter values in the stored process object Properties tab. This is what guarantees the stored process has the parameters it needs to execute, otherwise the stored process will throw an error. I have never seen a stored process in VA that prompts for its paramters by poping up its prompt interface automatically. Maybe I'm misundertanding what you are saying.   Is is possible to send some screenshots?   Thanks, Renato ... View more