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 (July 2004, week 4)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
Date:   Mon, 26 Jul 2004 15:39:45 +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: a simple proc report question #2
Comments:   To: Vladimir Grechko <vlad.grechko@MAIL.RU>
Content-Type:   text/plain; charset="iso-8859-1"

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


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