Hello, I am tying to shift the data in dataset using the macro. I can process the shifting using arrays, but was wondering if this could be done using Macros. What I have - Dataset with fields - variables1 to variables12 (not stored inan  Array. Each value is in separate field) What I want to do - Create a new dataset using above one and call the macro inside the data step to process the shifting My problem - (a) I want the Macro to use the variables from SET DATASET, do the processing and store the values back. I have 140 fields in the dataset and I do not want to send those as arguments to the macro. (b) If I use CALL EXECUTE with the string as argument, I am getting 'Out of Memory' error as the data is huge. Is it possible to process the data dynamically using macros for such scenario? %MACRO SHIFT;        %LET MTHCNT = %SYSFUNC(INTCK(MONTH, Date1, Date2));                   /* Date1, Date2 and all other variables from Dataset1  */        %LET MTHCNT1=%EVAL(&MTHCNT. + 1);        %IF &MTHCNT. <= 12 %THEN %DO;            %DO M=&MTHCNT1. %TO 12 %BY 1;                %LET SUB=%EVAL(&M - &MTHCNT.);                Var2_&M  = Var2_&SUB;                Var3_&M  = Var3_&SUB;                Var4_&M  = Var4_&SUB;             %END;           %DO N=1 %TO &MTHCNT. %BY 1;               Var2_&N  = 0;               Var3_&N  = ' ';               Var4_&N  = ' ';            %END;        %END;        %ELSE %DO;            %DO N=1 %TO 12 %BY 1;                Var2_&N  = 0;                Var3_&N  = ' ';               Var4_&N  = ' ';           %END;        %END; %MEND SHIFT; DATA     dataset     ; SET     dataset1     ;   BY     Var1     ;     CALL EXECUTE('%SHIFT');     IF LAST.Va1 THEN CALL EXECUTE('OUTPUT;');     IF LAST.Var1 THEN CALL EXECUTE('RUN;'); RUN; ... View more