topic Re: Issue or my lack of understanding: Sum statement with RETAIN vs NO RETAIN handling missing value in SAS Programming

Issue or my lack of understanding: Sum statement with RETAIN vs NO RETAIN handling missing values

novinosrin — Fri, 10 Sep 2021 14:50:16 GMT

Is the below an Issue or my lack of understanding: Sum statement with RETAIN vs NO RETAIN handling missing values



data _null_;
  retain k;
  b=.;
  k+b;
  put k=;
run;


data _null_;
/*  retain k;*/
  b=.;
  k+b;
  put k=;
run;

Can somebody explain and help me why the difference in the results of K in the above 2 programs plz? Thank you in advance!

LOG-


70
71   data _null_;
72     retain k;
73     b=.;
74     k+b;
75     put k=;
76   run;

k=.
NOTE: DATA statement used (Total process time):
      real time           0.00 seconds
      cpu time            0.00 seconds


77
78
79   data _null_;
80   /*  retain k;*/
81     b=.;
82     k+b;
83     put k=;
84   run;

k=0
NOTE: DATA statement used (Total process time):
      real time           0.00 seconds
      cpu time            0.00 seconds

Re: Issue or my lack of understanding: Sum statement with RETAIN vs NO RETAIN handling missing value

data_null__ — Fri, 10 Sep 2021 15:28:27 GMT

@novinosrin wrote:

Is the below an Issue or my lack of understanding: Sum statement with RETAIN vs NO RETAIN handling missing values
data _null_;
  retain k;
  b=.;
  k+b;
  put k=;
run;


data _null_;
/*  retain k;*/
  b=.;
  k+b;
  put k=;
run;
Can somebody explain and help me why the difference in the results of K in the above 2 programs plz? Thank you in advance!

LOG-
70
71   data _null_;
72     retain k;
73     b=.;
74     k+b;
75     put k=;
76   run;

k=.
NOTE: DATA statement used (Total process time):
      real time           0.00 seconds
      cpu time            0.00 seconds


77
78
79   data _null_;
80   /*  retain k;*/
81     b=.;
82     k+b;
83     put k=;
84   run;

k=0
NOTE: DATA statement used (Total process time):
      real time           0.00 seconds
      cpu time            0.00 seconds

In your first data step you RETAIN K and implicitly initialize to missing.

Re: Issue or my lack of understanding: Sum statement with RETAIN vs NO RETAIN handling missing value

novinosrin — Fri, 10 Sep 2021 15:40:35 GMT

Right, got it sorry my bad!

Re: Issue or my lack of understanding: Sum statement with RETAIN vs NO RETAIN handling missing value

Ksharp — Sat, 11 Sep 2021 12:15:26 GMT

Sum statement include another implicated statement (i.e. retain k 0 😉