• Community
    • Home
    • Welcome
      • Getting Started
      • Community Memo
      • All Things Community
      • SAS Customer Recognition Awards (2024)
      • SAS Customer Recognition Awards (2023)
    • SAS Community Library
    • SAS Product Suggestions
    • Upcoming Events
    • SAS Customer Recognition Awards
    • All Recent Topics
  • Learn
    • New SAS User
    • SAS Software for Learning Community
    • Ask the Expert
    • SAS Certification
    • SAS Tips from the Community
    • SAS Training
      • Programming 1 and 2
      • Advanced Programming
      • Course Case Studies and Challenges
      • Trustworthy AI
    • SAS Global Forum Proceedings 2021
    • Tech Report Archive
    • SAS Insights Archive
  • Programming
    • SAS Programming
    • SAS Procedures
    • SAS Enterprise Guide
    • SAS Studio
    • Graphics Programming
    • ODS and Base Reporting
    • SAS Code Examples
    • SAS Web Report Studio
    • Developers
  • Analytics
    • Statistical Procedures
    • SAS Data Science
    • Mathematical Optimization, Discrete-Event Simulation, and OR
    • SAS/IML Software and Matrix Computations
    • SAS Forecasting and Econometrics
    • Streaming Analytics
    • Research and Science from SAS
  • SAS Viya
    • SAS Viya
    • SAS Viya on Microsoft Azure
    • SAS Viya Release Updates
    • Moving to SAS Viya
    • SAS Visual Analytics
    • SAS Visual Analytics Gallery
    • Your Journey to Success
    • SAS Viya Workbench
      • SAS Viya Workbench: Getting Started
      • SAS Viya Workbench Discussion
      • SAS Viya Workbench: Release Updates
  • Administration
    • Administration and Deployment
    • Architecture
    • SAS Hot Fix Announcements
    • SUGA
  • Solutions
    • Microsoft Integration with SAS
    • Decisioning
    • SAS Decision Builder
    • Data Management
    • Customer Intelligence
      • SAS Customer Intelligence
      • SAS Customer Intelligence 360 Release Notes
      • SAS 360 Match
    • Risk and Fraud
      • SAS Risk Management
      • Fraud, AML and Security Intelligence
      • SAS Risk Release Updates
      • Risk & Finance Analytics
      • Insurance Fraud
      • MRM AI Governance Working Group
      • SAS Quant Community
    • SAS Health
      • SAS Health and Life Sciences
      • SAS Life Science Analytics Framework
  • Hubs
    • Regional Hubs
      • SAS User Groups
      • SAS Community Nordic
      • AML Nordic User Group
      • SAS Japan
      • SAS Korea
      • CoDe SAS German
      • SAS Plattform Netzwerk
      • SAS Brazil Community
      • SAS Spanish Community
      • SAS Users Group in Israel
      • 欢迎来到SAS中文社区!
      • Ottawa Area SAS Users' Society
      • Toronto Area SAS Users Group
      • SAS Türkiye Community
    • Special Interest Hubs
      • SAS Hacker's Hub
      • SAS Innovate 2026
      • SAS Analytics Explorers
      • The Curiosity Cup
      • SAS Inner Circle Panel
      • SAS Hackathon Team Profiles (Past)
      • SAS Explore
      • Reporting and Optimization
      • Intern Alumni Network Community
Sign In

Search the Community

Showing results for 
Search instead for 
Did you mean: 
Search Options
  • Subscribe to RSS Feed for this Search
Advanced Hide Advanced
  • Posts
  • Users
  • Places
  • Products
Advanced Search Options
Search Modifiers:
You can apply modifiers to the terms you enter in the search field.
Use quotes to search for an "exact phrase".
Use the plus sign to search for +one +or +more +words.
Use the minus sign to -exclude -certain -words from your search.
Limits search results to topics that have no replies.
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
357 results
Sorted by:
Best Match
  • Date
  • Views
  • Likes
  • Replies
  • Best Match

AE Programming query

by Obsidian | Level 7 abhinayingole in SAS Programming
‎01-01-2024 11:41 AM
‎01-01-2024 11:41 AM
Hi , I need to create RANK variable in the dataset shown below (for each USUBJID and AE). The input variables are USUBJID, ASTDT, AENDT, AE, LLT. dataset sorted by USUBJID , AE , ASTDT and AE...
Show results in replies (1)
  • data test; informat usubjid $3. llt $5. ae $7. astdt date9. aendt date9.; input usubjid $ ae...

