cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
mahossain
‎08-31-2020
  • 9 Posts
  • 1 Likes Given
  • 0 Solutions
  • 0 Likes Received

Explain the following code;

by Calcite | Level 5 in SAS Programming
‎08-18-2020 01:35 PM
‎08-18-2020 01:35 PM
%macro birth (BRTHDTC=,BRTHDT=); if length(&BRTHDTC)=10 then &BRTHDTC._=&BRTHDTC; else if length(&BRTHDTC)=7 then &BRTHDTC._=strip(&BRTHDTC)||'-15'; else if length(&BRTHDTC)=4 then &BRTHDTC._=strip(&BRTHDTC)||'-07-01'; else &BRTHDTC._=''; &BRTHDT=input(&BRTHDTC._,yymmdd10.); format &BRTHDT date9.; drop &BRTHDTC._; %mend birth; Q1: Can i the length with if statement without macro?  Q2: why did we use BRTHDTC_; what does it mean variable with underscore ... View more

Sample program to create derived ADSL dataset using ADaM Specification

by Calcite | Level 5 in SAS Programming
‎08-06-2020 08:52 AM
‎08-06-2020 08:52 AM
I'm new learning SAS programming for Clinical trail. Could you pls share a sample SAS Program to create ADSL datasets using ADaM specification; Also please share related video, document with example.   ... View more

difference of # of days from 1st row to 2nd row and 2nd row to 3rd row...

by Calcite | Level 5 in New SAS User
‎07-21-2020 12:54 PM
‎07-21-2020 12:54 PM
i.e first # of days (difference)  will be missing and the 2nd will be difference of Jan 22, 2020-Jan 01, 2020 and so on by ID ID       Date                   # of days (difference) 1       Jan 01, 2020            1       Jan 22, 2020 1       Feb 02, 2020 2      Jan 01, 2020 2      Jan 24, 2020 2      Feb 12, 2020 ... View more

difference between Set and Marge statement, why output table is differ...

by Calcite | Level 5 in SAS Programming
‎07-20-2020 04:07 PM
‎07-20-2020 04:07 PM
/* Concatenate (or Union) the two data sets*/ data GroupA; input ID$ Product$; datalines; A Apple B Grapes B Orange C Banana E Apple run; data GroupB; input ID$ Product$ Size$; datalines; B Shirt S C Pants M D Jacket L E Tie M E Wallet L run; data concat; set GroupA GroupB; run; proc sort data=concat; by ID; run; /* Merge the two data sets*/ data merged; merge GroupA GroupB; by ID; run; ... View more

Re: List of ID with multiple conditions either or

by Calcite | Level 5 in SAS Programming
‎07-06-2020 12:53 PM
‎07-06-2020 12:53 PM
Sure.  This is my dataset; ID TRLNKID TRCD ScanDate 2102-202 T01 LDIAM 11/1/2018 2102-202 T02 SAXIS 5/4/2018 2102-202 T04 LDIAM 5/4/2018 2102-203 T01 SAXIS 5/25/2018 2102-203 T01 SAXIS 8/14/2018 2102-203 T01 SAXIS 5/5/2020 2102-203 T04 SAXIS 5/25/2018 2102-205 T01 LDIAM 6/14/2018 2102-205 T01 LDIAM 3/6/2020 2102-206 T02 SAXIS 6/28/2018 2102-206 T03 LDIAM 6/28/2018 2102-207 T02 SAXIS 6/25/2018 2102-207 T03 SAXIS 1/15/2019 2102-208 T01 LDIAM 7/3/2018 2102-208 T02 SAXIS 7/3/2018   This is what i'm expecting:  ID TRLNKID TRCD ScanDate 2102-202 T02 SAXIS 5/4/2018 2102-203 T01 SAXIS 5/25/2018 2102-203 T01 SAXIS 8/14/2018 2102-203 T01 SAXIS 5/5/2020 2102-203 T04 SAXIS 5/25/2018 2102-205 T01 LDIAM 6/14/2018 2102-205 T01 LDIAM 3/6/2020 2102-206 T02 SAXIS 6/28/2018 2102-207 T02 SAXIS 6/25/2018 2102-207 T03 SAXIS 1/15/2019 2102-208 T02 SAXIS 7/3/2018   Note: If an ID have values 'SAXIS' and 'LDIAM' i will select all those IDs with 'SAXIS'; if ID have is only 'LDIAM' then i i'll select all those IDs with 'LDIAM' and if the ID have values only 'SAXIS' i'll select all those IDs with 'SAXIS'.   ... View more

Re: List of ID with multiple conditions either or

by Calcite | Level 5 in SAS Programming
‎07-06-2020 12:30 PM
‎07-06-2020 12:30 PM
Thank you! Yes, I want list of distinct IDs that satisfy the conditions. One ID may have in multiple rows with either LDIAM or SAXIS. I gave here a small portion of data my whole data set.  ... View more

Re: List of ID with multiple conditions either or

by Calcite | Level 5 in SAS Programming
‎07-06-2020 12:27 PM
‎07-06-2020 12:27 PM
Thank you! Yes, I want list of distinct IDs that satisfy the conditions. One ID my have in multiple rows which will fulfill the conditions. I gave here a small portion of data my whole data set.  ... View more

List of ID with multiple conditions either or

by Calcite | Level 5 in SAS Programming
‎07-06-2020 11:03 AM
‎07-06-2020 11:03 AM
I want to create a sub-data set with list of all variables with the following conditions: if IDs (2102-202) are with TRCD =LDIAM or SAXIS then select all  IDs (2102-202) with SAXIS only  and if IDs (2102-205) are with TRCD =LDIAM only then select all IDs  (2102-205) where TRCD=LDIAM and if IDs (2102-203) are with TRCD=SAXIS then then select all IDs (2102-203) where TRCD=SAXIS     From the following data; ID                 TRLNKID      TRCD      ScanDate 2102-202       T01             LDIAM      11/1/2018 2102-208       T02             SAXIS        7/3/2018 2102-202      T02             SAXIS        5/4/2018 2102-202      T04             LDIAM       5/4/2018 2102-203      T01             SAXIS        5/25/2018 2102-203      T01             SAXIS        8/14/2018 2102-203      T01             SAXIS        5/5/2020 2102-203      T04             SAXIS        5/25/2018 2102-205      T01            LDIAM        6/14/2018 2102-205      T01            LDIAM        3/6/2020 2102-206      T02            SAXIS        6/28/2018 2102-206      T03           LDIAM         6/28/2018 2102-207      T02           SAXIS         6/25/2018 2102-207      T03           SAXIS         1/15/2019 2102-208      T01          LDIAM         7/3/2018 2102-208      T02          SAXIS          7/3/2018   It would be great help if anyone of you can help me. I'm new in this forum pls let me know if you need additional information.  ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎08-31-2020 07:40 PM
Likes given to
View All
Quick links