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..
Show us the code of what you have tried.
Also, have you tried using the MU0= and SIGMA0= options?
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;
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?
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..
I see what you mean, but I can't help with the Enterprise Guide graphic user interface.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 16. Read more here about why you should contribute and what is in it for you!
ANOVA, or Analysis Of Variance, is used to compare the averages or means of two or more populations to better understand how they differ. Watch this tutorial for more.
Find more tutorials on the SAS Users YouTube channel.