SAS Support Communities

1) Not within VA; you have to export the model and then you can change the score code.  For models that use an ASTORE table for the scoring process, I don't think you can manipulate the model in any detailed way.   2) No; you would need to use a dedicated forecasting product for that (e.g. Forecast Studio).   3) Do you mean create a new calculated column?  This is available from the Data panel.     4) There are some limits, usually on the number of variables that you can assign to a model.  Rows should not be limited, although Forecasting does require time binning to avoid plotting too many points.   5) I don't think so.  The data exports as a nice Excel sheet, but the charts/graphs download as images or PDFs in a separate feature (export data versus 'print').  The print feature does also print the details tables, which contain the model parameters. ... View more

Okay, the simplest way I know to get the growth number to show is to assign the aggregated item to a chart where it would show as a single element.  For example, if you use the same rank you describe on a pie chart, you would get the aggregated value for only one slice (showing as the whole wheel).  You could then use the style and properties tabs to make the numeric value show very large and provide a title. ... 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

Do you mean you have a column called 'name' and you want to sort the table by its values?  Or are you trying to sort the columns by name (I don't think that is possible in VA)?   If just sorting on a single column, it is possible that it is working but taking a very long time to return the result.  How big is the table/data source? ... View more