topic Re: How can i hard code the control limits in a control chart for a data set%3F in Statistical Procedures

How can i hard code the control limits in a control chart for a data set%3F

Sepideh_B — Wed, 24 Jul 2019 13:52:44 GMT

I have a data set, for which I would like to create a control chart, however I would like the values of the control limit and Mean be hard coded by myself and not calculated based on the active data.

There seems to be an option in the control chart options to manually have the limits entered, however i cant get the numbers entered match with what eventually displays in the chart.

what am i missing? how can i force 3 specific values for Mean/LCL and UCL?

took some screenshots attached..

Re: How can i hard code the control limits in a control chart for a data set%3F

PaigeMiller — Wed, 24 Jul 2019 14:20:03 GMT

Show us the code of what you have tried.

Also, have you tried using the MU0= and SIGMA0= options?

Re: How can i hard code the control limits in a control chart for a data set%3F

Sepideh_B — Wed, 24 Jul 2019 19:41:35 GMT

I actually havent tried any codes, everything is auto generated by SAS, II have a dataset as below:

951
861
877
822
854
847
840
858
853
825
823
821
840
833
843
840
842
859
861
825
878
835
853
856
855
860
813
831
819
840

and I want to enforce Mean = 847 UCL =900 LCL =794

when the table with the above column gets generated, I use the option: Analysis - control charts - individual control charts - to get to the attached page that i showed previously.

Sas auto generates the below code for the control chart when i perform the above..

/* -------------------------------------------------------------------
Code generated by SAS Task

Generated on: Wednesday, July 24, 2019 at 3:33:13 PM
By task: Individual Measurements Chart1

Input Data: BIApp_USER:WORK.AHT
Server: BIApp_USER
------------------------------------------------------------------- */

%_eg_conditional_dropds(WORK.SORTTempTableSorted);
/* -------------------------------------------------------------------
PROC SHEWHART does not support DEVICE=ACTIVEX. Switching to PNG.
------------------------------------------------------------------- */
OPTIONS DEV=PNG;
DATA PLIMITS;
_VAR_= 'Week_Metric';
_SUBGRP_= 'Week_no_year';

_SIGMAS_= 0.1;
_UCLI_=900;
_MEAN_=847;
_LCLI_=794;
_LCLR_=794;
_R_=847;
_UCLR_=900;
output;

run;
SYMBOL VALUE=PLUS;
/* -------------------------------------------------------------------
Sort data set BIApp_USER:WORK.AHT
------------------------------------------------------------------- */

PROC SQL;
CREATE VIEW WORK.SORTTempTableSorted AS
SELECT T.Week_Metric, T.Week_no_year
FROM WORK.AHT as T
;
QUIT;
TITLE;
TITLE1 "Shewhart analysis of: Week_Metric*Week_no_year";
FOOTNOTE;
FOOTNOTE1 "Generated by the SAS System (&_SASSERVERNAME, &SYSSCPL) on %TRIM(%QSYSFUNC(DATE(), NLDATE20.)) at %TRIM(%SYSFUNC(TIME(), TIMEAMPM12.))";
PROC SHEWHART DATA = WORK.SORTTempTableSorted
LIMITS=PLIMITS;
;
IRCHART (Week_Metric) * Week_no_year /

SIGMAS=0.1
CAXIS=BLACK
WAXIS=1
CTEXT=BLACK
CINFILL=CXA9A9A9
CLIMITS=BLACK
TOTPANELS=1
NOCHART2
CCONNECT=BLUE
COUT=RED
COUTFILL=RED
CFRAME=CXD3D3D3
LIMITN=2
;
;
/* -------------------------------------------------------------------
End of task code.
------------------------------------------------------------------- */
RUN; QUIT;
%_eg_conditional_dropds(WORK.SORTTempTableSorted);
TITLE; FOOTNOTE;
/* -------------------------------------------------------------------
Restoring original device type setting.
------------------------------------------------------------------- */
OPTIONS DEV=ACTIVEX;

Re: How can i hard code the control limits in a control chart for a data set%3F

PaigeMiller — Wed, 24 Jul 2019 19:46:49 GMT

I cannot download Microsoft Office documents from web sites, it's a security risk. Can you provide the graphics via a .pdf file, or by including them directly in your reply?

Are you doing this in Enterprise Guide via the user interface and not via writing your own code?

Re: How can i hard code the control limits in a control chart for a data set%3F

Sepideh_B — Wed, 24 Jul 2019 20:10:32 GMT

I attached a PDF file here with the full description of the issue. I am using Enterprise guide, the user interface, not code for creating the control charts..

Re: How can i hard code the control limits in a control chart for a data set%3F

PaigeMiller — Wed, 24 Jul 2019 20:14:40 GMT

I see what you mean, but I can't help with the Enterprise Guide graphic user interface.