• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 183
  • Last Modified:

SAS Control Chart Question

I am new to SAS. I need to only return control charts that identify outliers.  Below is my current control chart code.  Is there a function or syntax that i could use that would only return outliers.

proc shewhart data=mywork.TREND; by recCd;
xchart BALAMT * MonYr / sigmas=2;
      run;
0
Thomask23
Asked:
Thomask23
1 Solution
 
ShannonEECommented:
Hi there Thomask23,

Ask the procedure to output the chart limits using the outlimits option on XCHART, and then use those limits to select the outliers.


proc shewhart data=mywork.TREND; by recCd;
        xchart BALAMT * MonYr /
                sigmas=2
                OUTLIMITS=WORK.limits(LABEL="Chart limits for BALAMT");
 run;

** Select only the outliers (those beyond the chart control limits givren by _LCLX_ and _UCLX_ **;
** can use SQL or could use a data step **;

proc sql;
        create table Mywork.Outliers as
        select Balamt,
               MonYr
        from  Mywork.Trend
        left join
              work.Limits
        on (Balamt < _LCLX_) or
           (Balamt > _UCLX_);
quit;

Open in new window


More details at

SAS support site

Hope this helps.

Regards,
Ian
0

Featured Post

Learn to develop an Android App

Want to increase your earning potential in 2018? Pad your resume with app building experience. Learn how with this hands-on course.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now