topic Re: proc print and paste in excel-problem that each header fill more then one cell in SAS Programming

proc print and paste in excel-problem that each header fill more then one cell

Ronein — Thu, 19 Mar 2020 09:14:01 GMT

Hello

I am using proc print with label statement.

When I use CNTRL C (Copy) and then CNTRL V(paste) it in excel then the each column header fill more then one cell in excel. I want that each column header will fill only one cell in excel. What is the way to do it?

Re: proc print and paste in excel-problem that each header fill more then one cell

Kurt_Bremser — Thu, 19 Mar 2020 09:21:09 GMT

Use ODS EXCEL to directly create the Excel file. SAS provides a tool for this, so why not use it?

Re: proc print and paste in excel-problem that each header fill more then one cell

andreas_lds — Thu, 19 Mar 2020 10:22:47 GMT

Please post the code you are using including data illustrating the problem.

I was not able see it when using EG 7.15 or 8.2 with Excel 2016.