topic program code verification in SAS Procedures

program code verification

sas_learner_NEW — Thu, 24 Feb 2022 07:42:06 GMT

Dear community, As a beginner in this community I would request a help. is the code for the question

" What is the mean value of the Sales variable for observations in the “Middle” group? Round
your answer to the nearest whole number. " correct or please suggest any modification.

proc means data= work.shoesrange nolabels mean;
class salesrange;
run;

Re: program code verification

PeterClemmensen — Thu, 24 Feb 2022 07:46:30 GMT

I can't see your data, so I can only guess that the "Middle" group is in the salesrange variables.

In that case, yes, your code is fine and will give you the mean value for the "Middle" group in the Results Viewer.

You could specify the MAXDEC Option in the Proc Means Statement to specify the desired number of decimals.

Re: program code verification

Kurt_Bremser — Thu, 24 Feb 2022 07:57:12 GMT

Since you only want one group, you should restrict the observations to that group.

You also want only one variable averaged, so you should tell the procedure that.

proc means data=shoesrange nolabels mean;
where salesrange = "Middle"; /* if "Middle" is in fact the result of a custom format applied to salesrange, this must be adapted */
var sales;
run;

Alternatively, you can use SQL:

proc sql;
select avg(sales) as average_sales
from shoesrange
where salesrange = "Middle";
quit;

Re: program code verification

sas_learner_NEW — Thu, 24 Feb 2022 12:22:15 GMT

thanks