filter data

[tianerhu]

libname certadv '/home/u36373693/OnDemand/Practice-Data/Certadv';
proc means data = certadv.payrollmaster mean;
var salary;
class  jobcode;
run;

tianerhu_0-1629770474375.png

If I want to know mean>56000, what should I do ?

[SASKiwi · Accepted solution]

PROC MEANS does the mean calculation so you can't filter in this procedure.

You need to create an output dataset from MEANS (hint - use the OUTPUT statement), then apply a filter on that.

[tianerhu]

Thank you for your help .