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