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.
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
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.