I have a Macro that I want to run if the Parameter that I feed it is user entered to STLD_YN = YES, Otherwise don't run the Marco.   Here is how I have it set up: %Let STLD_YN = Yes;  /* &&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&& */ /* ON SETTLEMENT DAY ONLY*/ /* &&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&& */ /* Import Settled Loans */   %Settled(&STLD_YN.); %macro Settled(Settle_Today_Y_N);   %let Settle_Today_Y_N = %upcase(&Settle_Today_Y_N);  .....................   This works perfectly exept for the first time that I open the Project and run it. (If I re-run it, and every time after, it works)?   Here is the Log Error: 85         86         %Settled(&STLD_YN.);           _            180 WARNING: Apparent invocation of macro SETTLED not resolved.   ERROR 180-322: Statement is not valid or it is used out of proper order.   87         %macro Settled(Settle_Today_Y_N); Why is it doing this on the first time only?   Many Thanks                     ... View more

I have a daily process with a some user defined variables that are set, each day by the user before processing.    2 Questions: 1.  I have a query / Proc SQL statement within the processes that I want to run only on Settlement day.    How could I do this?   %Let Settle_DAY_Y_N = "YES" If  &Settle_DAY_Y_N. = "YES" Then    /*  This is the condition */ Proc SQL; /*Run SQL here */ /*  Settlement update query here */ run;   else /* Don't Run SQL here */ end;   2.  (2nd Question) Would your solution also works for this?   %Let Settle_DAY_Y_N = "YES"   If  &Settle_DAY_Y_N. = "YES" Then   /*  This is the condition */   Data work.Combine_Records; set work.A work.AA work.AAA; run;   else Data work.Combine_Records; set work.A work.AA;   /* Since no settlement record was created drop work.AAA */ run; end;   Many Thanks     ... View more

How can I update This Table: Loan_Number DATE LCK_TYPE LCK_TYPE_CALC 100 1/5/2016   NEW 100 1/6/2016     100 1/7/2016     100 1/8/2016     100 1/11/2016     100 1/13/2016   REVIVED 100 1/14/2016     100 1/15/2016     100 1/19/2016     100 1/20/2016     100 1/21/2016     100 1/22/2016     100 2/8/2016   REVIVED     So that it will look like this:     Loan_Number DATE LCK_TYPE LCK_TYPE_CALC 100 1/5/2016 NEW NEW 100 1/6/2016 NEW   100 1/7/2016 NEW   100 1/8/2016 NEW   100 1/11/2016 NEW   100 1/13/2016 REVIVED REVIVED 100 1/14/2016 REVIVED   100 1/15/2016 REVIVED   100 1/19/2016 REVIVED   100 1/20/2016 REVIVED   100 1/21/2016 REVIVED   100 1/22/2016 REVIVED   100 2/8/2016 REVIVED REVIVED   Here is my code which works for the "NOT MISSING"  but doesn't works where this LCK_TYPE_CALC is "MISSING" My Global variable is not working   %global VAR;  /* want this variable to hold the last value used - set */   data A_LOAN_DETAIL_E; set A_LOAN_DETAIL_D; by Loan_Number Source_Date_dte NOTSORTED; if Length(LCK_TYPE_CALC) = 0 THEN do; /* Blank doesn't work */ %Let VAR = &VAR.; end; if Length(LCK_TYPE_CALC) = 7 THEN do; /* REVIVED works */ %Let VAR = LCK_TYPE_CALC; end; if Length(LCK_TYPE_CALC) = 3 THEN do; /* NEW works */ %Let VAR = LCK_TYPE_CALC; end; LCK_TYPE = &VAR.; output; run; ... View more