Hello, I would like to export 1 table In particular range of a sheet that already contains data. I have indicated in the code to put the export from cell B6. proc export data=data outfile="/Y/test/invoice" /* name and location of Excel file */ dbms=xlsx /* Excel file format */ replace; range='B6:F6'; /* replace the file if it already exists */ sheet="base"; /* name of the sheet in Excel */ *putnames=no;/* start cell in Excel */ /* start from the second line without the headers */ run; But with this code, it does export the table to the right cells but it overwrites what was already there. I don't see what option to add to tell it to keep the data that is already in the file. Thanks in advance for any help
... View more