Date: Wed, 9 Jun 2004 15:22:59 +0200 "Groeneveld, Jim" "SAS(r) Discussion" "Groeneveld, Jim" Re: PROC REPORT DEFINE / ORDER problem To: Dubravko Dolic text/plain; charset="iso-8859-1"

Hi Dubravko,

Just a quick hint/suggestion: try making it a GROUP variable and report back to the list.

Regards - Jim. -- . . . . . . . . . . . . . . . .

Jim Groeneveld, MSc. Biostatistician Science Team Vitatron B.V. Meander 1051 6825 MJ Arnhem Tel: +31/0 26 376 7365 Fax: +31/0 26 376 7305 Jim.Groeneveld@Vitatron.com www.vitatron.com

My computer didn't see Venus better than I did, but I didn't see it in reality.

[common disclaimer]

-----Original Message----- From: Dubravko Dolic [mailto:dubro@DOLIC.DE] Sent: Wednesday, June 09, 2004 11:08 To: SAS-L@LISTSERV.UGA.EDU Subject: PROC REPORT DEFINE / ORDER problem

Hi All!

A question for those of You working with PROC REPORT:

Would it be possible to make the third column (date) in this report to NOT repeat the date when it doesn't change?

IS:

Day 1 T=-24 hours 15MAR2004 8:00:00 T=-20 hours 15MAR2004 12:03:00 T=-14 hours 15MAR2004 18:00:00 T=-12 hours 15MAR2004 20:00:00 T=-9 hours 15MAR2004 23:00:00

Should be:

Day 1 T=-24 hours 15MAR2004 8:00:00 T=-20 hours 12:03:00 T=-14 hours 18:00:00 T=-12 hours 20:00:00 T=-9 hours 23:00:00

These columns are all defined as ORDER and order is determined as ORDER = INTERNAL. Additionally there is an silent order variable between the day and the hours (Col2 and Col3) defined as ORDER NOPRINT;

As far as I understood the documentation using ORDER has the wanted effect. But I'm not clear about what happens if columns before the ORDER variable change their values or if there are DISPLAY columns before an ORDER column.

"PROC REPORT does not repeat the value of an order variable from one row to the next if the value does not change."

Maybe this comment from the manual is not true if there is a display variable BEFORE an ORDER variable or if the values from the variable before the ORDER variable change...??

Dubravko

Back to: Top of message | Previous page | Main SAS-L page