Initialize a retain variable

[Mike018]

I've created a small dataset and I've found where was the problem. I have to increment a variable before I test the LAST.BANK_ID condition. I have put the wrong code in comment.

DATA EXAMPLE;
   INPUT TYPE REF_ID BANK_ID NUMBER;
DATALINES;
1 1 1 1003.32
0 2 2    3.89
0 4 2   45.23
1 3 9 5623.02
0 7 6  563.56
1 5 9  714.32
0 9 2  145.32
;

PROC SORT DATA=EXAMPLE;
BY TYPE BANK_ID REF_ID;
RUN;

DATA OUT;
FORMAT SUM    COMMA15.2;
FORMAT TEMP   COMMA15.2;
FORMAT TYPE_0 1.;
FORMAT TYPE_1 1.;
SET EXAMPLE END=EOF;  
BY TYPE BANK_ID REF_ID;
RETAIN SUM 0 TYPE_0 0 TYPE_1 1 TEMP 0 TYPE_0 0 TYPE_1 0;
SUM = 0;
SELECT (TYPE);     
   WHEN (0,1)
   DO;
   TEMP = TEMP + NUMBER;
IF LAST.BANK_ID THEN
  DO;
  SUM = TEMP;
  TEMP = 0;
  IF LAST.TYPE THEN
   DO;
   IF TYPE = 0 THEN
    DO;
    TYPE_0 = SUM(TYPE_0,1);
    END;
     ELSE IF TYPE = 1 THEN
      DO;
    TYPE_1 = SUM(TYPE_1,1);
    END;
   END;
  END;
/*ELSE
  DO;
  TEMP = TEMP + NUMBER;
  END;*/
   END;
OTHERWISE;
END;

PROC PRINT DATA=OUT;
RUN;

[art297]

Are you asking the forum to look at it or are you just letting us know that you now have your desired result?

[Mike018]

It works