topic VA crosstab report transpose a row group in SAS Visual Analytics

VA crosstab report transpose a row group

ChrisWu — Thu, 01 Feb 2018 16:22:47 GMT

Table 1 is a VA Crosstab Report

I wish to get the resulting following Table 2a and 2b

1) How can the TIME_PERIOD2 be transposed such that CA_FORM_SUM is assigned as Year1, Year2, Year3?

Thanks,

Re: VA crosstab report transpose a row group

akulkarni — Fri, 02 Feb 2018 19:59:29 GMT

I can think of two ways to do that.

1. In the crosstab properties, you can have TIME_PERIOD2 as a column and it will categorize your measures. The problem is all your measures will be categorized by TIME_PERIOD2.

2. Another option is to create calculated items for each year. For example, IF TIME_PERIOD2 = YEAR1 then 'Year 1' = CA_FORM_SUM ELSE 'Year 1' = 0

Hope this helps.

Re: VA crosstab report transpose a row group

ChrisWu — Wed, 07 Feb 2018 14:49:40 GMT

ok,.. my findings

Option 1: Select and activate the Chart, then Right-side Bar> Data Role to move Data Item to Columns;

Option 2: New Data Item > Calculated item > text: Does Not understand SAS code 😞