How to print report in a specific cell in excel

[vicky07]

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!

[Reeza]

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

[vicky07]

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

[RW9]

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