topic Re: SAS Report html blue doesn't keep format when paste into Excel in SAS Enterprise Guide

SAS Report html blue doesn't keep format when paste into Excel

ASC1 — Thu, 24 Oct 2024 12:33:12 GMT

When I copy a SAS Report that's formatted html blue then paste into Excel, the html blue format isn't retained when I select Keep Source Formatting.

We recently upgraded to version 8.4 Update 2 (8.4.2.22) (64-bit) from 7.1. Before the upgrade, the format of the SAS Report would be retained when pasting into Excel.

The need to copy and paste is on an ad-hoc basis so I don't want to used ods excel to export. How can I retain the SAS Report formatting when pasting into Excel?

Re: SAS Report html blue doesn't keep format when paste into Excel

PaigeMiller — Thu, 24 Oct 2024 12:43:00 GMT

Instead of copy/paste, use ODS EXCEL

Example:

ods excel file='temp.xlsx';
proc something data=whatever;
...
run;
ods excel close;

Re: SAS Report html blue doesn't keep format when paste into Excel

ASC1 — Thu, 24 Oct 2024 13:00:50 GMT

ODS EXCEL isn't ideal because the SAS Report being copied/pasted is from a step later in a process. The report is being pasted into a file previously exported using ODS EXCEL so I don't want to recreate it or create a second exported file that has to be merged into the original file.

Process is:

Initial file is created using ODS EXCEL

User makes selections in the exported file, then uploads the file to update tables on a server

A SAS Report with a summary of selections and calculations is created - this is what we have been able to paste into the original file and retain html blue when using version 7.1

Is there an Add-In that's needed or a setting I need to change to keep the formatting when pasting?

Re: SAS Report html blue doesn't keep format when paste into Excel

ballardw — Thu, 24 Oct 2024 14:21:43 GMT

Please describe exactly what "format" is involved. Not the name but the actual property- font, font size, cell color, borders, what.

Also what output is this copied from?

Note that copy/paste is going to be limited to what the clipboard can get which varies depending on source.

Re: SAS Report html blue doesn't keep format when paste into Excel

ASC1 — Thu, 24 Oct 2024 14:45:18 GMT

In the above: The left is how it appears in Excel when pasted. The right shows how it appears in the SAS Report.

Below shows the Style selected for SAS Report.

Re: SAS Report html blue doesn't keep format when paste into Excel

ChrisNZ — Thu, 24 Oct 2024 15:21:15 GMT

There are various menu entries iirc. Have you tried them? I don't remember the exact phrase, but something like Sent to or Open with or View with.