07-24-2017 11:47 PM
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!
07-24-2017 11:53 PM
You can't easily. You can try specifying the RANGE option when exporting.
There's a macro that works well though: