Hi Community,   I am working on a project and need to make some adjustments to a SAS code written by  a good SAS programmer and need some of your help to add 2 more conditions.   To the following code I need to add two things:   1. If the P_code in 107, 108,109,110 then  exlude from the calculation UFA=round(UFR*increase,0.01);   2. UFA = balance on opendate minus O_balance 5 days after opening date.   The existing conditions in the following code applies now and going forward however conditions 1 & 2 that are mentioned above must take place after January 01 2019   data work.eom_processed; set work.eom; if "&StartM."d <= OpenDate <= "&EndM."d or (ChgFlag='F' and put(strip(put(pcode,4.)),$pc3l.)='LOC') then do; if L_Amt in (0,.) then Reason='NF'; else do;   if RW_Ind='Y' then do; if B_Ind='Y' or (B_Ind ne 'Y' and pct_increase < 0.3) then do; UFA=round(UFR*increase,0.01); if pct_increase < 0 then do; Reason='RW < Original'; C_Ind='Y'; UFA=0; end; end; else do; UFA=0; Reason='Over 30%'; end; end; else UFA=round(UFR*L_Amt,0.01); if TBRatio <= TBBonusMax then TBBonusAmt=round(min(TBBonusLimit, L_Amt)*TBBonusRate,0.01); end; end;   Grateful for your help.   Kind regards, Magstar ... View more

Hi Community,   I am getting the following error when running this code:   Code:   %MACRO Payment(InterestRate = , TermInMonths = , LoanAmt = ); %if &InterestRate le 0 %then %do;   Loan_Repayment = &LoanAmt / &TermInMonths; %end; %else %do; Loan_Repayment = &LoanAmt * (&InterestRate/100) / (1-((1+(&InterestRate/100))**(-&TermInMonths))); %end; %MEND;   data CUBE_05_&t_fin_year_dly; set CUBE_04_&t_fin_year_dly;   %PAYMENT(InterestRate = acc_int_rate/12, TermInMonths = TermOfNoteInMonths, LoanAmt = acc_loan_amt); if InterestOnlyFlag="Y" then Repaymt=acc_int; else Repaymt=acc_repaymt; if acc_accbal ne . and crf_accbal eq . then accbal=acc_accbal; else if acc_accbal eq . and crf_accbal ne . then accbal=crf_accbal; else accbal=acc_accbal; if On_bal_amt = . then On_bal_amt=0; else On_bal_amt=On_bal_amt; if accbal=. then accbal=0; else accbal=accbal; if BOQ_SCHED_BALANCE_AMT = . then UseScheduleBalance = accbal; else UseScheduleBalance=BOQ_SCHED_BALANCE_AMT; if lnp_LQRCode ne "" then LQRCode=lnp_LQRCode; else if crf_LQRCode ne "" then LQRCode = crf_LQRCode; else if acc_LQRCode ne "" then LQRCode = acc_lqrcode; else LQRCode = " "; run;   ERROR: A character operand was found in the %EVAL function or %IF condition where a numeric operand is required. The condition was: &InterestRate le 0 ERROR: The macro PAYMENT will stop executing   Appreciate your help.   Magstar ... View more

Hi there,   I have two tables to merge and whilst I know how to merge using both SAS data step and Proc Sql, I prefer to use proc sql however the problem I am facing is how to  keep all columns for the first table and only specific columns for the second table.   It should be   Proc Sql; Create table Accounts as Select * from table 1 Select a, b,c  from table 2 left join  table 2 on ( table1.a=table2.a); quit;   I truly appreciate your help.   Kind regards, Mags ... View more