Hi,
I have the following code that takes a huge file houtpt073 and deletes all appropriate rows based off certain column headings (serv_type, provider_id) for all non-outpatient claims. I can follow the code until it gets to the merge statement, where I don't understand what is happening. I would like to be able to recreate this in Access. Can someone please explain the "then delete" portion?
DATA H1;
SET HF.HOUTPT073;
IF SERV_TYPE3 IN ('EMERGENCY');
RUN;
DATA H2;
SET HF.HOUTPT073;
IF SERV_TYPE1 IN ('OUTPATIENT');
IF SUBSTR(PROVIDER_ID,1,2) IN ('81','82') THEN DELETE;
RUN;
PROC SORT DATA=H1 NODUPKEY; BY CLAIM_NUMBER; RUN;
PROC SORT DATA=H2; BY CLAIM_NUMBER; RUN;
DATA HF.SMD2224Q;
MERGE H1(IN=A) H2(IN=B);
BY CLAIM_NUMBER;
IF A AND B THEN DELETE;
RUN;