Date:         Wed, 12 May 2010 14:44:00 -0500
Reply-To:     Joe Matise <snoopy369@GMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Joe Matise <snoopy369@GMAIL.COM>
Subject:      Re: excelxp tagset/proc report and (not) skipping lines
Comments: To: Sudo Ku <crafty876@hotmail.com>
In-Reply-To:  <SNT122-W50837F8BAA497EC25E74AFEDFB0@phx.gbl>
Content-Type: text/plain; charset=ISO-8859-1

Thanks, but I don't think that answers my question.  I still get blank lines
before each AGE break.  Just to clarify, I get the age line also - I get two
break lines, one is a blank line, the other has Age on it.

Is my version of tagsets too old/new?? (Using v1.94)

-Joe

On Wed, May 12, 2010 at 2:16 PM, Sudo Ku <crafty876@hotmail.com> wrote:

> Hi Joe:
>
>
>
> I happened to have the same problem just last week.....
>
> To give something it's own line first you have to compute the variable (and
> in your case get it into a text format). i called this new variable ageline,
> then give the line command and you are restricted to a text format in the
> ageline command..
>
>
>
>
>
> ods tagsets.excelxp file="c:\test.xls";
>
> proc report nowd data=class;
>
> columns age name height weight;
>
> define name/order order=internal;
>
> define age/group noprint;
>
> compute before age;
>
> ageline=cats(age);
>
> line @1 ageline $8. ;
>
> endcomp;
>
> run;
>
> ods tagsets.excelxp close;
>
>
>
> > Date: Wed, 12 May 2010 10:21:42 -0500
> > From: snoopy369@GMAIL.COM
> > Subject: excelxp tagset/proc report and (not) skipping lines
> > To: SAS-L@LISTSERV.UGA.EDU
> >
> > Hi folks,
> > Working on a proc report to ExcelXP tagset, and having trouble getting
> excel
> > to NOT skip a line before a COMPUTE BEFORE line.
> >
> > For example:
> >
> > proc sort data=sashelp.class out=class;
> > by age;
> > run;
> > ods tagsets.excelxp file="c:\test.xml";
> > proc report nowd data=class;
> > columns age name height weight;
> > define name/order order=internal;
> > define age/group noprint;
> > compute before age;
> > line @1 age 2.;
> > endcomp;
> > run;
> > ods tagsets.excelxp close;
> >
> > You'll see in the Excel output that there is a line before each age (in
> this
> > case, rows 2,
> >
> > I'd like the grouping variable to be printed by itself on the line above
> the
> > data (like it is), but without the skipped line before it. Tried playing
> > around with the COMPUTE BEFORE and using a BREAK BEFORE statement, but
> > neither seems to be of help. Any thoughts?
> >
> > Thanks,
> >
> > Joe
>
> _________________________________________________________________
> 30 days of prizes: Hotmail makes your day easier! Enter Now.
> http://go.microsoft.com/?linkid=9729710
>