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;
... View more