Exploring, predicting and reporting with SAS Visual Analytics and SAS Visual Statistics

VA crosstab report transpose a row group

Reply
Occasional Contributor
Posts: 7

VA crosstab report transpose a row group

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,

 

Occasional Contributor
Posts: 8

Re: VA crosstab report transpose a row group

[ Edited ]

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.

Occasional Contributor
Posts: 7

Re: VA crosstab report transpose a row group

Posted in reply to akulkarni

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 Smiley Sad

Ask a Question
Discussion stats
  • 2 replies
  • 263 views
  • 0 likes
  • 2 in conversation