Deleting LASR records using proc imstat with Merge statement.

[jitinsethi07]

1) I have a dataset A (having millions of records) in LASR library. 

2) Importing B file with few hundred rows.

3) Need to compare A and B and delete common records from A (lasr library) without creating a temporary copy.

Solution:

Using imstat statement--(not working)

proc imstat data=LASRLIB.A;
merge LASRLIB.A (in=a)
                  B    (in=b);
if a and b;
run;
deleterows / purge; 
run;

(Note: Merge not working with proc imstat.)

Is there any other way to do it?

[jitinsethi07 · Accepted solution]

Got the solution!

Storing all unique values in macro variable and passing in where clause of proc imstat.

proc imstat = lasrlib.A;

where column = &macro;

run;

deleterows / purge;

run;