DATA Step, Macro, Functions and more

Adding a tab / sheet to an existing workbook / .xlsx file

Reply
Contributor
Posts: 21

Adding a tab / sheet to an existing workbook / .xlsx file

Good moring,

wondering if this great comunity can help m eiwth the following issue im having.

 

I have a script that creates an xls file from various datasets,

 

after creating the xls fle, i want to append a new worksheet(tab)

 

I cant seem to wrap my head around how i would do this.

 

 

the one i create using the script is dynamic in name

 

daily&yymm..xlsx"" "; so it will add the current date to the file,

 

and the workbook that contans the new tab is called  Dashboard.xls (Tab name,DASH)

 

 

Frequent Contributor
Posts: 129

Re: Adding a tab / sheet to an existing workbook / .xlsx file

Posted in reply to Bellefeuille

Hi,

 

You can use the SAS libname engine

________________________

- Cheers -

Super User
Posts: 19,822

Re: Adding a tab / sheet to an existing workbook / .xlsx file

Posted in reply to Bellefeuille

It depends a bit on your version of SAS and your version of excel. 

 

If you're creating an XLS file try using the EXCEL libname to add the data or even PROC EXPORT with DBMS=XLS or DBMS=EXCEL. 

 

Community Manager
Posts: 2,955

Re: Adding a tab / sheet to an existing workbook / .xlsx file

Posted in reply to Bellefeuille

PROC EXPORT with DBMS=XLSX supports adding sheets to an existing workbook.  I have some examples of using ODS EXCEL (to create  a workbook) and PROC EXPORT (to add new sheets) in this article.

Ask a Question
Discussion stats
  • 3 replies
  • 132 views
  • 0 likes
  • 4 in conversation