About CynthiaWei

CynthiaWei · ‎05-21-2025

Hi Dear SAS Pros, I have 2 or more datasets as follows: data db1; input id V1 ; datalines; 1 0.5 1 0.6 1 0.7 1 0.8 2 0.7 2 0.5 3 0.4 3 0.8 4 0.6 ; data db2; input id V2 ; datalines; 1 2.5 1 2.6 2 2.7 2 2.5 2 2.6 4 2.6 4 2.1 ; And what I want for output is as follows: id V1 V2 1 0.5 2.5 1 0.6 2.6 1 0.7 . 1 0.8 . 2 0.7 2.7 2 0.5 2.5 2 . 2.6 3 0.4 . 3 0.8 . 4 0.6 2.6 4 . 2.1 Thank you so much for any advice or help. Best, C

CynthiaWei · ‎07-01-2024

Hi, Thank you so much for your help! The desired outcomes are the person-time was accrued within its own period. Observation 1 developed outcome in T5, which is in pre-stage, then the expected PT_pre=sum(of T1-T9)=3. Observation 3 developed outcome in both pre- and post-stages, so the expected PT_pre=sum(of T1-T9)=5 and PT_post=sum(of T10-T20)=2. It looks like only the calculated results for observation 3 are not correct. Could you please advice how should I modify the code to cooperate my request? Again, I really appreciate it! ID Outcome Outcome_timepoint PT_pre PT_Post T1 T2 T3 T4 T5 T6 T7 T8 T9 T10 T11 T12 T13 T14 T15 T16 T17 T18 T19 T20 XXXXX1 1 T5 3 0 0 1 1 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 XXXXX2 0 NA 5 5 0 1 1 0 1 1 1 0 0 0 0 1 1 0 1 1 1 0 0 0 XXXXX3 1 T13 5 2 0 1 1 0 1 1 1 0 0 0 0 1 1 0 0 0 0 0 0 0 XXXXX4 0 NA 5 5 0 1 1 0 1 1 1 0 0 0 0 1 1 0 1 1 1 0 0 0

CynthiaWei · ‎07-01-2024

Hi SAS Pros, I'm trying to create2 variables (as showed in the file - PT_pre and PT_post) to present the person-time patients have accrued in each stage, with the pre- and post-stage splits between T9 and T10. Pre-stage: The person-time for patients with outcome=1 in pre-stage should sum up the values from T1 until Tn, where Tn is determined by the value of outcome_timepoint (T5 for ID=XXXXX1). The person-time for patients with outcome=0 in pre-stage should sum up the values from T1 until T9. Post-stage: The person-time for patients with outcome=1 in post-stage should sum up the values from T10 until Tn, where Tn is determined by the value of outcome_timepoint (T13 for ID=XXXXX3). The person-time for patients with outcome=0 in post-stage should sum up the values from T10 until T20. For example, ID=XXXXX1 is outcome=1 at time point T5, so the person-time he contributed during pre-stage is PT_pre=sum(of T1-T5) (only T1=0, T2=1, T3=1, T4=0, and T5=1). Not every single time point this patient had contribution to person-time, so T1-T20 had both 0 or 1 value. I appreciate with any help! Regards, C

CynthiaWei · ‎08-15-2023

Thank you so much for the code. Just out of curiosity, what do those statements mean within the PRX function?

CynthiaWei · ‎08-15-2023

Thank you for asking this. What are the syntax if a. I only want the first text and b. any text that meets the target text. Thanks a lot!

CynthiaWei · ‎08-15-2023

Hi SAS Pro, I'm having a question that I want to extract "14 days" or "10 days" and any "digit days" texts from sentences. The tricky thing is that the position of the substring could be various. data have; input X $80.; datalines; I spent 14 days in Boston. I love it. Exercise twice a day for 10 days until May. I left there. It was about 7 days ago. ; run; What I want is to have 1. a new character variable Y including 14 days, 10 days, and 7 days. 2. a numeric variable Z with the values of 14, 10, and 7. Any help would be highly appreciated!! Best regards, C

CynthiaWei · ‎10-27-2022

To better clarify, I just don't want to manually type in the texts from F01-F19 and F30-F99 individually in the array element section. 🙂

CynthiaWei · ‎10-27-2022

Hi, Thank you so much for your code. Does the statement '/F[013-9]\d/' can include all the texts from F01-F19 and F30-F99? I know the programming code for my project is not difficult. I just don't want to manually type in the texts from F01-F19 and F30-F99 individually in the array element section. Thank you!

CynthiaWei · ‎10-27-2022

Hi, Thank you so much for the code! So, F01-F99 except F20-F29 are all values/texts not variable. I put them in a single quote to indicate they are array elements. If any of the 30 variables D01-D30 has any of the texts of F01-F19 or F30-F99, then the new variable Flag=1, otherwise Flag=. From you above code, how can I decide the range, which are the variables D01-D30, that I want to look at and program. Thank you!

