This is how far I got... data atb1(drop=i); set atb; array testzero(*) AR_BALANCE AGE_BUCKET_0 AGE_BUCKET_1_30 AGE_BUCKET_31_60 AGE_BUCKET_61_90 age_bucket_91_120 age_bucket_121_150 age_bucket_151_plus; do i = 1 to dim(testzero); if testzero(i)=0 then testzero(i)=.; end; run; PROC MEANS DATA=ATB1 NOPRINT ; id date; VAR AR_BALANCE AGE_BUCKET_0 AGE_BUCKET_1_30 AGE_BUCKET_31_60 AGE_BUCKET_61_90 age_bucket_91_120 age_bucket_121_150 age_bucket_151_plus; OUTPUT OUT=ATB2 (drop= _TYPE_ _FREQ_) SUM= N= / autoname ; RUN; PROC TRANSPOSE DATA=ATB2 OUT = ATB3 prefix = date; RUN; The output i get is this: _NAME_ _LABEL_ date1 AR_BALANCE_Sum AR_BALANCE 4,517,795,437 AGE_BUCKET_0_Sum AGE_BUCKET_0 575,298,949 AGE_BUCKET_1_30_Sum AGE_BUCKET_1_30 190,827,228 AGE_BUCKET_31_60_Sum AGE_BUCKET_31_60 58,694,576 AGE_BUCKET_61_90_Sum AGE_BUCKET_61_90 32,294,689 AGE_BUCKET_91_120_Sum AGE_BUCKET_91_120 29,674,161 AGE_BUCKET_121_150_Sum AGE_BUCKET_121_150 25,597,435 AGE_BUCKET_151_PLUS_Sum AGE_BUCKET_151_PLUS 3,674,579,799 AR_BALANCE_N AR_BALANCE 8,610,964 AGE_BUCKET_0_N AGE_BUCKET_0 3,445,686 AGE_BUCKET_1_30_N AGE_BUCKET_1_30 1,188,699 AGE_BUCKET_31_60_N AGE_BUCKET_31_60 396,280 AGE_BUCKET_61_90_N AGE_BUCKET_61_90 180,639 AGE_BUCKET_91_120_N AGE_BUCKET_91_120 142,042 AGE_BUCKET_121_150_N AGE_BUCKET_121_150 130,128 AGE_BUCKET_151_PLUS_N AGE_BUCKET_151_PLUS 4,366,092 I don't know how to proceed further. I can't figure out how to use Proc tabulate so I can keep appending the 3rd column every day to this data. The column should be dated...
... View more