options nodate nonumber ls=64; libname ia '.'; data over175; set ia.dfwlax; length City $ 11; Total=sum(FirstClass,Economy); if Total gt 175; if upcase(Dest)='DFW' then do; Revenue=sum(1500*FirstClass,900*Economy); City='Dallas'; end; else if upcase(Dest)='LAX' then do; Revenue=sum(2000*FirstClass,1200*Economy); City='Los Angeles'; end; run; proc print data=over175; var Dest City Flight Date Total Revenue; format Date date9.; run;