You can use the retain statement to accumulate a variable or a sum statement. This topic is discussed in the SAS Programming 2 class in detail. I would recommend you take this course.   Here is an example to your question but only using one of the variables var1 by year.   DATA WORK.temp; Infile datalines delimiter=','; INPUT YearMonth $ var1 var2 Desired_Accu1 Desired_Accu2 ; year=substr(yearmonth,1,4); CARDS; 2019-01,100,500,100,500 2019-02,200,600,300,1100 2019-03,300,700,600,1800 2019-04,400,100,1000,1900 2019-05,500,200,1500,2100 2019-06,600,300,2100,2400 2019-07,700,400,2800,2800 2019-08,800,500,3600,3300 2019-09,100,500,3700,3800 2019-10,200,600,3900,4400 2019-11,300,700,4200,5100 2019-12,400,100,4600,5200 2020-01,500,200,500,200 2020-02,600,300,1100,500 2020-03,700,400,1800,900 2020-04,800,500,2600,1400 2020-05,100,500,2700,1900 2020-06,200,600,2900,2500 2020-07,300,700,3200,3200 2020-08,400,100,3600,3300 2020-09,500,200,4100,3500 2020-10,600,300,4700,3800 2020-11,700,400,5400,4200 2020-12,800,500,6200,4700 2021-01,100,500,100,500 2021-02,50,300,150,800 ; RUN; proc sort data=WORK.temp; by Year; run; Data work.temp(keep=year var1 ret_var1); set work.temp; by year; if first.year=1 then ret_var1=0; ret_var1+var1; run;   ... View more

Take a look at this.. https://support.sas.com/resources/papers/proceedings/proceedings/sugi29/119-29.pdf ... View more

Hi Carlo,   Well, it depends, so let's start off with some basic questions.  Have you taken the SAS installation course or had some experience installing the SAS Platform?   Also, what does the installation look like? is this on a single machine server? Do you have a plan file? What's the o/s?     ... View more

Thanks for the question, normally we would want you as a customer to be able to do this yourself. I would highly recommend taking the some more Advanced SAS training. In this case I would suggest a SAS Programming 3 course. Obviously, if you have taken the SAS Programming 2 course first.   data customer;      infile cards;      input Month $ Customer $; cards; Jan a Jan b Feb a Feb b Mar a Apr a Apr b May a May b ; run;   proc sort data=customer out=customersorted;   by customer; run;   data customernotinmonths(keep=customer month);   set customersorted end=eof;   by customer ;   Array Months(12) $ ("Jan" "Feb" "Mar" "Apr" "May" "Jun" "Jul" "Aug" "Sep" "Oct" "Nov" "Dec");   Array mthchk(12);   Retain mthchk1-mthchk12;   if first.customer then do;      do i=1 to dim(mthchk);       mthchk(i)=0;   end;   end;    do j=1 to dim(months);     if month=months(j) then mthchk(j)=1;  end;   if last.customer then do;    do x=1 to dim(mthchk);        if mthchk(x)=0 then            do;               month=months(x);               output;             end;      end; end; run; ... View more

I would highly recommend taking the SAS Macro Language 1: Essentials course as it will explain all the concepts that are confusing you and show you how to create a data-driven program. Great course and very useful. Carmine ... View more

Hello, Unfortunately, the way you are using macros will not work. Can you please be specific in what you are trying to accomplish? This will help in guiding you as the code you provide is confusing.   Just curious, have you thought of taking the SAS Macro Training?     ... View more

/*Two options below..*/   /*First option is with Macro variables, you create two macros, start and end and assign values */ %let Start=4; %let end=98; Data file1(drop=i); do i=&start to &end; Id=i; output; end; run;   /*Second option would be to use your datasource that has two observations in sorted order */ Data source; ID=4; output; ID=98; output; run; Data file2(drop=i); set source end=eof; retain start end; if _n_=1 then start=id; else end=id; if eof then do; do i=&start to &end; Id=i; output; end; end; run; ... View more

I can't reproduce it either and get only two values in the frequency. ... View more