About abhinayingole

abhinayingole · ‎01-01-2024

Thanks Kurt , it worked 🙂

abhinayingole · ‎12-30-2023

Hi Kurt, Thanks for the reply. yes, you are correct with this statement....So it actually means: if there is only one observation, then subjoin = 0, otherwise we start with 1. SUBJOIN value obs. no. 9 and 5 are 1 because of this rule.... If the start date of the next AE is the end date of the previous AE record then AJOINSID remains the same. so in case of obs. no. 9. ASTDT =28FEB2023 is the end date of 5th obs. (i.e AENDT = 28FEB2023) so the SUBJOIN value will be the whatever value is from 5th obs. in this case obs. no . 5 SUBJOIN =1 so it will be same for obs. no. 9. in case of obs. no. 5. ASTDT =17JAN2023 is the end date of 2nd obs. (i.e AENDT = 17JAN2023) so the SUBJOIN value will be the whatever value is from 2nd obs. in this case obs. no . 2 SUBJOIN =1 so it will be same for obs. no. 5.

abhinayingole · ‎12-30-2023

No Kurt, as obs. no. 2 to 9 are the overlapping AEs with AE = vomit and JOIN = 1, so they need subgrouping, which is why they need to start with 1. Please let me know if this information helps.

abhinayingole · ‎12-29-2023

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 Adverse Event. we need to created SUBJOIN variable for every USUBJID AE JOIN group. if the AENDT date of the prior AE is not the ASTDT date of the next AE, then we need to create SUBJOIN as +1. If the start date of the next AE is the end date of the previous AE record then AJOINSID remains the same. (that is why we have SUBJOIN = 1 for obs. no. 5, as the 17JAN2023 is the end date for obs. no. 2) first and last obs. have value 0 because they don't have any overlapping event. could you please help me program this? I am also attaching the datalines for this dataset for reference. data test; informat astdt date9. aendt date9.; input @1 usubjid $3. @5 astdt date9. @15 aendt date9. @25 ae $5. @31 join 1. ; format astdt aendt date9.; datalines; 128 03JAN2023 10JAN2023 cough 1 128 27DEC2022 17JAN2023 vomit 1 128 03JAN2023 17JAN2023 vomit 1 128 10JAN2023 24JAN2023 vomit 1 128 17JAN2023 28FEB2023 vomit 1 128 31JAN2023 14FEB2023 vomit 1 128 31JAN2023 14FEB2023 vomit 1 128 21FEB2023 28FEB2023 vomit 1 128 28FEB2023 21MAR2023 vomit 1 128 11APR2023 . vomit 2 ; run;

abhinayingole · ‎12-13-2023

Hi Kurt, Thanks for the solution. it worked. However, I have one more scenario. with your derivation, we got JOIN value 2 for 7th observation. we need the JOIN value as 1 for this observation. as we don't know the end date of pervious observation (or missing end date for any of the previous records), so we consider this as cutaneous overlap AE. The last observation JOIN value 2 is correct, though it has missing end date, but no other previous record has missing end dates. do you have any solution for this. I am pasting datalines for this test dataset below for refrence. data test1; informat astdt date9. aendt date9.; input @1 usubjid $3. @5 astdt date9. @15 aendt date9. @25 ae $15.; format astdt aendt date9.; datalines; 101 10JUN2016 06JUL2016 vomit 101 06JUL2016 08JUL2016 vomit 101 06JUL2016 08JUL2016 vomit 101 08JUL2016 22JUL2016 vomit 101 22JUL2016 28JUL2016 vomit 101 28JUL2016 . vomit 101 16SEP2016 . vomit 202 27DEC2022 17JAN2023 vomit 202 03JAN2023 17JAN2023 vomit 202 10JAN2023 24JAN2023 vomit 202 17JAN2023 28FEB2023 vomit 202 31JAN2023 14FEB2023 vomit 202 31JAN2023 14FEB2023 vomit 202 21FEB2023 28FEB2023 vomit 202 28FEB2023 21MAR2023 vomit 202 11APR2023 . vomit ; run;

abhinayingole · ‎12-12-2023

Hi Kurt, Yes , you are right. apology. there must be some mistake at my end, but it is working fine now.

abhinayingole · ‎12-12-2023

Hi , as requested , I am pasting code at </> , please let me know if it is still invalid data test; informat astdt date9. aendt date9.; input @1 usubjid $3. @5 astdt date9. @15 aendt date9. @25 ae $15.; format astdt aendt date9.; datalines; 301 21FEB2020 06MAR2020 Anemia 301 06MAR2020 13MAR2020 Anemia 301 06MAR2020 13MAR2020 Anemia 301 09APR2020 21MAY2020 Anemia 301 09APR2020 03JUN2020 Anemia 301 21MAY2020 01JUL2020 Anemia 301 03JUN2020 01JUL2020 Anemia 301 01JUL2020 28JUL2020 Anemia 301 01JUL2020 18NOV2020 Anemia 301 28JUL2020 26AUG2020 Anemia 301 26AUG2020 21OCT2020 Anemia 301 18NOV2020 15DEC2020 Anemia 301 18NOV2020 15DEC2020 Anemia 301 15DEC2020 . Anemia run;

