I was reading the solution here: https://communities.sas.com/t5/SAS-Programming/How-to-find-the-rows-for-which-consecutive-columns-have-blank/td-p/776068 In his answer, there is "_count". What is the functionality of adding "_" in front of count here? data have;
infile cards expandtabs truncover;
input Customer $ M1 M2 M3 M4 M5 M6 M7 M8 M9 M10 M11 M12;
cards;
A . 94 63 106 424 252 499 356 435 469 200 423
B . . . . . . . 13 137 440 75 99
C 67 118 364 . . . . . . 156 40 415
D 430 423 . . . . 54 165 26 477 129 411
;
data want;
set have;
array x{*} M: ;
count=0;
do i=1 to dim(x);
if missing(x{i}) then count+1;
else do;
count=0;
if _count>5 then month=vname(x{i});
end;
_count=count;
end;
drop count _count i;
run;
... View more
