No, its not.  SAS can create Excel files with data, formatting, and some features, like formulas.  It does not however encapsulate the whole suite of Excel abilities.  To do such a thing you would create your template Excel file, and get that to read in your data from a SAS exported file, or have some VBA code to create it from an exported file. If your that into using Excel that you need these types of things, then why bother with SAS?  Just dump out to CSV, then have Excel/VBA process that data into the format you need. ... View more

This appears to be the same question as another post. This is the response I gave for that one.    If I understand what you are asking, I was able to do this by creating a filter on the target object like this:      This is the text version    ( 'Type'n NotIn 'Type Multi-Select'p )   Where Type is the data item in my target object, and Type Multi-Select is a multi-select parameter that is assigned to the Parameter role for a List Control. ... View more

There are a couple ways to get what you want, but I think the most flexible way is to create a parameter 'topN_cutoff' and a calculation 'topN_revenue' like:   if 'revenue'n > 'topN_cutoff' return 'revenue'n else 0   Then you can create an aggregated calculation like this:   sum [_ForAll_] ('topN_revenue'n) / sum [_ForAll_] ( 'revenue'n )   The only sticky point is that you need to know what the cutoff revenue is beforehand.  For any given data, it is easy to find it out with a list table and a rank applied for top 3 (or whatever rank).  But I don't think VA has an operator you can use to determine it automatically.  The closest would be the Percentile operator which gives you the revenue value in the data for a specified percentile, but that won't correspond to a specific numeric rank (unless, again, you already know the data and can just determine what percentile corresponds with top N). ... View more

Hi, Unfortunately some of the advanced analytics visualization are not supported in the report designer application back in version VA 7.x. This has been resolved in VA 8.x since both have been merged into a single interface. Hopefully a version you can upgrade to soon?   There isn't a good work-around available other than taking an image snapshot of the related visualization I believe or of course use a different visualization altogether.   Regards, Falko ... View more

I don't think it is possible. I think you can achieve the same by using a table with the users, filter that table upon current user (SUB::...), add drop down with the user names from that table (make it mandatory), use a parameter in that drop-down, use the parameter in your calculation.   From what I know you can only use identi-driven-identities in filter. (http://support.sas.com/documentation/cdl/en/birlpug/64774/HTML/default/viewer.htm#n1hmmmul9805q6n1mfp0ask44lh0.htm)   //Fredrik ... View more

Ok! If the custom graph is accesible for the end users (public should do it) then you don't need to do anything else 🙂 //Fredrik ... View more