topic Re: Copy and paste SAS Studio code to Word Document in SAS Programming

Copy and paste SAS Studio code to Word Document

Sou1 — Thu, 30 Apr 2020 23:45:54 GMT

Hi,

I have been working with SAS 9.4 software and now I am working with SAS studio. With SAS 9.4 it was very easy to "copy and paste" the SAS code to a word document because it keeps the format of SAS (colours, etc.) however I wasn't able to do it with SAS studio, is there any trick to do that simple task keeping the SAS format?

Many thanks!

Re: Copy and paste SAS code to Word Document

Reeza — Thu, 30 Apr 2020 17:01:55 GMT

~~Are you using Paste Special or Paste?~~

Had a chance to test that, doesn't work in my two second test. I had to use the right click code, select and paste special. Even when selecting source formatting the colour was lost.

That's definitely annoying as heck.

One, long, workaround is to paste it into a different editor that does maintain the formatting and then into Word.

NotePad++ and VisualStudio both have extensions to color code your SAS programs.

@Sou1 wrote:

Hi,

I have been working with SAS 9.4 software and now I am working with SAS studio. With SAS 9.4 it was very easy to "copy and paste" the SAS code to a word document because it keeps the format of SAS (colours, etc.) however I wasn't able to do it with SAS studio, is there any trick to do that simple task keeping the SAS format?

Many thanks!

Re: Copy and paste SAS code to Word Document

Sou1 — Thu, 30 Apr 2020 18:19:55 GMT

Many thanks! It's really easy to import the results but the code loses all its format! I'll try that.

Thanks!

Re: Copy and paste SAS Studio code to Word Document

ChrisNZ — Fri, 01 May 2020 02:38:59 GMT

@alexal Do you have any say on SAS Studio features to support or add?

Re: Copy and paste SAS Studio code to Word Document

Kurt_Bremser — Fri, 01 May 2020 08:21:23 GMT

I played around a little. This is an issue in the SAS Studio applet running in the context of the browser, as it does not send the coloring of the code to the clipboard. Other colored text (e.g. the log) is sent with the coloring when doing Copy from the same browser (in my case Safari on a Mac). Only the text in the code tab is copied black-and-white.

Re: Copy and paste SAS Studio code to Word Document

alexal — Fri, 01 May 2020 12:04:12 GMT

@ChrisNZ ,

I've never tried to copy anything from the SAS Studio to Word. I've tried to copy SAS code from SAS Studio running on 9.4 M6 and SAS Viya 3.5, both of them didn't keep text style. Also, I've tried to copy the code from EG 7 and 8 and they do keep text style.

Re: Copy and paste SAS Studio code to Word Document

ChrisNZ — Fri, 01 May 2020 23:52:06 GMT

@alexal I meant: Do you have a way for this shortcoming to appear on the developers' radar?

Re: Copy and paste SAS Studio code to Word Document

Reeza — Sat, 02 May 2020 01:36:27 GMT

@ChrisNZ I added it to the list here:

https://communities.sas.com/t5/SASware-Ballot-Ideas/Enhance-copy-and-paste-options-from-SAS-Studio/idi-p/644644

Not as good as the developers already working on it but a start at least.

Re: Copy and paste SAS Studio code to Word Document

ChrisNZ — Sat, 02 May 2020 01:50:39 GMT

Yes. A clearly marked tombstone in a graveyard allows to at least not forget all these wonderful ideas. ;)Maybe that's a bit harsh.

Re: Copy and paste SAS Studio code to Word Document

Reeza — Sat, 02 May 2020 02:13:46 GMT

I'd say it's harsh since that hasn't been the pattern in the past few years. The recent ones are more monitored and they are marking them as planned or not considered and updating when they implement it.

I do think they should blow away anything older than a few years though, otherwise it does become a graveyard for sure.

Re: Copy and paste SAS Studio code to Word Document

ChrisNZ — Sat, 02 May 2020 03:29:39 GMT

Newer does not mean better. Like #219458 .Maybe look at the top rated ones first instead? I am sure there are nuggets in that 1100-odd list.Had a look at the 78 implemented and it's almost all VA. The EG ones were mostly "already there" rather than "added". I made dozens of suggestions there and I am not optimistic as you can see.

Re: Copy and paste SAS code to Word Document

mkeintz — Sat, 02 May 2020 04:46:58 GMT

You can do a two-stage copy/paste as mentioned elsewhere - copy from sas/studio to SAS Universal Viewer (download from here) and from the viewer to word.

The viewer will re-institute the formatting (looks the same as pc-sas program formatting), and the subsequent paste to word will preserve colors.

Re: Copy and paste SAS code to Word Document

Sou1 — Sat, 02 May 2020 10:25:41 GMT

Will do that!

Many thanks to all for your help!

Re: Copy and paste SAS Studio code to Word Document

ChrisNZ — Mon, 04 May 2020 00:16:48 GMT

I want to believe I contributed to some of the VA additions

https://communities.sas.com/t5/SAS-Visual-Analytics/Large-list-of-suggested-improvements-for-VA-7-2/m-p/268184

even though the evidence points to the simplest and most useful improvements

https://communities.sas.com/t5/SASware-Ballot-Ideas/Add-a-label-field-in-SAS-VA/idi-p/264042

being rejected.

Re: Copy and paste SAS Studio code to Word Document

BrianGaines — Fri, 19 Jun 2020 21:17:25 GMT

Hi @Sou1,

Which version of SAS Studio and which browser are you using?

I am able to copy code from SAS Studio and paste it in Word with the syntax highlighting intact, but only if I use Chrome and only if I copy the code using the "Copy code" icon on the editor's toolbar, which is highlighted in this screenshot:

Here is how it displays after I paste it in Word:

This works for me in both SAS Studio 3.6 and SAS Studio 3.8. It does not work for me if I use the CTRL+C shortcut or if I right click --> Copy. It also does not work for me if I use Firefox instead of Chrome. So the workaround is a little specific, but it at least avoids the need to have an intermediate copy/paste step.

Does this work for you?

-Brian

Re: Copy and paste SAS Studio code to Word Document

VTcmda — Mon, 12 Jul 2021 12:44:07 GMT

I am teaching a SAS course and have had a problem with colors being converted to black in powerpoint when I copy code. I am using FIREFOX for SAS Studio. I also have PC SAS 9.4 so copy the code from Studio, paste it into PC SAS then into powerpoint. Seems to work (I suppose it is similar to using universal viewer or some other program).

Re: Copy and paste SAS Studio code to Word Document

ChrisNZ — Wed, 14 Jul 2021 01:43:50 GMT

Thanks Brian, that is a good workaround to know.

I wonder why so many restrictions though; Is SAS's AXML somewhat malformed?

Re: Copy and paste SAS Studio code to Word Document

Thanh2024 — Sat, 03 Feb 2024 19:46:23 GMT

Brian, I don't see the "Copy code" icon as in the picture. Thanks.