hI also am working on something similar and hope someone can help. I am exporting data to an excel file, but in addition, I have other sheets in that file that I do not want to overwrite. basically, they are charts and graphs that will update from the updated data exporting from sas into excel. i've tried using the following, but SAS doesn't like it when i use the outfile or excelcs options, and also i was having trouble with the server. i'm not quite sure what to put for my server name. proc export data = DATASET1 outfile = "&folder.FILENAME_&dt..xls" dbms = excelcs replace; sheet = "EXCELSHEET1"; SERVER = "&pc"; run; just for some background. I'm running EG from a server 32 bit and have 32 bit Excel and have installed PC File Server. i am able to use this code: proc export data = TD file = "&folder.FILENAME_&dt..xlsx" dbms = xlsx replace; sheet = "EXCELSHEET1"; run; But, the other two sheets in the file get wiped out and I don't want them to. Is there a way for me to prevent that from happening? I've tried multipe ways taking out replace or using different sheeet names, but nothing seems to work. Thank you for any help I can get!
... View more