|Date: ||Thu, 13 May 1999 07:03:04 -0400|
|Sender: ||"SAS(r) Discussion" <SAS-L@UGA.CC.UGA.EDU>|
|From: ||Larisa <larisa@INJERSEY.COM>|
|Organization: ||Authorized License|
|Subject: ||proc report help|
|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
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
value $pknpf 'peak' = 'peak'
'non peak'= 'nonpeak';
proc reprot data =cpureal heaskip split ="*" ls=220;
column var2 var2name var6 var5 cpureal, (qnt1 qnt2 qnt3 qnt4) totpeak
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
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';
totpeak = sum(_c10_, _c11_, _c12_, _c13_, 0);
totnonpk = sum(_c5_, _c6_, _c7_, _c8_, 0);
total = sum(_c5_, _c6_, _c7_, _c8_,_c10_, _c11_, _c12_, _c13_, 0);
break after var2/dol dul skip summarize;
rbreak after / dol dul page summarize;
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
peak totnon pk
var2 var2name var6 var5 q1 q2 q3 q4 totpeak q1 q2 q3 q4 totnonpk
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 .