BookmarkSubscribeRSS Feed
R_Win
Calcite | Level 5
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
3 REPLIES 3
sbb
Lapis Lazuli | Level 10 sbb
Lapis Lazuli | Level 10
Suggest you subset your data first in a DATA step and drop the unwanted observation and variable(s), as required.

Scott Barry
SBBWorks, Inc.
R_Win
Calcite | Level 5
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
Cynthia_sas
Diamond | Level 26
Hi:
You posted this question in two different forums. See here also:
http://support.sas.com/forums/thread.jspa?threadID=9625&tstart=0

cynthia

hackathon24-white-horiz.png

2025 SAS Hackathon: There is still time!

Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!

Register Now

What is Bayesian Analysis?

Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 3 replies
  • 1317 views
  • 0 likes
  • 3 in conversation