Sorry for making you confused. The word "truncover" was in one of your posts where you provided the sample dataset. Forget that. Anyway, most probably SAS is unable to read your data correctly. Could you send the result from the following two statements, please. proc print data=final (obs=10); run; proc contents data=final; run; ... View more

Just replace truncover with dlm=" " Then do, proc freq data=final; where Week_Volume=0; table brand_name; run; ... View more

In your code replace truncover with dlm=" " then try ... View more

The following statement works as well. You will not need to create any subset.   In your code replace truncover with dlm=" " You will not get any error.     proc freq data=final; where Week_Volume=0; table brand_name; run; ... View more

I did not get any errors. Please restart your SAS and copy the whole thing from my answer and run. ... View more

Here you go data FINAL; infile datalines dsd dlm=" "; input brand_name :$10. Year0 :4. week :2. Week_Volume :2.; format Year0 4. week 2. Week_Volume 2.; datalines; Absolut 2014 6 4 Absolut 2014 7 0 Absolut 2014 8 0 Absolut 2015 0 2 Absolut 2015 1 6 Absolut 2015 2 3 Aeromexico 2014 6 0 Aeromexico 2014 7 0 Aeromexico 2014 8 0 Aeromexico 2014 9 0 Aeromexico 2015 0 2 Aeromexico 2015 1 8 Aeromexico 2015 2 8 Air Canada 2014 6 29 Air Canada 2014 7 34 Air Canada 2014 8 25 Air Canada 2015 0 0 Air Canada 2015 1 25 Air Canada 2015 2 18 Air France 2014 6 4 Air France 2014 7 2 Air France 2014 8 5 Air France 2015 0 1 Air France 2015 1 3 Air France 2015 2 2 ; run; data final1; set final; where Week_Volume=0; run; proc means data=final1 n; var Week_Volume; by brand_name; run; ... View more

You may want to create a subset where wkvol=0. Then do proc means by brand name.   see below;   data hv; infile datalines dsd dlm=',' ; input name :$3. wkvol 5.; datalines; abc,0 def,023 pqr,125 xyz,200 jkl,0 jkl,0 jkl,280 run; data hv1;     set hv;     where wkvol=0; run; proc sort data=hv1;   by name; run;   proc means data =hv1 n;    var wkvol;   by name; run; ... View more

Could you provide a sample data, please. ... View more

My bad! Never mind. I thought you have data from many weeks. ... View more

You may want to try something as below.   if Week_Volume1  =0 then do; count1=1; end; if Week_Volume2  =0 then do; count2=1; end; if Week_Volume3  =0 then do; count3=1; end; if Week_Volume4  =0 then do; count4=1; end; if Week_Volume5  =0 then do; count5=1; end; if Week_Volume6  =0 then do; count6=1; end; if Week_Volume7  =0 then do; count7=1; end;   zero_vol_wk = sum (of count1 - count7); drop count1 - count7; ... View more