Hi all, I'm a fairly new SAS programmer and haven't used proc report much yet, but I need to produce a graduation rate table and I believe proc report is my best way to display the result. I'm having trouble getting the compuations to be correct. I cannot share my data set since it has senstitive information. My code and output are below. What I notice is that it fails to compute once a zero is present. I would be grateful for any advice or direction you all can provide! Title "2008 Cohort";
proc report data = gradcombine1;
where cohort = "2008";
column acad_plan n cbm009year, (n cum);
label acad_plan = "Plan"
cbm009year = "Year"
;
define acad_plan / group;
define cbm009year / across;
define n / "#";
define cum / computed "Cumulative %" f=percent8.2;
compute cum;
/* Calculate cumulative percent */
_c4_ = _c3_ / _c2_;
_c6_ = (_c5_ + _c3_) / _c2_;
_c8_ = (_c7_ + _c5_ + _c3_) / _c2_;
_c10_ = (_c9_ + _c7_ + _c5_ + _c3_) / _c2_;
endcomp;
run;
... View more