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

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

R_Win — Mon, 03 May 2010 05:14:12 GMT

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

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

sbb — Mon, 03 May 2010 12:29:32 GMT

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

Scott Barry
SBBWorks, Inc.

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

R_Win — Tue, 04 May 2010 04:54:13 GMT

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

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

Cynthia_sas — Tue, 04 May 2010 14:04:45 GMT

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

cynthia