Solved

SAS Control Chart Question

Posted on 2014-12-15
1
137 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

Question has a verified solution.

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

From Coral's  "So You Want To Play With Computers" Series Preface: What follows is a tweaked reprint from 2005/06. This is a True Story. The names have been changed to protect the guilty. While this deals with a fairly simple, text file recovery…
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…
This tutorial will walk an individual through locating and launching the BEUtility application and how to execute it on the appropriate database. Log onto the server running the Backup Exec database. In a larger environment, this would generally be …
To efficiently enable the rotation of USB drives for backups, storage pools need to be created. This way no matter which USB drive is installed, the backups will successfully write without any administrative intervention. Multiple USB devices need t…

726 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