I am trying to replace values using a script and for the first part I dont expect any changes, but SAS changes the values 'NaN' to '', which I dont understand why. Short example below data test;
infile datalines delimiter=',';
input var $ row date $ group $;
datalines;
NaN,1,31OCT2016,-1-1d
NaN,2,31OCT2016,-1-1d
GCXK,3,30APR2017,-1-1d
;
DATA test2;
SET test;
BY group;
RETAIN new_var;
IF var NE 'NaN' then new_var = var;
IF var EQ 'NaN' then var = new_var;
IF last.var then new_var = 'NaN';
DROP new_var;
RUN;
... View more