the problem the field I'm having trouble with is a date if I put order=data or FORMATTED I get garbage

proc report data=data3 out=nam nowd; column VolNo Result_date varnam; define VolNo / order 'Volunteer Number' width=10; define Result_date /order=data format=datetime7. width=10; define varnam/ order format=f10.3 width=15; run;

gives 01jan60 for each value

If I comment out the define for Result_date I at least get the result date for each row but the orders are off

Prasad S Ravi wrote:

> William: > > Use ORDER= option in the DEFINE statement. > > Here are several choices. > > ORDER > defines item, which must be a data set variable, as an order > variable. > > ORDER=DATA | FORMATTED | FREQ | INTERNAL > orders the values of a group, order, or across variable according to > the specified order, where > > DATA > orders values according to their order in the input data set. > > FORMATTED > orders values by their formatted (external) values. By default, > the order is ascending. > > FREQ > orders values by ascending frequency count. > > INTERNAL > orders values by their unformatted values, which yields the > same order that PROC SORT would yield. This order is operating > environment-dependent. This sort sequence is particularly > useful for displaying dates chronologically. > > Prasad Ravi > > William Kossack > <kossackw@NJC.ORG> To: SAS-L@LISTSERV.UGA.EDU > Sent by: "SAS(r) cc: > Discussion" Subject: proc report ordering rows > <SAS-L@LISTSERV.UGA.E > DU> > > 05/22/2003 10:03 AM > Please respond to > William Kossack > > I have a report from proc report > > How do I order the values in a column so that the values come out in > sorted order?