BookmarkSubscribeRSS Feed
RAmarapuram
Obsidian | Level 7

Hi Team

We are using SAS EG 7.1 version and had SAS Add-In for microsoft office installed.

I am facing issue while trying to copy & paste an tabular output generated into MS EXCEL . I went through a couple of blogs and have tried using the Result Formats --> HMTL from SAS Report (which is the default).

After changing the report formats to HTML, I am able to get the tabular format of the data, but the data is NOT indented properly into cell. The tabular data is getting copied and the cells gets merged.I am unable to compute the data in excel since the cells have merged.

On SAS EG 4.1, I was able to copy-paste the data as is and the data used to get copied perfectly into each cell properly which helped me in computing the data in excel.

Could you please advice and suggest for a workaround on this.

Thanks

Raj

2 REPLIES 2
RW9
Diamond | Level 26 RW9
Diamond | Level 26

Totally off topic, but you have SAS and you are computing in Excel?

As for copy/paste, I don't know, but you can always export the data.

Kurt_Bremser
Super User

With SAS Add-In installed, just create a dataset in SAS and read that via the Add-In into Excel.

If you don't have the Add-In anymore, use tagsets.excelxp to create a .xml readable by Excel.

Or create a .xlsx with libname xlsx (SAS 9.4 from TS2)

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

SAS Enterprise Guide vs. SAS Studio

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.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 2 replies
  • 919 views
  • 0 likes
  • 3 in conversation