Excel Tagset: Specify location in excel for the table to be printed

[AmitKB]

Hi all,

              I have 2 tables  with 5 columns each.  I want my first table to be printed at Row2 and Column A. The second table to be printed at Row 2 and column H.

What options should i use. A sample example will help.

              I appreciate all the help.

Regards,

Amit

[Reeza]

I don't believe Tagsets allows you that level of control.

[Tom]

Combine your data into a single table and print that .

data one ;

  input a b c d e f g ;

  cards;

1 2 3 4 5 6 7

8 9 10 11 12 13 14

run;

data two ;

  input h i j ;

cards;

1 2 3

4 5 6

7 8 9

run;

data both;

  if not eof1 then set one end=eof1;

  if not eof2 then set two end=eof2;

  output;

  call missing(of _all_);

  if eof1 and eof2 then stop;

run;

proc print; run;

[Iramesh]

Hi Tom,

           Can u explain briefly working of that code. Your answer match with AmitKB question?

Regards

Ramesh

[Deen]

Are you working on Unix SAS or on PC SAS?

[Deen]

I am working on Unix SAS

[Reeza]

@Deen is this still a question for you? This is an old thread, you may want to post a new question now.