proc means #ways statement

[Bhagyalakshmi]

proc means data=pg1.np_westweather noprint; 
    where Precip ne 0; 
    var Precip; 
    class Name Year; 
    ways 2; 
    output out=rainstats n=RainDays sum=TotalRain; 
run; 
 
title1 'Rain Statistics by Year and Park'; 
proc print data=rainstats label noobs; 
    var Name Year RainDays TotalRain; 
    label Name='Park Name' 
          RainDays='Number of Days Raining' 
          TotalRain='Total Rain Amount (inches)'; 
run; 
title; 

what this program actually do it gives sometime the missing values ?!

[PaigeMiller]

Where are the missing values? Are they missing for RainDays or TotalRain? If so, then your original data has missing values, or your data has lots of zero which are excluded by your code's WHERE statement.

If the missing values are somewhere else, show us the output.

[Bhagyalakshmi]

I used ways statement 2 i doesnt show any missing unless i used the following program by ways 0 1 only it show the some missing in year but not in name

[PaigeMiller]

SHOW US what you are seeing. Show us the exact code that created the output you are showing us. Include your screen capture of the output by clicking on the "Insert Photos" icon. Do not attach files.

[Bhagyalakshmi]

this is ways 0 option i gave in proc means stepthis is the ways 1 option i gave in proc means stepthis is for ways 2 option i gave in proc means step

[PaigeMiller · Accepted solution]

This looks correct to me.

When you specify WAYS 0, SAS does not slice the data by either ParkName or Year. You get the overall N and overall SUM, and so ParkName and Year are missing.

When you specify WAYS 1, SAS slices the data first by ParkName only (not  by Year, so year is missing) and the it slices the data by Year only (not by ParkName, so ParkName is missing).