Hi! I don't think you can do that without editing the XML-file.   You can also do it by having a "master report" and do all changes in that one and then save one copy for each data source and in each copy change the data source manually.   //Fredrik ... View more

Hi! Sessions might help you, I have successfully used them in some of my reports 🙂   https://support.sas.com/rnd/itech/doc9/dev_guide/stprocess/sessions.html   //Fredrik ... View more

Hi! You will need to have the role "Log on as batch job" assigned to you (usually by group assignment).   Is it possible that you have lost that?     //Fredrik ... View more

Hi! There are a lot of functions for dealing with time and date. First try to get the datepart and convert in to a date variable (some combination of datepart and treat as).   As soon as you have a date variable you can duplicate it and assign different formats for day, month, year, ...   //Fredrik   ... View more

Hi! Something might have been corrupt in the XML-file.   One way is to edit the file separately and try to find items missing or "hangling loose" in the report.   //Fredrik ... View more

Hi! If you have "Access to pcfiles" it's not harder than defining a libname 🙂   libname xlfile xlsx '/home/kfen01/exceltest.xlsx';   Will automatically give you two "datasets" in the defined libname.     //Fredrik ... View more

I have solved it by using a calculated dimension for time. I have a button bar with the different possible time dimensions (day, month, quarter and year) I have assigned a parameter to the button bar.   In my graph objects i use this calculated dimension as category. On the objects I have created a dynamic filter that uses the parameter to decide which time period to show.   In my data i have a flag for last day of month, last day of quarter and last day of year. I use these in the dynamic filter   //Fredrik ... View more

Hi! One way you might solve this in is to create a calculated measure that get the value you want to show when then client name is the same as the selected one. You need a parameter that is assigned to the selection box. The formula could look something like this:   IF [parameter] = client_name then RETURN value ELSE return .   THen use this calculated measure in your benchmark graph.   //Fredrik ... View more

Hi! Been of for a week...:)   If you are using SAS VA8.3 you can create an aggregated table with your max and then use this table as input for further calculations.   Don't know if this helps you, but i don't think you can do everything by just adding calculations and not the aggregated table.   Havn't tested any more, but maybe this can help you somehow 🙂   //Fredrik   ... View more

Hi! I think it is hard to get both distict values and the range. But one way to get the range could be to work with rankings and use lowest 1 for fromdate and highest 1 for todate. I dont know which object could work best, but i have used the wordcloud in some of my reports. //Fredrik ... View more

Hi! Maybe this link can get you on the right track 🙂 https://communities.sas.com/t5/SAS-Visual-Analytics/YTD-and-YOY-Calculations/td-p/313191   //Fredrik ... View more

Hi! Maybe I was a bit too fast here, not understanding your logic fully 🙂   For the first table, why is the value for 0='1' and not '4'? Resulting tables       max = 0  max = 1 max = 2 Total 1 2 1   If so one way is to create the new variable (0,1,2...n) by assigning the ID to them if the coded_answer is correct and then set the aggregation so distinc count.   Variable unique0: IF coded_answer = 0 return ID  ELSE .   Variable unique1: IF coded_answer = 1 return ID  ELSE .   Variable unique(n): IF coded_answer = n return ID  ELSE .   //Fredrik ... View more

Hi! one way is to create a new variable for each code and then (on the variables properties); set the aggregation to max.   Variable Max0: IF coded_answer = 0 return 0  ELSE .   Variable Max1: IF coded_answer = 1 return 1  ELSE .   Variable Max(n): IF coded_answer = n return n  ELSE .   //Fredrik ... View more