Hello,
Im building a Stored Process and i have like an ID which can be in 4 tables.
If it is in table A, i want to get the data from table A.
If ti is in table B, i want to get the data from table B,
...
at the moment i'm doing the following but it takes a long time, not efficient enough
/* See which type of data it is - in which EDC table do i find it */
proc sql noprint; select count(*) into:NumberEdcThick from RF300L3.edc_thick where col_ins_id = "&sel_col_ins_id";quit;
%put &NumberEdcThick;
proc sql noprint;
select count(*) into:NumberEdcCd from RF300L3.edc_cd where col_ins_id = "&sel_col_ins_id";quit;
%put &NumberEdcCd;
proc sql noprint; select count(*) into:NumberEdcTxrF from RF300L3.edc_txrf where col_ins_id = "&sel_col_ins_id";quit;
%put &NumberEdcTxrF;
%macro getData;
%if &NumberEdcCd > 0 %then %do;
data out_table;
set RF300L3.edc_cd;
where col_ins_id = "&sel_col_ins_id";
CALL SYMPUT('TYPE', 'EDC_CD - Format');
run;
%end;
%else %if &NumberEdcThick > 0 %then %do;
data out_table;
set RF300L3.edc_thick;
where col_ins_id = "&sel_col_ins_id";
CALL SYMPUT('TYPE', 'THICK - Format');
run;
%end;
%else %if &NumberEdcTxrF > 0 %then %do;
data out_table;
set RF300L3.edc_txrf;
where col_ins_id = "&sel_col_ins_id";
CALL SYMPUT('TYPE', 'TXRF - Format');
run;
%end;
%else %do;
data _null_;
CALL SYMPUT('TYPE', 'General - Format');
run;
%extract_edc_full(pInProcess WaferId User_id State Slot ROW_ID ProcessRecipe ProcessPlan PmProcedure MeasRecipe
MeasKey MainTool LotId LimitsKey InspectionTool Facility DuploWaferId Datim CustomKey
ChecklistActivityId CSIM_TIMESTAMP COL_INS_ID, out_table);
%end;
%mend;
%getData;