The SAS Output Delivery System and reporting techniques

How to print report in a specific cell in excel

Reply
Contributor
Posts: 71

How to print report in a specific cell in excel

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!

 

 


excel.JPG
Super User
Posts: 17,836

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

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

Contributor
Posts: 71

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

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

Super User
Super User
Posts: 7,401

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

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

Ask a Question
Discussion stats
  • 3 replies
  • 411 views
  • 0 likes
  • 3 in conversation