Solved

SAS Control Chart Question

Posted on 2014-12-15
1
125 Views
Last Modified: 2016-02-13
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
Comment
Question by:Thomask23
1 Comment
 
LVL 8

Accepted Solution

by:
ShannonEE earned 500 total points
ID: 40501749
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

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

A Bare Metal Image backup allows for the restore of an entire system to a similar or dissimilar hardware. They are highly useful for migrations and disaster recovery. Bare Metal Image backups support Full and Incremental backups. Differential backup…
Learn how the use of a bunch of disparate tools requiring a lot of manual attention led to a series of unfortunate backup events for one company.
In this Micro Tutorial viewers will learn how to restore their server from Bare Metal Backup image created with Windows Server Backup feature. As an example Windows 2012R2 is used.
In this Micro Tutorial viewers will learn how to restore single file or folder from Bare Metal backup image of their system. Tutorial shows how to restore files and folders from system backup. Often it is not needed to restore entire system when onl…

777 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question