Hi, I am trying to create a report in SAS Visual Analytics Report, using two tables. I have two tables. i can create graph, list, crosstabs seperately using each table in one section, but is it possible that i can create a single list or crosstab using both tables?  Tables has some common fields, not all.   table one. Year, location, population   Table two Year, location, disease name,confirm/suspected, numberof cases   So, both table has year and location common. I wanted to get population from table one to table two crosstab. Any idea how i can do that? Thanks Badal       ... View more

Hi, I am using SAS VA 7.1 hotfix 3. I am kind of new in VA. I was exploring functions that are supported in SAS VA (report design). And in one place (http://www.listendata.com/2016/05/sas-visual-analytics-change-variable.html ) i found the discussion suggested using a function 'Parse' to convert a text variable to numeric. I tested and it looked like it worked because there was no error message and the new calculated variable was in the numeric variable area. i think i did not see the function in the calculated item area and as far as i can remember did not even see in the user guide. Please tell me if i am wrong. So, my final question is, if it (Parse function) works, as i tested, then what are the other functions, is there any list anywhere, that i can use and those are not in the VA report design interface? Thanks for your help. Badal   ... View more

Hi I am new in SAS Visual Analytics (7.1) , i created a report with a crosstab object but when there are no data for that row, the row is missing from the cross tab.  Is there a way to show the row in the crosstab when the value is missing or the data is zero? Thanks for your help. Badal       ... View more