The SAS Output Delivery System and reporting techniques

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

Reply
Frequent Contributor
Posts: 99

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


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

Super User
Posts: 19,832

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

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

Super User
Super User
Posts: 7,061

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

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;

Occasional Contributor
Posts: 9

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

Hi Tom,

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

Regards

Ramesh

Occasional Contributor
Posts: 14

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

Are you working on Unix SAS or on PC SAS?


Occasional Contributor
Posts: 14

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

I am working on Unix SAS

Super User
Posts: 19,832

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

@Deen is this still a question for you? This is an old thread, you may want to post a new question now.
Ask a Question
Discussion stats
  • 6 replies
  • 567 views
  • 0 likes
  • 5 in conversation