topic Format a Data Type for a Row not a Column in SAS Visual Analytics

Format a Data Type for a Row not a Column

OscarBoots1 — Thu, 01 Jun 2017 02:45:47 GMT

Hi Forum I'm using a List table to display a report that contains text headings in Row 1 & Column 1, the Cells that intersect these headings need to have Formatting applied across the Rows & not the Columns. Is there a way or workaround (coding) to get the individual Rows or certain cells to apply Formatting such as Row 2 would need to be Currency, where Row 3 should be a Percentage etc. I'm finding that I get the formatting applied under the top row headings for the whole Column. I know this is how it should behave but I need to use a List table for appearances sake & I need the Data to be correct in Format. Any suggests ideas all welcome.Thanks

Re: Format a Data Type for a Row not a Column

SASKiwi — Thu, 01 Jun 2017 03:01:04 GMT

The only way I can think of doing this would be to create a List Table comprised of only character columns. Within each character column you can format a numeric value however you wish. For example a percentage might look like - " 75.48%" (the quotes are purely to delineate the text but would not show in the report). These character columns most likely would be added outside of VA. You could also keep non-displayed numeric equivalent versions in the data for use in formulas and other reports.

Re: Format a Data Type for a Row not a Column

OscarBoots1 — Thu, 01 Jun 2017 03:05:20 GMT

Thanks SASKiwi, I'll give it a try. Cheers

Re: Format a Data Type for a Row not a Column

OscarBoots1 — Thu, 01 Jun 2017 04:35:45 GMT

Thanks SASKiwi, I lked your suggestion & will keep in mind for another project as I decided to create several List tables with just a Heading & 1 row of data each & place them one on top of the other. There's a bit of a waste of space but I get control of the Data format & Display rules this way. Thanks Again !!