https://communities.sas.com/t5/ODS-and-Base-Reporting/How-to-output-SAS-data-to-an-existing-Excel-file/m-p/36095#M5190 The best reference I know about on using named ranges is this paper:<BR /> <A href="http://www2.sas.com/proceedings/sugi31/024-31.pdf" target="_blank">http://www2.sas.com/proceedings/sugi31/024-31.pdf</A><BR /> <BR /> cynthia Sat, 05 Jun 2010 11:56:21 GMT Cynthia_sas 2010-06-05T11:56:21Z https://communities.sas.com/t5/ODS-and-Base-Reporting/How-to-output-SAS-data-to-an-existing-Excel-file/m-p/36092#M5187 Hello,<BR /> <BR /> Actually we are generating lot of Excel files using DDE. Unfortunately, we are launching the process at the SAS server and often it terminates by error (typically: Excel opens some interactive window and is waiting for a response - and that is a real problem by automatic processing).<BR /> <BR /> Our intention is try to avoid the DDE usage and replace it by some technique that does not need to open Excel. (But we need to write into an EXISTING Excel spreadsheet, we also use Excel graphs... such solutions like ODS HTML does not serve us... <span class="lia-unicode-emoji" title=":disappointed_face:">😞</span><BR /> <BR /> I have found that theoretically one possibility is to use LIBNAME statement with Excel "Named ranges", but I do not achieve to write the data without varnames. Also I do not know if there is some limitation for the number of Named ranges in one Excel File. <BR /> <BR /> Does anyone know how to solve this?<BR /> Is there any way how to omit the varnames when using LIBNAME (engine:xls) for output?<BR /> Or better: Is there any other elegant solution?<BR /> <BR /> Thank you in advance!!<BR /> <BR /> Jaroslav Tue, 05 Aug 2008 10:19:25 GMT https://communities.sas.com/t5/ODS-and-Base-Reporting/How-to-output-SAS-data-to-an-existing-Excel-file/m-p/36092#M5187 deleted_user 2008-08-05T10:19:25Z https://communities.sas.com/t5/ODS-and-Base-Reporting/How-to-output-SAS-data-to-an-existing-Excel-file/m-p/36093#M5188 I have the same problem using excel named ranges and sas libname excel engine. How to write to excel without varnames? I use SAS 9.1.3 Service Pack 4 and Excel 2003.<BR /> <BR /> thank you,<BR /> JC Fri, 04 Jun 2010 17:53:47 GMT https://communities.sas.com/t5/ODS-and-Base-Reporting/How-to-output-SAS-data-to-an-existing-Excel-file/m-p/36093#M5188 jc671 2010-06-04T17:53:47Z https://communities.sas.com/t5/ODS-and-Base-Reporting/How-to-output-SAS-data-to-an-existing-Excel-file/m-p/36094#M5189 Hi:<BR /> The best reference on using named ranges is in this user group paper:<BR /> <A href="http://www2.sas.com/proceedings/sugi31/024-31.pdf" target="_blank">http://www2.sas.com/proceedings/sugi31/024-31.pdf</A><BR /> <BR /> As for your question about VARNAMES, I believe that when the LIBNAME engine is appending data, it can write without VARNAMES -- but I think you may need a named range for that. This would be a question for Tech Support...since it's not entirely clear to me what you mean by omitting the varnames.<BR /> <BR /> cynthia Sat, 05 Jun 2010 11:55:42 GMT https://communities.sas.com/t5/ODS-and-Base-Reporting/How-to-output-SAS-data-to-an-existing-Excel-file/m-p/36094#M5189 Cynthia_sas 2010-06-05T11:55:42Z https://communities.sas.com/t5/ODS-and-Base-Reporting/How-to-output-SAS-data-to-an-existing-Excel-file/m-p/36095#M5190 The best reference I know about on using named ranges is this paper:<BR /> <A href="http://www2.sas.com/proceedings/sugi31/024-31.pdf" target="_blank">http://www2.sas.com/proceedings/sugi31/024-31.pdf</A><BR /> <BR /> cynthia Sat, 05 Jun 2010 11:56:21 GMT https://communities.sas.com/t5/ODS-and-Base-Reporting/How-to-output-SAS-data-to-an-existing-Excel-file/m-p/36095#M5190 Cynthia_sas 2010-06-05T11:56:21Z