The SAS Output Delivery System and reporting techniques

How to Write to a specified location in Excel

Reply
N/A
Posts: 0

How to Write to a specified location in Excel

Hi Everyone...

I have a macro which has three proc sql select statements
when i was writing them to Excel using ODS the output of each Select staments are coming one after the other (Vertically). But I need to arrange them one beside other (Horizontally). Is there any thing that I can tell SAS to write to Excel in the order which I want.

Can I specify in ODS the Start column and start Row in Excel for each output

Thanks in Advance
Super Contributor
Super Contributor
Posts: 3,174

Re: How to Write to a specified location in Excel

Suggest you share your SAS code (pasted in a post reply) for useful comment/feedback particular to your SAS usage. Also, a brief sample of your SAS variable/observation values would also be helpful.

Scott Barry
SBBWorks, Inc.
Ask a Question
Discussion stats
  • 1 reply
  • 106 views
  • 0 likes
  • 2 in conversation