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 (May 1999, week 2)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
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 .

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