/************************ define variable *****************************/ %let target_wafer = 288760; %let target_op = 9689; %let target_parm = 'HEATERSUB'; %let PARM = HEATERSUB; /************************ pull raw data from CHIMP *****************************/ proc sql; connect to db2 (&wafer_server.); create table rawdata as select * from connection to db2 ( SELECT A.WAFERNUM, A.PROCESSDATE, A.HT, A.OP, A.WAFERSIZE, A.PARMNAME, A.ROWNUM, A.COL01,A.COL02,A.COL03,A.COL04,A.COL05,A.COL06,A.COL07,A.COL08, A.COL09,A.COL10,A.COL11,A.COL12,A.COL13,A.COL14,A.COL15,A.COL16,A.COL17,A.COL18,A.COL19,A.COL20,A.COL21,A.COL22, A.COL23,A.COL24,A.COL25,A.COL26,A.COL27,A.COL28,A.COL29,A.COL30,A.COL31,A.COL32,A.COL33,A.COL34,A.COL35,A.COL36, A.COL37,A.COL38,A.COL39,A.COL40,A.COL41,A.COL42,A.COL43,A.COL44,A.COL45,A.COL46,A.COL47,A.COL48,A.COL49,A.COL50, A.COL51,A.COL52,A.COL53,A.COL54,A.COL55,A.COL56,A.COL57,A.COL58,A.COL59,A.COL60 From wtooldet.CHIMP A WHERE A.WAFERNUM in (&target_wafer.) AND A.PARMNAME in (&target_parm.) AND A.OP in (&target_op.) order by ROWNUM ); disconnect from db2; quit; proc transpose data=rawdata out=rawdata_transp name=COLNUM; label COLNUM='COLNUM'; by WAFERNUM WAFERSIZE ROWNUM PROCESSDATE; var COL01 - COL60; id PARMNAME; run; data rawdata_transp (keep = WAFERNUM WAFERSIZE ROWNUM COLNUM &PARM.); set rawdata_transp; colnum = substr(COLNUM,4,2); run; ERROR: 1303 data rawdata_transp (keep = WAFERNUM WAFERSIZE ROWNUM COLNUM &PARM.); - 214 23 ERROR 214-322: Variable name & is not valid. ERROR 23-7: Invalid value for the KEEP option. ----- 23 1303! data rawdata_transp (keep = WAFERNUM WAFERSIZE ROWNUM COLNUM &PARM.); ----- 214 WARNING: Apparent symbolic reference PARM not resolved. ERROR 214-322: Variable name PARM. is not valid. 1304 set rawdata_transp; 1305 colnum = substr(COLNUM,4,2); 1306 run; I defined two macro variable to define HEATERSUB w/o '', because the '&PARM.' is not working.
... View more