data O1617_wide; set O1617_sorted; by cihi_key; retain var_cost fix_cost new_idc totalcost; if first.cihi_key then call missing(var_cost, fix_Cost, new_idc, totalcost); var_cost = sum(VDC_LABOUR,VDC_SUPPLY_GENE,VDC_SUPPLY_SPEC,VDC_OTHER); fix_Cost=sum(FDC_LABOUR,FDC_OTHER,FDC_EQU); new_idc = sum(IVC, IFC); totalcost=sum(DC,IDC); if last.cihi_key then output; drop VDC_LABOUR VDC_SUPPLY_GENE VDC_SUPPLY_SPEC VDC_OTHER FDC_LABOUR FDC_OTHER FDC_EQU IVC IFC; run; Hello Can someone advise what would call missing do in the above code and which records will be output?
... View more