?
Solved

SAS Control Chart Question

Posted on 2014-12-15
1
Medium Priority
?
146 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 2000 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

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Backing up data is essential for any office small or large. Most think that a simple USB drive will suffice. Even the USB drives themselves display words like backup.   Most novices will ask themselves the question “Will this work for my business…
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.
This tutorial will show how to configure a new Backup Exec 2012 server and move an existing database to that server with the use of the BEUtility. Install Backup Exec 2012 on the new server and apply all of the latest hotfixes and service packs. The…
This tutorial will show how to configure a single USB drive with a separate folder for each day of the week. This will allow each of the backups to be kept separate preventing the previous day’s backup from being overwritten. The USB drive must be s…

801 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