Help using Base SAS procedures

How to show new/updated records in the target table?

Reply
N/A
Posts: 0

How to show new/updated records in the target table?

Hi,

I have a question regarding the using of the SAS Data Integration Studio.

The scenario is like this:
If i have 1 million records previous in this dataset, then i do a update on 1 record and insert another record to the dataset.

Am I able to reflect the changes ( 1 updated record and 1 inserted record ) in the dataset. As in only show these 2 records only. Is it possible?

Thanks.

Yours Sincerely,
helphelp
Super Contributor
Posts: 326

Re: How to show new/updated records in the target table?

Posted in reply to deleted_user
Hi,

I'm not sure if there's actually a way to do that. However if you would like to track changes in your dataset you might opt to use the SCD Type 2 Loader transformation. Hope this helps

Regards,
milton
Valued Guide
Posts: 2,177

Re: How to show new/updated records in the target table?

Posted in reply to deleted_user
have you looked at SAS audit trails?
Ask a Question
Discussion stats
  • 2 replies
  • 108 views
  • 0 likes
  • 3 in conversation