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.
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.
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.
It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.
What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.