topic Re: Split a dataset row across 2 lines in SAS Visual Analytics

Split a dataset row across 2 lines

Mikey03 — Fri, 27 Apr 2018 19:56:30 GMT

Hi,

Using SAS VA 7.3.

Is it possible to split a single dataset row across 2 lines in a list table?

So for example if a dataset had 10 columns and you wanted to fit 5 columns on line1 and 5 on line2:

Header1: Col1 Col2 Col3 Col4 Col5

Header2: Col6 Col7 Col8 Col9 Col10

-------------------------------------------------------

Dataset row1 - line1: Col1 Col2 Col3 Col4 Col5

Dataset row1 - line2: Col6 Col7 Col8 Col9 Col10

Dataset row2 - line1: Col1 Col2 Col3 Col4 Col5

Dataset row2 - line2: Col6 Col7 Col8 Col9 Col10

This is to resolve an issue where a dataset row is truncated in a PDF output as the row cannot fit on a single line on an A4 page.

2nd question: In v7.3 excel outputs cannot be produced (I believe?) - has this been resolved in later versions?

Many thanks for your help.

Re: Split a dataset row across 2 lines

alineagostini — Fri, 27 Apr 2018 20:07:37 GMT

Hi,

The answer to your second question is there is a known limitation to export Excel or CSV files when using the Modern Viewer in the version 7.3. According to the article below, "All of these actions and features are supported in the classic viewer".

Known limitations in the modern version of SAS® Visual Analytics Viewer 7.3 and 7.4

Re: Split a dataset row across 2 lines

SASKiwi — Fri, 27 Apr 2018 22:44:42 GMT

Regarding splitting dataset rows - as far as I'm aware that is not possible in any current version of VA. In my experience VA 7.4 does a better job with exporting data. If I get a chance I'll check out how it handles long data rows in PDFs.

Re: Split a dataset row across 2 lines

Mikey03 — Sat, 28 Apr 2018 09:57:57 GMT

Thanks SASKiwi. Yeah would be good to know if 7.4 does a better job with wide outputs in PDF.

We have used base SAS before and there we have a good amount of control of the PDF document but in SAS VA this control seems to be missing. Would this also be true for the later SAS VA versions up to 8.1?

Thanks for your help.

Re: Split a dataset row across 2 lines

SASKiwi — Sat, 28 Apr 2018 22:02:00 GMT

In VA 7.4 when you print to PDF there is a "expand clipped content" option in the PDF settings box. When I tried it, content that doesn't fit on a page is printed on the following. Perhaps not quite what you want but definitely better. Check to see if this option is in 7.3.

Of course Base SAS provides the greater flexibility of a coding language. With VA you are trading off some flexibility with the ease-of-use and speedy development of a point-and-click tool.

Re: Split a dataset row across 2 lines

Mikey03 — Mon, 30 Apr 2018 17:38:05 GMT

Hi SASKiwi. The "expand clipped content" is available in 7.3 but it shrinks the content onto a single line in the output which for very wide rows makes the content almost unreadable. It also removes page headers and titles. So all-in-all not a great experience for end users.

My guess is there must be an answer out there somewhere as its quite a basic requirement to show a dataset row across multiple output lines.

Re: Split a dataset row across 2 lines

SASKiwi — Mon, 30 Apr 2018 22:26:45 GMT

@Mikey03 - I didn't see any content shrinkage when I tested this in 7.4 - all the text was perfectly readable, so I suspect it is fixed in this release. Do you have any plans to upgrade?