abhinayingole · ‎12-12-2023

Hi Josvander, I don't have code for this, however I wanted JOIN variable in below manner. I hope you wanted code for below dataset , right ? Please correct me if I mistaken.

abhinayingole · ‎12-12-2023

With this derivation, join value is 3 for observation no. 4 , we want it as 2, as the 2nd set of AE overlapping starts from observation no. 4.

abhinayingole · ‎12-12-2023

Thanks for the reply, but lag function will not work here as observation no. 12 still consider as overlapping AE , as observation no. 9 is 18NOV2020

abhinayingole · ‎12-12-2023

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. For eg. if you see 4th observation start date is 9APR2020, which did not fall under any of the previous AE start and end date, that is why join variable value is 2 (2nd set of observation with continuous AE) How to do it programmatically. I have also paste the datalines for the test dataset. data test; informat astdt date9. aendt date9.; input @1 usubjid $3. @5 astdt date9. @15 aendt date9. @25 ae $15.; format astdt aendt date9.; datalines; 301 21FEB2020 06MAR2020 Anemia 301 06MAR2020 13MAR2020 Anemia 301 06MAR2020 13MAR2020 Anemia 301 09APR2020 21MAY2020 Anemia 301 09APR2020 03JUN2020 Anemia 301 21MAY2020 01JUL2020 Anemia 301 03JUN2020 01JUL2020 Anemia 301 01JUL2020 28JUL2020 Anemia 301 01JUL2020 18NOV2020 Anemia 301 28JUL2020 26AUG2020 Anemia 301 26AUG2020 21OCT2020 Anemia 301 18NOV2020 15DEC2020 Anemia 301 18NOV2020 15DEC2020 Anemia 301 15DEC2020 . Anemia run; data test; informat astdt date9. aendt date9.; input @1 usubjid $3. @5 astdt date9. @15 aendt date9. @25 ae $15.; format astdt aendt date9.; datalines; 301 21FEB2020 06MAR2020 Anemia 301 06MAR2020 13MAR2020 Anemia 301 06MAR2020 13MAR2020 Anemia 301 09APR2020 21MAY2020 Anemia 301 09APR2020 03JUN2020 Anemia 301 21MAY2020 01JUL2020 Anemia 301 03JUN2020 01JUL2020 Anemia 301 01JUL2020 28JUL2020 Anemia 301 01JUL2020 18NOV2020 Anemia 301 28JUL2020 26AUG2020 Anemia 301 26AUG2020 21OCT2020 Anemia 301 18NOV2020 15DEC2020 Anemia 301 18NOV2020 15DEC2020 Anemia 301 15DEC2020 . Anemia run;

abhinayingole · ‎10-31-2023

%macro chk (result = ); data one; val = "&result."; run; %mend chk; %chk (result = %str(Intensity (%)) ); I need to print result for VAL variable as "Intensity (%)" ,e.g VAL = "Intensity(%)" , but not able to do it with above code. any suggestion please.

abhinayingole · ‎12-01-2022

Hi there, data want; set have; by id; if first.id then rank =1; else rank+1; run; For the above code, I wanted to get this RANK variable by using proc sql. is there any method ? Thanks, Abhinay

abhinayingole · ‎03-31-2022

abhinayingole · ‎03-10-2022

i have 4 rtf file (already generated), i wanted to combine these 4 rtf in one rtf or pdf. do you have any sample code for this ?

Online Status	Offline
Date Last Visited	‎07-04-2025 02:11 AM

Re: I need to create AJOINID variable as given in XLSx file

Re: I need to create AJOINID variable as given in XLSx file

Re: I need to create AJOINID variable as given in XLSx file

Re: I need to create AJOINID variable as given in XLSx file

Re: I need to create AJOINID variable as given in XLSx file

Re: I need to create AJOINID variable as given in XLSx file

Re: I need to create AJOINID variable as given in XLSx file

I need to create AJOINID variable as given in XLSx file

Re: Need to create JOIN variable for OVERLAPPING AEs

Re: Need to create JOIN variable for OVERLAPPING AEs

Re: Syntax ERROR while passing macro value

Re: AE Programming query

Proc report column header indentation

can I ask clinical domain question here ?

Re: how to set all similar variables value missing

Re: AE overlap programming query

Re: AE overlap programming query

Re: AE overlap programming query

AE overlap programming query

Re: Overlapping AE Programming

Re: Overlapping AE Programming

Re: Overlapping AE Programming

Re: Overlapping AE Programming

Re: Overlapping AE Programming

Re: Overlapping AE Programming

Overlapping AE Programming

macro call result error with % sign

Ranking in proc sql

can I ask clinical domain question here ?

Re: multiple rtfs in one rtf file