topic Re: Printing from table viewer in SAS Studio

Printing from table viewer

Tom — Tue, 04 Feb 2020 21:12:53 GMT

Is there anyway to save the output from the PRINT button in the table viewer in SAS/Studio?

When I filter the data and click on the printer icon to print a copy of what I have selected it first opens a tab with the print results and then opens the PRINT functionality on my PC asking me what printer to send it to.

But I don't want to send it anywhere. I just want to use the nice output that it just opened in the new tab. But when I cancel the actual print part that window disappears also.

Re: Printing from table viewer

JackHamilton — Tue, 04 Feb 2020 22:38:51 GMT

How do you want to use it? What format do you want to save it in?

If you want to do something horrendous, save it as an XPS file, rename to a ZIP file, open it, and somewhere down in the directory tree there's an XML file containing the data.

Another possibility is to set up a Generic Text driver and print to that. Unfortunately it appears that delimiters are not included:

         ObsName SexAgeHeightWeight
           1AlfredM  14 69.0112.5
           2AliceF   13 56.584.0
           3BarbaraF 13 65.398.0
           4CarolF   14 62.8102.5
           5HenryM   14 63.5102.5
           6JamesM   12 57.383.0
           7Jane F   12 59.884.5
           8JanetF   15 62.5112.5
           9JeffreyM 13 62.584.0
          10John M   12 59.099.5
          11JoyceF   11 51.350.5
          12Judy F   14 64.390.0
          13LouiseF  12 56.377.0
          14Mary F   15 66.5112.0
          15PhilipM  16 72.0150.0
          16RobertM  12 64.8128.0
          17RonaldM  15 67.0133.0
          18ThomasM  11 57.585.0
          19WilliamM 15 66.5112.0

There might be a "print to csv" driver out there somewhere.

Re: Printing from table viewer

Tom — Tue, 04 Feb 2020 22:56:55 GMT

I don't want to save it at all. I just want to LOOK at it. The printout is much easier to look at than the row limited view of the browser.

I did find one work around. There is an icon just to the left of the print icon that will create a new program window with code to make a table based on the way your current view is setup. You can run that.

Or better delete the line with the CREATE table... part of the query. And the PROC DATASETS and PROC PRINT steps. (and also the spurious RUN statement in the middle of the PROC SQL step). and then run it.