How do I create a new tab in an existing excel spreadsheet?

cjmfpf — Thu, 16 Aug 2018 21:32:11 GMT

I am trying to figure out how to write in a new tab in an existing excel spreadsheet. I have a spreadsheet set up that takes the SAS output and transforms it into a nice-looking table over the course of a couple of tabs. I ideally would like to have SAS output a tab into that document.

proc export data=data.txmsi 
			dbms=excel
			outfile="C:\\SAS Testing Add Tab\testexceldoc.xls" 
			REPLACE;
	sheet="Data";
run;

I found some code (above) for a proc export step, but my company apparently doesn't have any SAS/ACCESS products so I can't seem to find a dbms option that works and also allows me to have a sheet. Is there any way to get around this using the proc export step, or is there some different way to output a tab into an existing excel spreadsheet? I am using SAS version 9.4.

Thank you!

Carla

Re: How do I create a new tab in an existing excel spreadsheet?

Reeza — Thu, 16 Aug 2018 22:08:56 GMT

http://www.sascommunity.org/wiki/A_Poor/Rich_SAS_Users_Proc_Export

or DDE but that's a security risk. Infinitely easier with SAS/ACCESS to PCFILES.

@cjmfpf wrote:

I am trying to figure out how to write in a new tab in an existing excel spreadsheet. I have a spreadsheet set up that takes the SAS output and transforms it into a nice-looking table over the course of a couple of tabs. I ideally would like to have SAS output a tab into that document.
proc export data=data.txmsi 
			dbms=excel
			outfile="C:\\SAS Testing Add Tab\testexceldoc.xls" 
			REPLACE;
	sheet="Data";
run;
I found some code (above) for a proc export step, but my company apparently doesn't have any SAS/ACCESS products so I can't seem to find a dbms option that works and also allows me to have a sheet. Is there any way to get around this using the proc export step, or is there some different way to output a tab into an existing excel spreadsheet? I am using SAS version 9.4.

Thank you!

Carla

topic Re: How do I create a new tab in an existing excel spreadsheet? in SAS Programming

How do I create a new tab in an existing excel spreadsheet?

Re: How do I create a new tab in an existing excel spreadsheet?