How to Write to a specified location in Excel

[deleted_user]

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

[sbb]

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.