topic How to print report in a specific cell in excel in ODS and Base Reporting

How to print report in a specific cell in excel

vicky07 — Tue, 25 Jul 2017 03:47:26 GMT

Hi,

I am using SAS 9.3 version and I am trying to output some data to excel starting from a particular row and column number. In the attached excel screenshot I have two reports. The first one is starting at Column B Row 3 and the second report is starting at Column G Row 3 and so forth.

Could someone show how to direct SAS to start printing the report from a particular row and column cell in excel. Thanks for your help!

Re: How to print report in a specific cell in excel

Reeza — Tue, 25 Jul 2017 03:53:21 GMT

You can't easily. You can try specifying the RANGE option when exporting.

There's a macro that works well though:

http://www.sascommunity.org/wiki/A_Poor/Rich_SAS_Users_Proc_Export

Re: How to print report in a specific cell in excel

vicky07 — Tue, 25 Jul 2017 04:03:12 GMT

Okay, I will go through the link and give it a try. Thank You!

Re: How to print report in a specific cell in excel

RW9 — Tue, 25 Jul 2017 08:08:33 GMT

As an alternative, export your data to CSV, then use Excel VBA to read in the Excel and process into your Excel template.