topic Re: proc means #ways statement in SAS Programming

proc means #ways statement

Bhagyalakshmi — Tue, 09 Jul 2024 11:06:00 GMT

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 ?!

Re: proc means #ways statement

PaigeMiller — Tue, 09 Jul 2024 11:10:27 GMT

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.

Re: proc means #ways statement

Bhagyalakshmi — Tue, 09 Jul 2024 11:11:31 GMT

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

Re: proc means #ways statement

PaigeMiller — Tue, 09 Jul 2024 11:21:11 GMT

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.

Re: proc means #ways statement

Bhagyalakshmi — Tue, 09 Jul 2024 11:40:28 GMT

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

Re: proc means #ways statement

PaigeMiller — Tue, 09 Jul 2024 11:44:50 GMT

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).