Deal all: Could anyone help to refine the code bellow to make it work? Thanks in advance!!

/***************************/ proc sql; create table asset_rel_estate as ( select collateral_nbr, col_case_nbr, estimate_date, boss_approve_date, building_type_code, jcic_type_code, rank() over (partition by collateral_nbr order by col_case_nbr desc) as estate_seq from vp.asset_rel_estate where set_date is not null qualify estate_seq = 1 ); quit; /***************************/