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 .