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
... View more