Date:         Tue, 17 Jul 2007 18:56:51 -0400
Reply-To:     Arthur Tabachneck <art297@NETSCAPE.NET>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Arthur Tabachneck <art297@NETSCAPE.NET>
Subject:      Re: report appearance in excel
Comments: To: vldesilva@GMAIL.COM

As long as your data are sorted by 'type', then something like the
following should work:

data have;
  input type $ id $;
  cards;
A       23432
A       34324
B       23434
C       32434
;
run;

data want;
  set have end=eof;
  by type;
  output;
  if last.type and not(eof) then do;
    type='';
    id='';
    output;
  end;
run;

PROC EXPORT DATA= WORK.want
            OUTFILE= "c:\want.xls"
            DBMS=EXCEL2000 REPLACE;
     SHEET="data";
RUN;

HTH,
Art
--------
On Tue, 17 Jul 2007 13:38:21 -0700, vldesilva@GMAIL.COM wrote:

>hello all,
>
>Suppose I have the following data set
>
>Type    id
>A       23432
>A       34324
>B       23434
>C       32434
>
>
>is it possible to insert a blank line between types
>
>Type    id
>A       23432
>A       34324
>
>B       23434
>
>C       32434
>
>This is how the user want the output to appear in excel finally. I
>have seen that proc report
>can insert blank lines between groups but is it possible to save the
>output of proc report in excel without any user interactions and in
>different tabs in the same work book.
>
>Thanks for all your help