Date:         Thu, 13 May 1999 13:12:00 -0400
Reply-To:     "Kowalczyk, Andrew" <AKowalczyk@NT.DMA.STATE.MA.US>
Sender:       "SAS(r) Discussion" <SAS-L@UGA.CC.UGA.EDU>
From:         "Kowalczyk, Andrew" <AKowalczyk@NT.DMA.STATE.MA.US>
Subject:      Re: proc report help
Comments: To: Larisa <larisa@INJERSEY.COM>
Content-Type: text/plain

Make these changes (not tested- caveat emptor and saltum granus &c):
 
remove all references to totpeak  &  totnonpk
 
column var2 var2name var6 var5 cpureal, (qnt1 qnt2 qnt3 qnt4 subtotal)
total;
define subtotal/computed format=comma12. width=12 ;
 
compute subtotal;
     _c14_ = sum(_c10_, _c11_, _c12_, _c13_, 0);
     _c9_ = sum(_c5_, _c6_, _c7_, _c8_, 0);
endcomp;
compute total;
    total = sum(_c5_, _c6_, _c7_, _c8_,_c10_, _c11_, _c12_, _c13_, 0);
endcomp;
 
Proc REPORT does not have a builtin OBS feature like Proc PRINT.
you could do something like
 
data vcpureal/view=vcpureal;
set cpu_real;
obs = _n_;
run;
 
proc report data=vcpureal . . . ;
column obs ....
 
and adjust the _c99_ style numbers in the compute statements.
 
\
> -----Original Message-----
> From: Larisa [SMTP:larisa@INJERSEY.COM]
> Sent: Thursday, May 13, 1999 7:03 AM
> Subject:      proc report help
>
> 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 .