topic Could you please help me understand how the code runs in background? in New SAS User

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

d6k5d3 — Mon, 09 Mar 2020 03:05:16 GMT

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;

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

mkeintz — Mon, 09 Mar 2020 04:38:00 GMT

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.

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

Patrick — Mon, 09 Mar 2020 04:46:52 GMT

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;