Hi Please try this, its is working. DATA POLICY_DATASET; INPUT POLICY_NUMBER $ TX_DATE : DATE9. PLAN_TYP PLAN_DESC $; FORMAT TX_DATE DATE9.; CARDS; 1 04JUL2011 15 Agro 1 04JUL2011 12 GDP 1 04JUL2011 7 VFFC 2 05JUL2011 10 Agro 2 05JUL2011 11 GDP 2 05JUL2011 20 VFFC 3 06JUL2011 2 Agro 3 06JUL2011 10 GDP 3 06JUL2011 15 VFFC ; RUN; PROC SQL; CREATE TABLE POLICY_NUMBERS AS SELECT POLICY_NUMBER, TX_DATE, PLAN_TYP, PLAN_DESC, MIN(PLAN_TYP) AS MIN_PLAN FROM POLICY_DATASET GROUP BY POLICY_NUMBER, TX_DATE HAVING PLAN_TYP=CALCULATED MIN_PLAN ; QUIT;
... View more