Formatting in SAS VA.

[killiangavin]

Hi,

I'm currently building a crosstab in SAS VA and I am having trouble with some of the formatting. 

Firstly is it possible to change the width and colour of rows in a crosstab? At the moment my rows are too skinny.

Secondly Is it possible to include a row above my column headings? I want to split my columns into two separate sections and need to include a row at the top which will contain the two different headings.

Any help would be very much appreciated.

Regards,

Killian 

[Sam_SAS]

Hello,

Which version of VA do you have? In 8.3 there are some options to control the formatting of your rows. I am not sure offhand about earlier versions.

I don't think the second thing you are asking for is possible. You want to include two different levels of column headings, where the columns are separate variables and not hierarchy members?

Sam

[killiangavin]

Hi Sam,

Thanks for your reply. I've attach a snapshot of the way i'd like to format the headings and underneath the sub-headings. 

[Sam_SAS · Accepted solution]

If you structured your data so that "Last Month", "Last Quarter", and "YTD" were values of a single column, then you could make a hierarchy and assign that hierarchy to the crosstab to get this result.

Can you share the version of VA that you have? This is important for us to help you further.

[killiangavin]

Thanks Sam,

I am using SAS Visual Analytics version 7.3 .

Killian 

[Sam_SAS]

Thanks Killian,

When you say your rows are too skinny, do you actually mean the columns? You can click and drag the edges of the column headings to resize the columns.

If you want the rows to be taller, you might try setting a larger font size for the row headings. This will make the value cells in the crosstab taller and increase white space above and below the cell value.

There are some other options available in newer versions of VA, but I think this is your best bet in 7.3.

[killiangavin]

The larger font size worke perfect.

Thank you ,

Killian