Date: Thu, 1 Apr 1999 15:23:29 -0500
Reply-To: "Peng, Linda" <LindaP@MOCR.OAPI.COM>
Sender: "SAS(r) Discussion" <SAS-L@UGA.CC.UGA.EDU>
From: "Peng, Linda" <LindaP@MOCR.OAPI.COM>
Subject: proc report problem
Content-Type: text/plain; charset="iso-8859-1"
I am having a headache with this proc report problem.
Attached below are
1) part of the SAS log from my program;
2) answer from SAS web page's technical support;
3) a data contents of the data used in the proc report;
4) print of a few observation of the data;
Do any one have a solution or answer for me?
I am running SAS 6.12 on windows NT 4.0.
Linda
1) SAS LOG.
MPRINT(PRTTAB): PROC REPORT DATA=TABDATA SPLIT='@' HEADLINE LIST NOWD;
MPRINT(PRTTAB): COLUMNS TEST VISNO2 VISID2 STAT NEWDOSE,(VALUES);
MPRINT(PRTTAB): DEFINE TEST / GROUP FLOW FORMAT=$TESTFMT. LEFT "TEST";
MPRINT(PRTTAB): DEFINE VISNO2 / GROUP NOPRINT FORMAT=8.1;
MPRINT(PRTTAB): DEFINE VISID2 / GROUP LEFT "TIME@POINT";
MPRINT(PRTTAB): DEFINE STAT / GROUP ORDER=DATA FORMAT=STATFMT. LEFT
'STATISTICS';
MPRINT(PRTTAB): DEFINE NEWDOSE / ACROSS ORDER=DATA CENTER ' ';
MPRINT(PRTTAB): DEFINE VALUES / MIN ' ';
MPRINT(PRTTAB): BREAK AFTER VISID2 / SKIP;
21 The SAS
System
MPRINT(PRTTAB): RUN;
PROC REPORT DATA=WORK.TABDATA LS=148 PS=47 SPLIT="@" HEADLINE CENTER ;
COLUMN ( TEST VISNO2 VISID2 STAT NEWDOSE,( VALUES ) );
DEFINE TEST / GROUP FORMAT= $TESTFMT. SPACING=2 FLOW LEFT "TEST" ;
DEFINE VISNO2 / GROUP FORMAT= 8.1 WIDTH=8 SPACING=2 NOPRINT RIGHT
"TIME POINT" ;
DEFINE VISID2 / GROUP FORMAT= $20. WIDTH=20 SPACING=2 LEFT "TIME@POINT"
;
DEFINE STAT / GROUP FORMAT= STATFMT. WIDTH=16 SPACING=2 LEFT
ORDER=DATA "STATISTICS" ;
DEFINE NEWDOSE / ACROSS FORMAT= $40. WIDTH=40 SPACING=2 CENTER
ORDER=DATA " " ;
DEFINE VALUES / MIN FORMAT= 8.1 WIDTH=8 SPACING=2 RIGHT " " ;
BREAK AFTER VISID2 / SKIP ;
RUN;
ERROR: Unknown exception (80000602)
ERROR: Unknown exception (80000602)
ERROR: Unknown exception (80000602)
ERROR: A severe error occurred in task REPORT for module SASREPMN
executing in module SASREPMN at address 00033BA7.
ERROR: A severe error occurred in task REPORT for module SASREPMN
executing in module SASREPMN at address 00033BA7.
ERROR: A severe error occurred in task REPORT for module SASREPMN
executing in module SASREPMN at address 00033BA7.
Please contact Technical Support to report this error.
Please contact Technical Support to report this error.
Please contact Technical Support to report this error.
ERROR: Generic critical error.
ERROR: Generic critical error.
ERROR: Generic critical error.
NOTE: The SAS System stopped processing this step because of errors.
NOTE: The PROCEDURE REPORT used 4.37 seconds.
2) answer from SAS technical support.
<<...>>
SAS NOTE -- V6-REPORT-F268
Unknown exception 80000602 occurs when width is < col header or format
If a specified or default width value is smaller than the format length or
the length of the column header, the following error may occur:
ERROR: Unknown exception (80000602)
ERROR: A severe error occurred in task REPORT for module
SASREPMN executing in module SASREPMN
To circumvent this situation, change the value of the width to the format
length or column header length.
If it is uncertain which DEFINE statement has the above condition, use the
LIST option on the PROC REPORT statement. Then compare the LIST code width
value with the column header length and format length.
3) Data contents.
CONTENTS
PROCEDURE
Data Set Name: WORK.TABDATA
Observations: 1512
Member Type: DATA
Variables: 17
Engine: V612
Indexes: 0
Created: 14:45 Thursday, April 1,
1999 Observation Length: 305
Last Modified: 14:45 Thursday, April 1,
1999 Deleted Observations: 0
Protection:
Compressed: NO
Data Set Type:
Sorted: YES
Label:
-----Engine/Host
Dependent Information-----
Data Set Page Size:
9216
Number of Data Set
Pages: 51
File Format:
607
First Data Page:
1
Max Obs per Page:
30
Obs in First Data
Page: 22
-----Alphabetic List of
Variables and Attributes-----
# Variable Type Len Pos Format
Label
----------------------------------------------------------------------------
--------------
10 DOSE Num 8 189
ACT. TOT. COMP DOSE GROUP (SAF)/SUBJ
11 DOSE_FMT Char 20 197
5 LOWHIGH Char 100 33
REFERENCE RANGE
17 NEWDOSE Char 40 265
14 ORDER Num 8 245
1 PANEL Char 7 0
PANEL - HEMLAB or CHEMLAB format rsltab
15 STAT Num 4 253
13 STAT_FMT Char 20 225
3 TEST Char 8 15
PARAMETER
16 TOTPTS Num 8 257
2 TSTORD Num 8 7
TEST ORDER FOR STANDARD HEMLABS
4 UNIT Char 10 23
UNIT
12 VALUES Num 8 217 8.1
9 VISID2 Char 20 169
TIME POINT
7 VISIT Char 20 141
STUDY DAY
6 VISNO Num 8 133
STUDY DAY
8 VISNO2 Num 8 161
TIME POINT
4) print of a few data observation.
OBS PANEL TSTORD TEST UNIT LOWHIGH VISNO VISIT VISNO2 VISID2 DOSE
1 HEMLAB 1 WBC THOU/MCL 3.8-10.8 0 DAY 0 -1 PRE-TX 1
2 HEMLAB 1 WBC THOU/MCL 3.8-10.8 0 DAY 0 -1 PRE-TX 2
3 HEMLAB 1 WBC THOU/MCL 3.8-10.8 0 DAY 0 -1 PRE-TX 3
4 HEMLAB 1 WBC THOU/MCL 3.8-10.8 0 DAY 0 -1 PRE-TX 4
5 HEMLAB 1 WBC THOU/MCL 3.8-10.8 0 DAY 0 -1 PRE-TX 99
6 HEMLAB 1 WBC THOU/MCL 3.8-10.8 0 DAY 0 -1 PRE-TX 888
7 HEMLAB 1 WBC THOU/MCL 3.8-10.8 0 DAY 0 -1 PRE-TX 999
8 HEMLAB 1 WBC THOU/MCL 3.8-10.8 0 DAY 0 -1 PRE-TX 1
9 HEMLAB 1 WBC THOU/MCL 3.8-10.8 0 DAY 0 -1 PRE-TX 2
10 HEMLAB 1 WBC THOU/MCL 3.8-10.8 0 DAY 0 -1 PRE-TX 3
OBS DOSE_FMT VALUES STAT_FMT ORDER STAT TOTPTS NEWDOSE
1 Q13 11.0 N 1 1 14 Q13@(N=14)
2 Q23 13.0 N 1 1 14 Q23@(N=14)
3 Q33 14.0 N 1 1 14 Q33@(N=14)
4 Q43 14.0 N 1 1 14 Q43@(N=14)
5 ALL DOSES 52.0 N 1 1 56 ALL DOSES@(N=56)
6 GROIN ONLY 28.0 N 1 1 32 GROIN ONLY@(N=32)
7 GROIN & ABDOMEN 24.0 N 1 1 24 GROIN &
ABDOMEN@(N=24)
8 Q13 6.4 MEAN 2 2 14 Q13@(N=14)
9 Q23 6.4 MEAN 2 2 14 Q23@(N=14)
10 Q33 6.4 MEAN 2 2 14 Q33@(N=14)
