12-01-2014 02:42 PM
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.
12-01-2014 08:42 PM
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?
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.
If you are using ODS, then the ODS destination output generally starts in A1.