AE overlap programming query

by Obsidian | Level 7 abhinayingole in SAS Programming
‎12-29-2023 12:20 PM
‎12-29-2023 12:20 PM
Hi, I need to create SUBJOIN variable as shown below. I have information till JOIN variable. the dataset sorted by USUBJID AE ASTDT AENDT JOIN. JOIN variable reflects the overlapping A...
Show results in replies (2)
  • No Kurt, as obs. no. 2 to 9 are the overlapping AEs with AE = vomit and JOIN = 1, so they need s...
  • Try this: data want; set test; by usubjid ae join; length subjoin 8 maxjoin 8; retain maxjoin; i...

AE overlapping and duplicate entries

by Calcite | Level 5 nandini in SAS Programming
‎11-05-2013 11:45 PM
‎11-05-2013 11:45 PM
Hi all, I need to do a listing on this. Exception list:  Comparison of overlapping events (AE#1 term = AE#2 term) when  AE # <1> start date <=  AE # <2> start d...
Show results in replies (2)
  • ...ou getting the desired output. let me know if it does not meet you expectation. data aes; i...
  • ...onsidered in your code above. Please try and let me know if this is what you were expecting data aes...

Need to create JOIN variable for OVERLAPPING AEs

by Obsidian | Level 7 abhinayingole in SAS Programming
‎06-25-2025 06:22 AM
‎06-25-2025 06:22 AM
Hi ,  I have to create join variable and astdt variable (as shown in the dataset), JOIN variable for each USUBJID and AE.  ASTDT is date9. Format for AESTDTC variable. To c...

Overlapping AE Programming

by Obsidian | Level 7 abhinayingole in SAS Programming
‎12-12-2023 02:02 AM
‎12-12-2023 02:02 AM
  Hi ,   I have to create join variable in below dataset (as shown in the dataset), for each USUBJID and AE.  To check the set of observation with overlapping AEs. &n...

AE Programming query (2)

by Obsidian | Level 7 abhinayingole in SAS Programming
‎01-16-2024 01:51 AM
‎01-16-2024 01:51 AM
...bsp;5 and not 1   like this... Reason: while deriving  RANK value for obs. 7, client wanted to check latest of LLT = urea value, which is obs. no. 4 and AE...

Can sas import aes encrypted excel files?

by Quartz | Level 8 naveenraj in SAS Enterprise Guide
‎04-15-2016 05:32 AM
‎04-15-2016 05:32 AM
Hi,   Is it possible to import AES encrpted excel files.  Suppose file is of type .aes. Is it possible to directly import the file. I have heard that sas supports AES encryption. &n...
Show results in replies (1)
  • So the file itself is encrypted using some software, yes?  If so then you would un-encrypt tha...

For an AE table, how to output maximum severity level so only one pers...

by Lapis Lazuli | Level 10 Hello_there in SAS Programming
‎09-19-2022 01:45 PM
‎09-19-2022 01:45 PM
data have1; length soc_term pt_term $10; infile datalines dsd dlm=","; input subj $ soc_term $ pt_term $ aesevn; datalines; 001, soc_term1, pt_term1, 1 001, soc_term1, pt_term2, 1 001, soc_term1, p...
Show results in replies (1)
  • ...oc_term pt_term $10; infile datalines dsd dlm=","; input subj $ soc_term $ pt_term $ aesevn; d...

Comparing AE dataset from two different data cuts

by Obsidian | Level 7 Nasya in SAS Programming
‎06-21-2018 08:49 AM
‎06-21-2018 08:49 AM
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 M...
Show results in replies (1)
  • If you have datasets where you can identify observations to be compared individually (eg by a uniqu...

Need Guidance: AEOUT for Split AEs When Severity Increases

by Calcite | Level 5 amiteshm in SAS Programming
‎06-16-2025 12:38 AM
‎06-16-2025 12:38 AM
Hi everyone, I'm working on SDTM AE data, and we have a case where a single adverse event (e.g., headache) increases in severity and later becomes serious. As per CDISC and FDA guidance, we're s...
  • « Previous
    • 1
    • 2
    • 3
  • Next »
Powered by Khoros