topic Re: Formatting in SAS VA. in SAS Visual Analytics

Formatting in SAS VA.

killiangavin — Fri, 28 Jun 2019 11:10:19 GMT

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

Re: Formatting in SAS VA.

Sam_SAS — Fri, 28 Jun 2019 13:42:20 GMT

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

Re: Formatting in SAS VA.

killiangavin — Fri, 28 Jun 2019 14:01:24 GMT

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.

Re: Formatting in SAS VA.

Sam_SAS — Fri, 28 Jun 2019 14:05:31 GMT

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.

Re: Formatting in SAS VA.

killiangavin — Fri, 28 Jun 2019 14:13:12 GMT

Thanks Sam,

I am using SAS Visual Analytics version 7.3 .

Killian

Re: Formatting in SAS VA.

Sam_SAS — Fri, 28 Jun 2019 14:40:25 GMT

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.

Re: Formatting in SAS VA.

killiangavin — Fri, 28 Jun 2019 14:46:23 GMT

The larger font size worke perfect.

Thank you ,

Killian