I want a scan function within a macro that can pull last name of the third person in a list.   Example:   %put &full_name_list. HARRY LEVY, ABEL JAMES, ABHISHEK SINGH, ADAM LINKS   %macro name_test(); %do array_counter = 1 %to &name_count.; %let full_name = %SYSFUNC(SCAN(&FULL_NAME_LIST, &ARRAY_COUNTER, ',')); %end; %mend; %name_test();   I get the following error when I run this:   NOTE: One or more missing close parentheses have been supplied for the %SCAN function. ERROR: Expected close parenthesis after macro function invocation not found.   When I have a list of one name (either first or last) then this works perfectly. But I want to be able to pull the full name out. Any ideas? ... View more

I have a table that has the following information. Let's call this table "Source".   User   Activation Date  1           01JAN2018 2           23FEB2017 3           11JAN2017 4           23JAN2019   I'm trying to create a macro that creates a table that keeps updating itself in the following format.   YYYYMM User Flag 201701       1      0 .                  2      0 .                  3      1 .                  4      0 201702       1      0 .                  2      1 .                  3      0 .                  4      0 201801       1      1 .                  2      0 .                  3      0 .                  4      0 201901       1      0 .                  2      0 .                  3      0 .                  4      1     The Flag field denotes whether the activation date was in the newly created YYYYMM field. How do I use the source table to have a self-updating table?       ... View more

Hi I'm having trouble getting the answer to a very trivial problem.   I'm trying to get my previous date (year and month) to account for the flip of the year scenario.   Example: yyyymm = 201805 pyyyymm = 201804   yyyymm = 201801 pyyyymm = 201712   But the following program just spews out 201800 for when yyyymm = 201801...and i cant figure out why? Thanks.   %let yyyymm = 201801;   %let yr = %sysfunc(substr(&yyyymm,1,4)); %let mth = %sysfunc(substr(&yyyymm,5,2));   data null_; if "&mth" = '01' then do; %let pyyyymm = cats(&yr.-1, 12); end; else do; %let pyyyymm = &yyyymm.-1; end; run; ... View more