Could you please help me understand how the code runs in background?

[d6k5d3]

I am trying to understand how the code runs in the loop to generate the desired outcome:

data Zero_Returns; *calculating number of incidents of zero returns everyday;
set HUF;			*and number of zero returns in each of those incidents;
by Date Return notsorted;

if first.Date then Incident_No= 0;
if first.Return then Consecutive_Zero= 1;
else Consecutive_Zero+1;
if last.Return;
if Return= 0;
Incident_No+1;

run;

[mkeintz]

Please provide, in the form of a sas DATA step, a sample of your data.   And an example of what you expect the output to look like.  Your question has too many ambiguities for me to feel I understand it properly.

Help us help you.

[Patrick]

Same logic just not using sub-setting IF. Does this make it better understandable for you?

/** 
calculating number of incidents of zero returns everyday
and number of zero returns in each of those incidents 
**/
data Zero_Returns;
  set HUF;
  by Date Return notsorted;
  if first.Date then Incident_No= 0;
  if first.Return then Consecutive_Zero= 1;
  else Consecutive_Zero+1;
  if last.Return and Return= 0 then
    do;
      Incident_No+1;
      output;
    end;
run;