LISTSERV at the University of Georgia
Menubar Imagemap
Home Browse Manage Request Manuals Register
Previous messageNext messagePrevious in topicNext in topicPrevious by same authorNext by same authorPrevious page (June 2004, week 2)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
Date:   Wed, 9 Jun 2004 15:22:59 +0200
Reply-To:   "Groeneveld, Jim" <jim.groeneveld@VITATRON.COM>
Sender:   "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:   "Groeneveld, Jim" <jim.groeneveld@VITATRON.COM>
Subject:   Re: PROC REPORT DEFINE / ORDER problem
Comments:   To: Dubravko Dolic <dubro@DOLIC.DE>
Content-Type:   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

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?


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...??


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