topic Re: RE: PROC REPORT in ODS and Base Reporting https://communities.sas.com/t5/ODS-and-Base-Reporting/RE-PROC-REPORT/m-p/192080#M13044 <HTML><HEAD></HEAD><BODY><P>HI,</P><P></P><P>&nbsp; It would be interesting to find out how you are using PROC REPORT to do an "export" to Excel. Are you using ODS? If so, which destination? Are you using PROC EXPORT? If so, which DBMS= option? Are you using the SAS Libname Engine for Excel?</P><P></P><P>&nbsp; If you are using PROC EXPORT or the LIBNAME engine, you may be able to use "named ranges" to export to a specific row and column position. Search on support.sas.com or in these forum postings for examples of exporting to a named range.</P><P></P><P>&nbsp;&nbsp; If you are using ODS, then the ODS destination output generally starts in A1.</P><P></P><P>cynthia</P></BODY></HTML> Tue, 02 Dec 2014 01:42:21 GMT Cynthia_sas 2014-12-02T01:42:21Z RE: PROC REPORT https://communities.sas.com/t5/ODS-and-Base-Reporting/RE-PROC-REPORT/m-p/192079#M13043 <HTML><HEAD></HEAD><BODY><P>Hi.....I am using PROC REPORT to export and create a table in Excel and I am wondering if it is possible to export only the data (excluding and labels or titles or variable names) to a excel worksheet where the tables starts at column C and Row 3. Thanks in Advance.</P></BODY></HTML> Mon, 01 Dec 2014 19:42:14 GMT https://communities.sas.com/t5/ODS-and-Base-Reporting/RE-PROC-REPORT/m-p/192079#M13043 twildone 2014-12-01T19:42:14Z Re: RE: PROC REPORT https://communities.sas.com/t5/ODS-and-Base-Reporting/RE-PROC-REPORT/m-p/192080#M13044 <HTML><HEAD></HEAD><BODY><P>HI,</P><P></P><P>&nbsp; It would be interesting to find out how you are using PROC REPORT to do an "export" to Excel. Are you using ODS? If so, which destination? Are you using PROC EXPORT? If so, which DBMS= option? Are you using the SAS Libname Engine for Excel?</P><P></P><P>&nbsp; If you are using PROC EXPORT or the LIBNAME engine, you may be able to use "named ranges" to export to a specific row and column position. Search on support.sas.com or in these forum postings for examples of exporting to a named range.</P><P></P><P>&nbsp;&nbsp; If you are using ODS, then the ODS destination output generally starts in A1.</P><P></P><P>cynthia</P></BODY></HTML> Tue, 02 Dec 2014 01:42:21 GMT https://communities.sas.com/t5/ODS-and-Base-Reporting/RE-PROC-REPORT/m-p/192080#M13044 Cynthia_sas 2014-12-02T01:42:21Z