Hi, An absolute noob here. I want to be able to count the number of zeroes per row (in this case stores) that follows non- zero values. However, I am unable to run the macro get the data step of my dataset, so apologies for the data sample below: data WORK.CLASS(label='Store Data');
infile datalines dsd truncover;
input Store:$8. Mon_01:comma18.6 Mon_02:comma18.6 Mon_03:comma18.6 Mon_04:comma18.6;
datalines;
123 373 373 374 375
297 0 0 0 0
1256 0.032 0.013 0 0.012
5042 34 0 62 0
9880 .9 .89 0 0
;;;; I have tried multiplying the columns with the previous columns (Mon_01 * Mon_02, Mon_02 * Mon_03) , but somehow it does not work and I know that there is a better way to count the zeroes per store. Thanks in advance. Filoplume
... View more