SAS PROC DATASET WITH APPEND

I use PROC DATASETS with APPEND statement as a way to add transactions
to the base dataset. My base dataset has a combined key to prevent
dupplicate transactions beeing added. So far it worked fine while no
dupplication occured.

When I tryed to add duplicated transactions because of slight date
overlap, proc dataset started to hangout with no response. I would
expect behaviour similar to proc sql with insert command where the
dupplicate records are rejected and the rest is inserted.

It looks like PROC DATASET has problems with adding records that
violate uniqueness of the index. At least it takes too long to wait
till the end.

The advantage of APPEND is that you do not neet explicitly list all columns,
but this turns out to be an issue with indexed datasets.

http://www.4suc6.com
Share your goals!

--
Met vriendelijke groet,
Maxim

http://www.4suc6.com
Share your goals!