I'm still new to SAS and I'm not sure if it can be done but though I would ask. I'm trying to build an IFF statement similar to what you can do in Access. I have two columns (total paid and first payment). If total paid = first payment then I don't what to return anything. If total paid is > the first payment I want to divide the total paid by first payment i.e. Here is what I used in access %CHANGE: IIf([TOTAL PAID]<>[FIRST PAYMENT AMOUNT],([TOTAL PAID]/[FIRST PAYMENT AMOUNT])-1)
... View more