@Jonison wrote: Can I have some advice that if the PLS procedure can do the pre-treatment separately for X and Y variables, e.g. supress X variables pre-treatment while standardize Y variables. If you want to standardize X and Y separately, where X is not standardized while Y is standardized, this would have to be done using code to modify the data appropriately before PROC PLS runs. Then in PROC PLS you would use the NOCENTER and NOSCALE options.   Please note that if you don't standardize the X variables, the variables with larger variances will tend to have larger effects in prediction (which may be the right thing to do in some applications, but the wrong thing to do in other applications). ... View more

thanks for your promote reply. bet we are in different time zone.   I tried the code, but the data is not sorted out. the results of ID2 doesnot have missing value (suppose to have missing value). It seems that the sorting are based on ID2 and ID3 whose value are not missing.   I changed the data a bit, hope this make it a bit clear.    Table A ID1 ID2 V1 V2 V3 1 b 12 15 18 3 dd 13 16 19 4 c 14 17 11 5 f 56 7 8 6 h 34 5 6 7 ggg 78 93 3 Table B ID1 ID2 v1 v2 v3 1 e 23 22 27 3 d 24 21 26 4 c 25 28 25 5 h 22 26 22 Table C ID1 ID2 ID3 1 e b 3 d dd 4 c   5 f   6 h     Results   ID1 ID2 V1 V2 V3 _ID2 _ID3 1 b 23 22 27 e b 3 dd 24 21 26 d dd 4 c 25 28 25 c   5 f 56 7 8 f   6 h 22 26 22 h   7 ggg 78 93 3       In table A (ID1 =1 and 3, v1-3 values have been replaced by table B because the mapping in Table C)   But also 4 c 14 17 11 is replaced as 4 c 25 28 25   Same for ID1=6 in table A   Thanks and hope this makes it a bit clear.     ... View more

Many thanks for your kind reply. I was thinking to use into: to put the queried data into the table directly. PROC SQL; SELECT quote(MATERIAL) into: List separated by ',' FROM EMWS3.FILTER_TRAIN; /*CREATE &EM_EXPORT_TRAIN AS*/ SELECT BAT_NUM, MAT_COD, UNRESTRICTED_QTY INTO: EMWS3.EMCODE_TRAIN FROM GDM_DIST.VW_MERPS_STOCKINV_INFO WHERE T2.MAT_COD IN (&List); QUIT; But system shows the error: 7946 PROC SQL; 7947 SELECT quote(MATERIAL) into: List separated by ',' FROM EMWS3.FILTER_TRAIN; NOTE: There were 240 observations read from the data set EMWS3.FIMPORT_DATA. NOTE: View EMWS3.FILTER_TRAIN.VIEW used (Total process time): real time 0.12 seconds cpu time 0.11 seconds NOTE: There were 240 observations read from the data set EMWS3.FIMPORT_TRAIN. 7948 /*CREATE &EM_EXPORT_TRAIN AS*/ 7949 SELECT BAT_NUM, 7950 MAT_COD, 7951 UNRESTRICTED_QTY 7952 INTO: EMWS3.EMCODE_TRAIN FROM GDM_DIST.VW_MERPS_STOCKINV_INFO _ 22 76 ERROR 22-322: Syntax error, expecting one of the following: ',', -, FROM, SEPARATED, THROUGH, THRU, TRIMMED. ERROR 76-322: Syntax error, statement will be ignored. 7953 WHERE T2.MAT_COD IN (&List); NOTE: PROC SQL set option NOEXEC and will continue to check the syntax of statements. 7954 /*SELECT * FROM EM_EXPORT_TRAIN;*/ 7955 /*%let EM_EXPORT_TRAIN=TABLELIST;*/ 7956 /*%let &EMWS3.EMCODE_TRAIN=TABLELIST;*/ 7957 /*INSERT INTO &EM_EXPORT_TRAIN 7958 SELECT * FROM &TABLELIST;*/ 7959 7960 QUIT; NOTE: The SAS System stopped processing this step because of errors. NOTE: The PROCEDURE SQL printed page 11. NOTE: PROCEDURE SQL used (Total process time): real time 0.13 seconds cpu time 0.13 seconds 7961 7962 /*; *"; *'; */; Would you please suggest on this? Many thanks ... View more

has been solved, I think put too many variables in MODEL statement makes impossible to execute. just use %let to define xvars and yvars, and nodes can be executed successfully.  thanks for helping. ... View more