Date:         Thu, 13 May 1999 07:03:04 -0400
Reply-To:     larisa@injersey.com
Sender:       "SAS(r) Discussion" <SAS-L@UGA.CC.UGA.EDU>
From:         Larisa <larisa@INJERSEY.COM>
Organization: Authorized License
Subject:      proc report help
Comments: To: SAS-L@LISTSERV.VT.EDU
Content-Type: text/plain; charset=us-ascii

I have a proc report question.
 
I have always used data _null_ but now inherited some code, and moreso
in a way headache, but I need to get a report done.
 
Something is happening to my data- to be more specific...I don't have a
manual, and have been in contact with SI, and the support person has
been wonderful.  However, I am also curious from the others of you who
have use proc report what you find from your experiene what could be
happening to my data.
 
I have been  using sugi and nesug proceedings as my tutor and manual
(1996).
I added an across variable and my data seem to go from thousands of
records (many pages) to 2 pages - maybe 10 records (if that)....Ray Pass
paper has been my bible.
 
My problem at hand
 
I am unclear about how to sort, because order = and order option I
understand are different but its a bit confussing as of now.
 
Right now my code looks like this
 
 
*******
proc format;
value $pknpf 'peak' = 'peak'
                    'non peak'= 'nonpeak';
run;
 
proc reprot data =cpureal heaskip split ="*"  ls=220;
column var2 var2name var6 var5 cpureal, (qnt1 qnt2 qnt3 qnt4) totpeak
totnonpk
             total;
define var6/display format =$35. width = 35 'var6';
define var5/display format =$6. width = 6 'var5';
define var2/group format =$7. width = 7 'var2' ;
define cpureal/across format =$pknpf.. width = 8 'processing' ;
define var2name/display format =$20. width = 20 'var2name' order
=internal;
define qnt1/analysis format=8. width=8 'jan99';
define qnt2/analysis format=8. width=8 'feb99';
define qnt3/analysis format=8. width=8 'mar99';
define qnt4/analysis format=8. width=8 ''apr99';
define totpeak/computed format=comma12. width=12 'tot peak';
define totnonpk/computed format=comma12. width=12 'tot non peak';
define total/computed format=comma12. width=12 'total';
compute totpeak;
     totpeak = sum(_c10_, _c11_, _c12_, _c13_, 0);
endcomp;
compute totnonpk;
     totnonpk = sum(_c5_, _c6_, _c7_, _c8_, 0);
endcomp;
compute total;
    total = sum(_c5_, _c6_, _c7_, _c8_,_c10_, _c11_, _c12_, _c13_, 0);
endcomp;
break after var2/dol dul skip summarize;
rbreak after / dol dul page summarize;
title 'data';
run;
 
it looks like this
                                             tot peak        totnon pk
var2 var2name var6 var5 q1 q2 q3 q4 q1 q2 q3 q4 totpeak totnonpk total
 
actually I want it to look like but thats minor
                                                     tot
peak               totnon pk
var2 var2name var6 var5 q1 q2 q3 q4 totpeak q1 q2 q3 q4  totnonpk
total;
 
The Major one is what if anything do you see in my define statemtents
that make the obs not be produced?
 
Please any and all advice is very welcomed .