The SAS Output Delivery System and reporting techniques

RE: PROC REPORT

Reply
Regular Contributor
Posts: 221

RE: PROC REPORT

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.

SAS Super FREQ
Posts: 8,647

Re: RE: PROC REPORT

HI,

  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.

cynthia

Post a Question
Discussion Stats
  • 1 reply
  • 287 views
  • 0 likes
  • 2 in conversation