The SAS Output Delivery System and reporting techniques

Copying to specific cells in excel

Reply
Regular Contributor
Posts: 155

Copying to specific cells in excel

Hi,

 

Top the portion of the tab contains report template and it's referring to cells below the template in the same sheet.I want to output my sas results to the specific cells in the sheet and the values in the template will be updated with in the same sheet as it's referring to that particular cells

 

Any help would be appreciated

PROC Star
Posts: 7,366

Re: Copying to specific cells in excel

If your on a Windows-based system you can do it with the macro you can find at: http://www.sascommunity.org/wiki/A_Poor/Rich_SAS_Users_Proc_Export

 

Art, CEO, AnalystFinder.com

 

Ask a Question
Discussion stats
  • 1 reply
  • 97 views
  • 0 likes
  • 2 in conversation