Hi,   In my DI job I will be using a dynamic table which has timestamp as the suffix in the table name.Could you please help with the best way of doing if with transformation and code  details? abc_31mar2018,abc_30apr2018 etc.    Thanks Kajal ... View more

Hi Channel,   I have "IF else" statement which I want to convert to "case when" could you please help .   IF Rate "" THEN DO ;   A ="LIGHT"; B =1;   IF HIGH =1 THEN DO;    U = A1 ;    V = 1;    W = 1;    X = A1_PO;    Y = 1;    Z = 1;   END;   IF HIGH =2 THEN DO;    U = 1;    V = A1 ;    W = 1;    X = 1;    Y = A1_PO;    Z = 1;   END;   IF HIGH =3 THEN DO;    U = 1;    V = 1;    W = A1 ;    X = 1;    Y = 1;    Z = A1_PO;   END;     END;  ELSE IF AMOUNT 1  NE AMOUNT 2 THEN DO;   A ="HARD"; B =2;   IF HIGH =1 THEN DO;    U = APPLE;    V = 1;    W = 1;    X = APPLE_GREEN;    Y = 1;    Z = 1;   END;   IF HIGH =2 THEN DO;    U = 1;    V = APPLE;    W = 1;    X = 1;    Y = APPLE_GREEN;    Z = 1;   END;   IF HIGH =3 THEN DO;    U = 1;    V = 1;    W = APPLE;    X = 1;    Y = 1;    Z = APPLE_GREEN;   END;   END;  ELSE DO ;   A = "SOFT" ; B =3;   IF HIGH =1 THEN DO;    U = ORANGE;    V = 1;    W = 1;    X = ORANGE_TANGY;    Y = 1;    Z = 1;   END;   IF HIGH =2 THEN DO;    U = 1;    V = ORANGE;    W = 1;    X = 1;    Y = ORANGE_TANGY;    Z = 1;   END;   IF HIGH =3 THEN DO;    U = 1;    V = 1;    W = ORANGE;    X = 1;    Y = 1;    Z = ORANGE_TANGY;   END;   END;   I have converted all but can't able fit all under ELSE. Please help and I want to use sql "case when" because I want to migrate this to angular SQL so can't use data step ... View more

Hi Channel,   I am trying to run the following code but not getting identical results please advice    This is what I have: PROC SORT DATA = A OUT = B; BY T; QUIT;   This is what I want:   PROC SQL; CREATE TABLE B AS SELECT * FROM A GROUP BY T ORDER BY T ; QUIT;   Thanks    ... View more