Deleting LASR records using proc imstat with Merge statement.

jitinsethi07 — Thu, 07 Dec 2017 06:27:36 GMT

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?

Re: Deleting LASR records using proc imstat with Merge statement.

jitinsethi07 — Fri, 08 Dec 2017 08:46:29 GMT

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;