Thanks for your time with this post. But the link is only pertaining to processing of missing values in calculations FREQ procedure.
The requirement is to display all occurances of a group variable in PROC REPORT(with an across variable).
I could use proc transpose + proc print, but it takes 2 steps and needs more CPU. I am sure PROC REPRORT could do it in single step, but having trouble taming it.
PROC REPORT DATA = WELLS NOWD OUT=THINK;
COLUMN DUMYDATE DATE INDICATOR MEASURE,STAT;
DEFINE DUMYDATE / COMPUTED 'DATE';
DEFINE DATE / group NOPRINT;
DEFINE INDICATOR / GROUP WIDTH=10;
DEFINE MEASURE / ACROSS;
DEFINE STAT / SUM;
COMPUTE BEFORE DATE;
COMPUTE DUMYDATE / CHARACTER ;
DUMYDATE = STORED_DATE;
produced the expected output :-)
DATE indicator stat stat
01APR00 A 169 64
01APR00 B 170 93
01APR00 D . 50
01APR01 A 170 54
Also a Respected SAS expert PM'ed me
THE ODS TAGSETS.RTF STATEMENT
As mentioned previously, the new SPANROWS option repeats the values for the group and order variables when
there is a continuation of the same value on the next page for all ODS destinations.
But was unable to make it work though, probably since my tagsets were outdated.
CREATE TABLE HTAB AS
SELECT DATE, INDICATOR,
MAX(CASE WHEN MEASURE = 'HEIGHT' THEN STAT END)AS HEIGHT,
MAX(CASE WHEN MEASURE = 'WEIGHT' THEN STAT END)AS WEIGHT
GROUP BY DATE, INDICATOR
PROC PRINT DATA=HTAB;