Help using Base SAS procedures

Ods Output in Excel from Row=2 and column=2

Reply
Regular Contributor
Posts: 229

Ods Output in Excel from Row=2 and column=2

Hi
i am exporting output in ods excel i want the output to start from row=2 and column=2.

Actually I need ExcelXP option in which I can output my dataset into Excel starting from R2C2. If there is no option like that suggest me anyother way (Except DDE) so that i can output in excel in a particular row and column.

Regards
R.Win
Super Contributor
Super Contributor
Posts: 3,174

Re: Ods Output in Excel from Row=2 and column=2

Suggest you subset your data first in a DATA step and drop the unwanted observation and variable(s), as required.

Scott Barry
SBBWorks, Inc.
Regular Contributor
Posts: 229

Re: Ods Output in Excel from Row=2 and column=2

Hope u have understood the question in wrong way.
Actually I need ExcelXP option in which I can output my dataset into Excel starting from R2C2. If there is no option like that suggest me anyother way (Except DDE) so that i can output in excel in a particular row and column.

Regards
R.Win
SAS Super FREQ
Posts: 8,864

Re: Ods Output in Excel from Row=2 and column=2

Hi:
You posted this question in two different forums. See here also:
http://support.sas.com/forums/thread.jspa?threadID=9625&tstart=0

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