topic Re: Saving Excel Workbook with New Name in Microsoft Integration with SAS

Saving Excel Workbook with New Name

JustSomeGuy — Tue, 14 Jan 2014 22:19:19 GMT

I have some SAS code that writes out to a sheet in an Excel workbook. Currently I'm just using proc export dbms=excelcs but can also use libname with pcfiles if neccesary. Is it possible for SAS to save the workbook with a different name after it's finished writing out to the sheet it updates?sas

Re: Saving Excel Workbook with New Name

Reeza — Tue, 14 Jan 2014 22:42:26 GMT

Are you using SAS Office Add In? or Base SAS?

And what kind of name would you like? If you specify a new workbook in your proc export it will go to that workbook, but how will you specify it.

Re: Saving Excel Workbook with New Name

JustSomeGuy — Wed, 15 Jan 2014 18:10:16 GMT

Reeza,

I'm opening an existing workbook, writing out a new sheet, and then I want to save the workbook with a different name. Basically the workbook is a template, so I want to open the template, write out the new data and then save it so it reflects the data in there. This way I can run my code multiple times and end up with multiple workbooks populated instead of having to put a new template workbook in the folder each time. With proc export is it possible to specify a workbook to open and then specify a different one to save as?

Re: Saving Excel Workbook with New Name

Reeza — Wed, 15 Jan 2014 18:58:25 GMT

No, but you can use some other options, such as x command to copy and save the work book with a different name and then export to that new file.

Can you provide more info, specifically, operating system, excel version, if you have X command

Re: Saving Excel Workbook with New Name

JustSomeGuy — Wed, 15 Jan 2014 19:18:18 GMT

SAS is running on 64-bit linux and I have Excel 2010. I'm not sure if we X command but I do know we have SAS/ACCESS Interface to PC Files and have the PCFILES Server set up.

Thanks a lot for your help!