Hi Everyone,   Currently when I run my query, there are cases whereby there will be duplicate rows (with only one data item is different, not critical)   The below is the example (ID is the unique key):   Original Data  ID     Name      Date   1       joe          11/11/11 1       joe          12/11/11 2       Mary       11/11/11 3       Jane       12/12/11 3       Jane       13/12/11   Hope to achieve ID     Name      Date   1       joe          11/11/11 2       Mary       11/11/11 3       Jane       12/12/11     In SAS VA data query, what should I do in order to achieve that?    Thank You ... View more

Hi all, would like to know how to display all the data with the lowest value. Understand that ranking alcan do this but with ranking it can only show one wlrow of data with the lowest value. Because in my data, there is a chance that two to three rows of data might have the same lowest value. So if thats the case, how do i go about doing it? Thanks! ... View more

Hi,   I would like to know if SAS VA's Crosstab graph allow us to select a single cell instead of the entire row?    If possible, how do I go about doing it?   Thank You ... View more

Hi everyone,   Understand that current SAS VA  bar chart can do Normalized to 100%, however can this be done in line chart? Or is there other way that I can do it? My line chart has hierarchy as well, so it will zomm down from year -> month -> days   Thanks you ... View more