CynthiaWei · ‎10-27-2022

Hi LinusH, You are right! F01-F99 except F20-F29 are all values/texts not variable. In another word, if any of the 30 variables D01-D30 has any of the texts of F01-F19 or F30-F99, then the new variable Flag=1, otherwise Flag=. Thank you! C

CynthiaWei · ‎10-27-2022

Hi SAS Pro, I have a project that needs to use Array to create a new variable Flag as long as D01 to D30 has any of F01, F02, F03, F04...F98, or F99 (F01-F99 except F20-F29, 89 different values). Is there an easy way to put F01-F19 and F30-F99 all at once in a single array statement? data want; set have; array D(30) D01-D30; do i=1 to 30; if D(i) in ('F01', 'F02', 'F03', 'F04', 'F05'..., 'F19', 'F30', 'F31', ...'F99') then Flag=1; end; drop i; run; I appreciate any help with this code! Best regards, C

CynthiaWei · ‎07-25-2021

Thank you JimBarbour all the same for checking in with me! I am sorry for the confusion. As I replied to Patrick, both my questions are solved. Best regards, C

CynthiaWei · ‎07-25-2021

Hi Patrick, Thank you so much for your codes! Actually, I can apply your following codes to my 2nd question. It is still about checking whether same ID corresponds to multiple dates. It is very helpful! Best regards, C

CynthiaWei · ‎07-24-2021

SAS Pros, I am having a question that I want to check whether the two variables are corresponding to each other, which means if the value of 100 in variable1 corresponds to 10000 in variable 2, then that 100 will not correspond to other values in variable 2. The tricky thing is that when sorting variable 1 in an either ascending or descending way, variable 2 will be disorderly and may not continuous. Another questions is that I may have two or more observations under each ID, and each observation may have a different date. I want to whether the dates among the two or more observations under each ID are the same? Thank you for any help! Best regards, C

CynthiaWei · ‎07-18-2021

Hi SAS Pro, I have a dataset (Have1) including a series of relevant variables v1, v2, v3, and v4, with each variable represents codes (character variable). I also have a separate dataset (Have2) containing a certain list of codes. I would like to create a new variable called flag. Flag will have a value of 1 if v1-v4 in Have1 contains any codes listed in Have2. It would be efficient to employ array since there are a series relevant variables v1 to v4. Also, because my really data for Have2 has thousands codes, it is impossible to type every code in the SAS syntax unless to use a hash table. However, the tricky part is how to incorporate hash table into array function? I would really appreciate any help! Best regards, C data have1; length v1-v4 $7.; input v1 $ v2 $ v3 $ v4 $; datalines; a1 b2 c234 d987 e45 h76 k93 a1 d9087 b4 m7908 v9090 s6987 k2983 o87 f338 b2 f338 g6 x3 Y3 h76 009 m1a m1a a1 2983 f02 2983 k8 y4 w348 k93 e5 w77 h5 h76 . b2 . . . k93 . ; run; data have2; length v $7.; input v $; datalines; b2 h76 k93 v9090 2983 ; run;

Online Status	Offline
Date Last Visited	‎05-24-2025 07:19 AM

How to combine datasets that have different # of observation within ea...

Re: How to set calculation equation based on the value of a variable? ...

How to set calculation equation based on the value of a variable? Usin...

Re: How to extract a substring and generate a new variable with values...

Re: How to extract a substring and generate a new variable with values...

How to extract a substring and generate a new variable with values of ...

Re: How to put a hundred values in a single Array statement

Re: How to put a hundred values in a single Array statement

Re: How to put a hundred values in a single Array statement

Re: How to put a hundred values in a single Array statement

Re: How to create multiple dummy variables from observations with many...

Re: How to generate a unique variable to indicate the first office vis...

How to combine datasets that have different # of observation within ea...

Re: How to create a variable to represent the months of overlapping dr...

Re: How to create a variable to represent the months of overlapping dr...

Re: How to create a variable to represent the months of overlapping dr...

How to combine datasets that have different # of observation within ea...

Re: How to set calculation equation based on the value of a variable? ...

How to set calculation equation based on the value of a variable? Usin...

Re: How to extract a substring and generate a new variable with values...

Re: How to extract a substring and generate a new variable with values...

How to extract a substring and generate a new variable with values of ...

Re: How to put a hundred values in a single Array statement

Re: How to put a hundred values in a single Array statement

Re: How to put a hundred values in a single Array statement

Re: How to put a hundred values in a single Array statement

How to put a hundred values in a single Array statement

Re: How to check whether two variables are corresponding to each other

Re: How to check whether two variables are corresponding to each other

How to check whether two variables are corresponding to each other

How to incorporate hash table into array