Hi,   I'm having a very frustrating issue using proc export. I've seen that a lot of people have had similar issues but I've not found anything that is quite the same as this.   I'm using Enterprise Guide 7.13 and am trying to export data to an excel file. In the process flow where my data originates, the export code produces an error: -   40 proc export data = rollrate.new_to_one_plus outfile = "/share/new_template.xlsx" dbms = xlsx 40 ! replace; 41 sheet = NEW_TO_ONE_PLUS; 42 run; Error creating XLSX file -> /share//new_template.xlsx . It is either not an Excel spreadsheet or it is damaged. Error code=8000101D Requested Output File is Invalid ERROR: Export unsuccessful. See SAS Log for details. NOTE: The SAS System stopped processing this step because of errors. NOTE: PROCEDURE EXPORT used (Total process time): real time 0.01 seconds cpu time 0.00 seconds   However if I run exactly the same code in a separate instance of EG where I have successfully used proc export before, it works: -   100 proc export data = rollrate.new_to_one_plus outfile = "/share/new_template.xlsx" dbms = xlsx 100 ! replace; 101 sheet = NEW_TO_ONE_PLUS; 102 run; NOTE: The export data set has 3 observations and 53 variables. NOTE: "/share/new_template.xlsx" file was successfully created. NOTE: PROCEDURE EXPORT used (Total process time):   Both instances of EG are connected to the same server and I have tried opening a new instance of EG in case it was flawed in some way but I get the same outcome each time. This is really annoying as I just can't fathom out why this would be happening so just wondering if anyone had any ideas. I've closed Excel down completely to make sure the file isn't somehow open behind the scenes but again, this makes no difference.   Thank you, Rob ... View more

Hi,   I've done a lot of searching on this and have not been able to find the answer so am asking the experts.   I have a number of pieces of monthly MI that I produce. I produce the updated data in SAS for the new month, then export it into Excel. I currently copy and paste the exported data into an Excel template file which has the data on the first tab, in the form of an Excel table (as in Insert Table). I then pull out the specific data I need for different charts using the SUMIFS formula and subsequent tabs and then produce charts from those tables. I use the Table as in my SUMIFS formulas I can just use the Excel column as the lookup reference, whereas in a standard worksheet, I have to apply the formula to a specific range of cells.   What I am trying to work out how to do is to export the data directly into my template whilst preserving the Table in Excel.   Is this actually possible? I know proc export just replaces the data and formatting, and I've had a look at some possible solutions that I've found online such as using ods but unless I'm doing it wrong (which I freely admit is entirely possible) I can find a way to add the data into the table. I don't need to retain the existing data in the Excel table as I overwrite it each month, but do want the table format to remain in place.   As always, any suggestions or advice will be gratefully received.   Many thanks, Rob ... View more