Does anybody know if a feature has been added , like "ROW-SUMMARIZE" ? Some way to recalcuate computed fields in row-total situation, the same way we use ON TABLE SUMMARIZE to correctly calculate our computed fields from a column. ?
(Other than , of course, doing all the stuff by arduous coding)
It has been requested as a New Feature, but not yet implemented.
Coding is the only way currently. The way it was shown to me was to first do your request without any formatting and assign a sequence number (SEQ = 2), add BY SEQ NOPRINT and put it to a HOLD file. Then run your request again with a sequence number (SEQ = 1) and add BY SEQ NOPRINT. Include your formatting in this section. At the end use
to append the two files together. Aword of warning. if you use a COUNT or CNT. as one of your fields it does not work properly with a HOLD file. Use the following in a DEFINE
-*DEFCNT/I6 WITH fieldname = IF fieldname IS MISSING THEN 0 ELSE 1;
and then replace your fieldname in the request wtih DEFCNT in both sections. When SUMMED it will do the same as count and will work in the HOLD file.
|Powered by Social Strata|