Hi All,   Here is my code, I want to make sure that when its a leap year, I add one to the month of February.   %MACRO LEAPYEAR; %IF MOD(&Year,4) = 0 AND ((MOD(&Year,100) ne 0) OR (MOD(&Year,400) = 0)) %THEN %DO; %IF SUBSTR(&Inc_End, 5, 4) = '0228' %THEN &Inc_End = %EVAL(&Inc_End + 1); %IF SUBSTR(&Paid_End, 5, 4) = '0228' %THEN &Paid_End = %EVAL(&Paid_End + 1); %END; %MEND LEAPYEAR; %LEAPYEAR But I keep getting this error in the log:   25 GOPTIONS ACCESSIBLE; 26 %MACRO LEAPYEAR; 27 %IF MOD(&Year,4) = 0 AND (MOD(&Year,100) ne 0 OR MOD(&Year,400) = 0) %THEN %DO; 28 %IF SUBSTR(&Inc_End, 5, 4) = '0228' %THEN &Inc_End = %EVAL(&Inc_End + 1); 29 %IF SUBSTR(&Paid_End, 5, 4) = '0228' %THEN &Paid_End = %EVAL(&Paid_End + 1); 30 %END; 31 %MEND LEAPYEAR; 32 %LEAPYEAR SYMBOLGEN: Macro variable YEAR resolves to 2021 ERROR: Required operator not found in expression: MOD(&Year,4) = 0 AND (MOD(&Year,100) ne 0 OR MOD(&Year,400) = 0) SYMBOLGEN: Macro variable YEAR resolves to 2021 SYMBOLGEN: Macro variable YEAR resolves to 2021 ERROR: The macro LEAPYEAR will stop executing. Any idea why? I thought my If And statement looks okay but I must be doing something wrong!   Thanks in advance!   ... View more

Hi all!   What I am looking to do is assign variables based on table variables. I'm not sure this is possible but if not please would love to know the best way to go about it. Here's the deal:   I have a table that looks like this: Run_Month Inc_Start 1 BaseYear & 0131 2 Year & 0228 3 Year & 0331   And I have Month and Year variables using the following:   %LET Run_Month = %SYSFUNC(month("&sysdate"d)); %LET Year = %SYSFUNC(year("&sysdate"d)); %LET Base_Year = %EVAL(&Year - 1);   And what I want is to use the &Run_Month variable to go into the table, find the corresponding entry and then assign a new variable called &Inc_Start as the value in the table, except concatenating the correct &Year variable with the 4 digits in the entry.   So if &Run_Month was 2 and &Year was 2021, then my &Inc_Start variable would = '20210228'   Does that make sense?   Thanks in advance!     ... View more

Hi! I am having the worst time of my life right now with what should be a super simple procedure. I have three tables. The first table (A) shows all the possible combinations of Group and Bucket. The second table (B) has values for random combinations of Group and Bucket, but also has another field, Type, that comes into play. And the third table (C) has Avg_Values for each combination of Bucket and Type. What I want is the fourth table (D), where it brings in all possible combinations of Group and Bucket for both types, and matches them with their value from table (B). But if (B) has no matching value, then grab the Avg_Value for that Bucket and Type from table (C).   (A) Group Bucket Red a Red b Red c Blue a Blue b Blue c Green a Green b Green c   (B) Type Group Bucket Value First Red a 2 First Red b 9 First Red c 1 First Blue a 3 First Blue c 8 First Green b 4 First Green c 5 Second Red a 4 Second Red c 7 Second Blue a 9 Second Blue b 8 Second Green a 10 Second Green b 2 Second Green c 1   (C) Type Bucket Avg_Value First a 99 First b 89 First c 79 Second a 69 Second b 59 Second c 49   (D) Type Group Bucket New_Value First Red a 2 First Red b 9 First Red c 79 First Blue a 3 First Blue b 89 First Blue c 8 First Green a 99 First Green b 4 First Green c 5 Second Red a 4 Second Red b 59 Second Red c 7 Second Blue a 9 Second Blue b 8 Second Blue c 49 Second Green a 10 Second Green b 2 Second Green c 1   It really should be simple but can't for the life of me figure it out. Can anyone here help? Obviously I am in serious distress since its a Saturday before a holiday and I'm working on this lol. Thanks in advance! ... View more

I'm looking to create append the columns of 4 tables essentially based on one similar column. Each column has 2 fields: Group and Value. Here is an example of two tables and what I want the final table to look like:     Table A                          Table B Group Value   Group Value Grp1 1   Grp1 2 Grp2 2   Grp3 5 Grp3 3         And I want the final table to look like this:   Table Want Group ValueA ValueB Grp1 1 2 Grp2 2 0 Grp3 3 5   PROC SQL; CREATE TABLE WORK.TABLE WANT AS SELECT t1.GROUP, COALESCE(t1.VALUE, 0) AS VALUE1, COALESCE(t2.VALUE, 0) AS VALUE2, COALESCE(t3.VALUE, 0) AS VALUE3, COALESCE(t4.VALUE, 0) AS VALUE4 FROM WORK.TABLEA t1, WORK.TABLEB t2, WORK.TABLEC t3, WORK.TABLED t4 WHERE t1.GROUP = t2.GROUP AND t1.GROUP = t3.GROUP AND t1.GROUP = t4.GROUP ORDER BY t1.GROUP; QUIT; The problem appears when one table does have a group so it gets left off completely due to the where statement. Is there a way to solve this so no group gets left off and if it doesn't have a value just make it 0? Thanks in advance! ... View more