Hi Vlad,

Try one of the other ORDER options with DEFINE. e.g. ORDER=DATA.

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 says 'beep'. What's wrong with that? It's talking too much!

[common disclaimer]

-----Original Message----- From: Vladimir Grechko [mailto:vlad.grechko@MAIL.RU] Sent: Monday, July 26, 2004 13:34 To: SAS-L@LISTSERV.UGA.EDU Subject: a simple proc report question #2

Thank you very much, Richard!

Is there a way of displaying "Pre-dose" as the first column rather than the last one (or, generalizing, how to display a column at a particular place as a column no. Y)

PROC FORMAT ; VALUE $TESTfmt 0 = 'Pre-dose' 1 = '1' 2 = '2' ; RUN; DATA DATA; INPUT SUBJECT PERIOD TREAT $ TIME $ PARAM ; CARDS; 1 1 A 0 10 1 1 A 1 20 1 1 A 2 30 1 2 B 0 100 1 2 B 1 200 1 2 B 2 300 ; PROC REPORT DATA=data NOFS; /* NOFS used to direct output to the LOG instead of REPORT window */ COLUMN SUBJECT PERIOD TREAT TIME,PARAM ;

DEFINE SUBJECT /ORDER GROUP FORMAT=5.0 WIDTH=8 'Subject' ; DEFINE PERIOD / GROUP FORMAT=1.0 WIDTH=7 'Period' ; /* Note: not using GROUP or using DISPLAY leads to missing values to be printed for each OBS: try it */ DEFINE TREAT / GROUP FORMAT=$1. WIDTH=9 'TREATMENT' ; DEFINE TIME / ACROSS FORMAT=$TESTfmt. 'Time'; DEFINE PARAM / ANALYSIS FORMAT=8.0 ' '; RUN;

Thank you, Vlad