I have 2 datasets in a VA report. Both should be controlled by a date slider and drop-down list. The slider is using the first dataset ReportMonth column and the drop-down list is using a column in the first dataset. How can the second dataset relate to the both columns? what I meant is if I select a different range of report months and a different value from the drop-down list, all objects using either dataset would change. Thanks. ... View more

My version of SAS Visual Analytics is 8.5.1. There are two icons in the following. The first one is from the data set. I think the second one is calculated field. How was it created? Thanks. When I clicked on New data item, there is not an icon like the second one above.   ... View more

I have few questions for the code below and would like to get some help. My understanding is it did some thing on &dsnn._2 and output to &dsnn._3 but I don't understand 1. The d_member_id, date1, and indexdt are columns. What does class do and get here? 2. What is the variable name for day1 - day&post_days.? what does it do here? 3. This code "(where=(d_member_id ne .) drop=_:) max=;"    a. (d_member_id ne .) means d_member_id not = blank? The d_member_id shouldn't have blank.   b. drop what?   c. max what? if max a column, what is the group by?   proc means data=&dsnn._2 noprint nway; class d_member_id date1 indexdt; var day1 - day&post_days.; output out=&dsnn._3(where=(d_member_id ne .) drop=_:) max=;   Thanks. ... View more