Hi, i have a bar chart with 4 columns, after some filtering, one of the column frequency goes to 0 and that column disappeared from the chart.    May I know if it's possible & how to show that column even though the frequency for that column is zero on SAS VA?    Any idea/help will be greatly appreciated. Thank you! 🙂 ... View more

Hi,    I'm trying to get the count of previous period (eg year) in data preparation which will gives me a new column of count. An example of the output will be:     I'm really unsure of how to create the prev year column though. I managed to get this output through using Aggregated Measure > Relative Period function in Report Designer, however due to other requirements this method is not feasible for me.    Hence, I need to somehow create a new column in data query to get the count of previous periods.   I tried to create a sub-query with a newly created column called Prev_year, which outputs me the correponding previous year (eg 2011 > 2010) and added the NUM_CNT inside the sub-query, however this didnt do the trick. INTNX('year', BP13_CANCEL_APPLICATION.DTE_CANCEL, -1, 'b')   Any idea how I can go about doing this? Any help will be greatly appreciated. Thank you 🙂   ... View more

Hi, I'm trying to find the percentage difference of counts from previous period (eg previous year/quarter/month). I'm currently using the aggregated measure way in report designer where the percentage difference is easily generated by SAS VA. However, this approach will result in the first period percentage column in the crosstab to be empty (since there isn't any previous period). So for instance, the first period on my crosstab is 2011, the percentage difference between 2010 & 2011 will not be shown (refer to image) since 2010 is not in the crosstab and I'm not planning to display 2010 on the crosstab. However, I do have data for 2010.  The SQL code for the aggregated measure i'm currently using is    ( RelativePeriod(_Sum_, 'NUM_CNT'n, 'DTE_CANCEL'n, _Inferred_, 0, _Full_, {Date}) - RelativePeriod(_Sum_, 'NUM_CNT'n, 'DTE_CANCEL'n, _Inferred_, -1, _Full_, {Date}) ) / Abs(RelativePeriod(_Sum_, 'NUM_CNT'n, 'DTE_CANCEL'n, _Inferred_, -1, _Full_, {Date}))   Hence, I'm thinking if it's possible to make the percentage difference statis by defining it in the data query whereby I have a list of percentage difference generated for different period and just place it in the table.   However, I'm not sure if this is possible or how to go about doing it.    I'm open to new ideas and suggestions. Any help will be greatly appreciated.    Thank you very much! ... View more

Hi, I'm trying to display only the last 12 quarters of data in a bar chart form in SAS VA. I came up with a SQL expression using INTNX function that returns me the quarters of DTE_CANCEL in YYQ format. However, I'm not sure how to filter to display only the most recent 12 quarters in Report Designer.     I'm quite new to SAS VA so any help/idea will be greatly appreciated. Thank you 🙂     INTNX('Qtr', BP13_CANCEL_APPLICATION.DTE_CANCEL, 0,'b')   ... View more