DATA Step, Macro, Functions and more

Comparing AE dataset from two different data cuts

Accepted Solution Solved
Reply
Contributor
Posts: 25
Accepted Solution

Comparing AE dataset from two different data cuts

Hi,

 

My question is can we compare the AE data set of two different data cuts. Is this possible?

For example, lets imagine there was a data cut in June 12 2018 and a previous data cut in March 10 2018. Can we write a code in such a way, that AE dataset can be compared from these two different data cuts and changes can be reported in the output?

Thank you,

 

Regards,

Nasya


Accepted Solutions
Solution
‎06-21-2018 09:25 AM
Super User
Posts: 10,280

Re: Comparing AE dataset from two different data cuts

If you have datasets where you can identify observations to be compared individually (eg by a unique key), proc compare will be the way to go. If not, use summary steps first, and use compare on the results.

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
How to convert datasets to data steps
How to post code

View solution in original post


All Replies
Super User
Posts: 10,280

Re: Comparing AE dataset from two different data cuts

What do you mean by "AE"?

And define what constitutes a change.

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
How to convert datasets to data steps
How to post code
Contributor
Posts: 25

Re: Comparing AE dataset from two different data cuts

Posted in reply to KurtBremser

AE is Adverse Events. Changes I meant, were to compare if there were any modifications/additions done by the site? 

Solution
‎06-21-2018 09:25 AM
Super User
Posts: 10,280

Re: Comparing AE dataset from two different data cuts

If you have datasets where you can identify observations to be compared individually (eg by a unique key), proc compare will be the way to go. If not, use summary steps first, and use compare on the results.

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
How to convert datasets to data steps
How to post code
☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 3 replies
  • 66 views
  • 0 likes
  • 2 in conversation