What is the best way to count AEs? I can't count any duplicates per subject in SOC and PT. Need to get max severity and closest relatedness (related to study drug or not related to study drug). Currently, I just make some occurrence flags and sum them in proc SQL get the n and percent from doing that and go through proc transpose and proc report. If someone knows a better way, I'm curious.
This is not actually SAS related question, but you can get rid off some duplicates if you are using AEGRPID variable to group fluctuating AE's as with one Group ID. You can find more information from CDISC website.
I disagree. I think it is SAS-related seeing how I use SAS to make AE summary tables. I don't have AEGRPID variable either.
@Reeza do I have to do several different proc freqs to get this though? I have a top row for Any SOC Any PT and then I have SOC Any PT and then the rows under that SOC would be the PTs within that SOC. Cannot count duplicates in SOC and PT. If there is a duplicate, it has to be only the one with max severity and max relatedness.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.