Hi! The procedutre "proc contents" with the option "out=" writes properties to a data set, will that help you? //Fredrik ... View more

Hi! If you have the tab in "precision mode" then you can select multiple objects using ctrl. If you click on the frame that pops up when you hover over the objects you can move them with the arrow keys 🙂 //Fredrik ... View more

Hi! One way to do this is by creating a parameter and connect it to a text input box.   Then create a calculated measure that checks the value of the parameter and then chose the corresponding kpi, ie: if [parameter] = 'kpi1' then kpi1 else if [parameter] = 'kpi2' then kpi2 ... ...   Then use this calculated measute in your cross-tab   One problem is that you can't change the format dynamically depending on the chosen kpi, they all get what you specify for the calculated measure.   Another is that the user must type the exact name of the kpi. One way to solve this is that the text box filters a list with your kpi's and the user selects kpi from this list, also you create another parameter used in the calculated measure.   Hope this can give you some inspiration 🙂   //Fredrik ... View more

Maybe i am way out here 🙂 but...   IF you create a calculated measure that use your parameter or parameters to create a status and then create a display rule on that status, something like this:   If [parameter] = '1 >=  <= 5' and (1 <= [value] <=5) then status = 1 else If [parameter] = '5 >=  <= 10' and (5 <= [value] <=10) then status = 1      ***** (or 2 if you want to have different display rules) else If [parameter] = '10 >=  <= 15' and (10 <= [value] <=15) then status = 1      ***** (or 3 if you want to have different display rules)     Won't that work fo you? //Fredrik   ... View more

Hi! One way is to create a calculated item that uses your parameter and then create the display rule on that calculated item. //Fredrik ... View more

Hi! It works more or less like the old stored processes. You write base code and create a package which can be run from viya and the interface. You don't get the prompting framework but can create your own using standard web techniques like html and javascript.   To access the application type:  http://host:port/SASJobExecution/   When you select create new you can choose to create code or form.   //Fredrik ... View more

Hi! Job execution might help you here and in your other post on the community, check this out: https://documentation.sas.com/?docsetId=jobexecug&docsetTarget=titlepage.htm&docsetVersion=2.0&locale=en   //Fredrik ... View more

I don't know if Job execution was inplemented in version 8.2, if so this might help you 🙂   https://documentation.sas.com/?docsetId=jobexecug&docsetTarget=n055josnxfatfwn1pyr7p1ah7225.htm&docsetVersion=2.0&locale=en   You can create your own table with html content or whatever you like 🙂 //Fredrik ... View more

Hi! In Viya you have Job exection which is similiar to stored process. You don't get the prompting framework, but you can create your own form that passes parameters to the job. This might get you started:   https://documentation.sas.com/api/docsets/jobexecug/2.0/content/jobexecug.pdf?locale=en   //Fredrik ... View more

Hi! It is very hard so answer anything at all with so little information 🙂   Can you provide some kind of screen shot or more of what you want to achieve?   If you want a pie chart to filter a list of details, you can create an interaction between the two objects.   //Fredrik ... View more

Hi! Can more filters to reduce the number of rows and then sorting the table help the user? If so they can use shift+mouse to select first-to-last rows. //Fredrik ... View more

Hm, i don't think you can have different length/depth/levels on the branches. One thing you can do is to create your own categories and apply a rule in them so that the next level is the same as the one before: - Mammal    - Dog         - Labrador     Cat         - Cat   Lets say you have the following categories: - Level1 (mammal) - Level2 (dog,cat) - Level3 (labrador)   Then you would create a new level3, lets say level3_new 🙂 and do the calculation: if level2 = cat then cat else level3   In the cross tab you will have all levels but for cat you will get the same value for level2 and 3, might help you 🙂 ? //Fredrik     ... View more

Hi! Create a new calculated item and do the calculation 🙂   diff = ihsf/actual   Then add it to the table.   //Fredrik   ... View more