About lulu3

lulu3 · ‎02-10-2023

Hi expert, I wanted split my text into several lines. For example: data want; input x $ y $ z $; datalines; aa bb cc ; run; data want; set want; want=strip(x)||'/'||strip(y)||'/'||strip(z); run; it comes out : aa/bb/cc but I want: aa/ bb/ cc line 2 has 2 leading space compared to line 1, line 3 has 4 leading space compared to line1. Thanks a lot.

lulu3 · ‎02-03-2021

Thank you for your solution!

lulu3 · ‎02-03-2021

Sorry for the confusion. Please use the earliest drug date as the indexdate for each subject.

lulu3 · ‎02-03-2021

Yes, I wanted to compare with the values of indexdate for each subject.

lulu3 · ‎02-03-2021

Hi Expert, I wanted to exclude patients who have more than one claim of the drug during the 90 dyas prior to or on the index date. For example: data have; input id $ drug $ indexdate mmddyy10.; format indexdate mmddyy10.; datalines; 1 A 10/07/2016 1 B 06/21/2016 2 C 07/27/2017 2 A 09/09/2015 3 A 03/21/2016 3 B 03/21/2016 4 C 07/24/2016 4 B 07/30/2016 5 A 02/23/2016 5 C 05/12/2016 ; run; Data I want: 1 A 10/07/2016 1 B 06/21/2016 2 C 07/27/2017 2 A 09/09/2015 I wanted to exclude id 3 4 5 because they had two drug claims within 90 days. Thanks!

lulu3 · ‎01-12-2021

Hi expert, I wanted to count the 'disease' variable but need to avoid misisng 'disease' and duplicate dates. data have; input id $ date mmddyy10. disease @@; format date mmddyy10.; datalines; 1 01/08/2016 1 1 01/08/2016 1 1 01/10/2016 . 1 01/11/2016 1 2 01/13/2016 1 2 04/04/2016 1 2 06/05/2016 1 3 12/16/2016 . 3 11/17/2016 . 4 05/18/2016 1 4 05/18/2016 1 4 05/18/2016 1 4 03/16/2016 . 5 04/10/2016 . 5 04/16/2016 1 ; run; proc sort data=have; by id date disease; run; output I need: id disease 1 2 2 3 4 1 5 1 I tried data step with first.id but it doesn't work. Any advice would be greatly appreciated! Thank you!

lulu3 · ‎09-14-2020

Hi expert, I had several datasets. Some datasets only contains thru_dt, and some datasets contains both from_dt and thru_dt. I wanted to select a). if the dataset only contains thru_dt, then select '01JAN2015'd <=thru_dt<='05JAN2015'd, b). if the dataset contains both from_dt and thru_dt, then select '01JAN2015'd <=from_dt<='05JAN2015'd. For example: data one; input id $ thru_dt:mmddyy10.; format thru_dt mmddyy10.; datalines; 1 01/01/2015 2 01/02/2015 3 01/03/2015 4 01/04/2015 5 01/05/2015 6 01/06/2015 7 01/07/2015 ; run; data two; input id $ from_dt:mmddyy10. thru_dt:mmddyy10.; format from_dt thru_dt mmddyy10.; datalines; 1 01/01/2015 01/02/2015 2 01/02/2015 01/03/2015 3 01/03/2015 01/03/2015 4 01/04/2015 01/04/2015 5 01/05/2015 01/05/2015 6 01/06/2015 01/06/2015 7 01/07/2015 01/07/2015 ; run; I tried the following codes, but it said ERROR: Variable from_dt is not on file WORK.ONE. data want; set one two; where '01JAN2015'd <=from_dt<='05JAN2015'd | '01JAN2015'd <=thru_dt<='05JAN2015'd; run; Any suggestions would be greatly appreciated!

lulu3 · ‎08-27-2020

Hi experts, I have a dataset below and I would like to select subject who had ≥2 claims on separate dates for an asthma diagnosis, and for the final dataset, keep the earliest data as the indexdate. I had run my codes below, and it seems my codes were redundant. I was wondering if someone could help me to improve my codes? Thank you in advance! data have; input id $ indexdate : mmddyy10. asthma $; format indexdate mmddyy10.; datalines; 201 04/10/2013 1 201 04/11/2013 1 201 04/12/2013 1 202 02/21/2013 1 202 03/07/2013 1 202 03/07/2013 1 202 03/08/2013 1 202 03/09/2013 1 202 03/20/2013 1 203 02/14/2013 1 203 02/15/2013 1 204 01/23/2013 1 204 01/23/2013 1 204 01/23/2013 1 204 01/23/2013 1 204 01/23/2013 1 204 01/23/2013 1 205 03/18/2013 1 206 05/01/2013 1 206 05/01/2013 1 ; run; proc sort data=have out=have_nodup nodupkey; by id indexdate; run; proc sort data=have_nodup nouniquekeys out=have_a; by id; run; proc sort data=have_a nodupkey out=want; by id; run;

lulu3 · ‎07-31-2020

Yes, it is SSN. I have one dateset the SSN was original stored as numeric number (etc. 123-45-6789). I want to transfer the numeric SSN to character SSN. Do you have any suggestions? Thanks.

lulu3 · ‎07-31-2020

Hi Expert, I would like to convert character number to numeric number with dash variables. data have; input id $ Character $11. ; datalines; 1 123-45-7890 2 234-65-3960 3 351-47-9012 ; run; I tried the following code, but the numeric variable was still character. data want; set have; Numeric=input(Character, $11.); run; One more question, I want to know how to conver character from or to numeric number if the variable include dash (-). Thank you for your help!

lulu3 · ‎07-29-2020

Sure, please. Thanks a lot for your help.

lulu3 · ‎07-29-2020

Hi Everyone, I would like to distinguish the switch and nonswitch patients. Drug switching cohorts: patients in naive drug will be followed until the first swtiching to the second drug other than index drug, the switching date will be designated as the index date. Drug Nonswitich cohorts: the first drug date will be designated as the index date. For example: data have; input id indexdate : ddmmyy10. drug $; format indexdate ddmmyy10.; datalines;; 201 18/07/2013 A 201 27/12/2013 A 201 13/06/2013 A 201 19/08/2013 B 201 01/05/2014 B 201 14/10/2013 B 201 20/02/2014 B 201 27/03/2014 B 201 16/09/2013 B 201 18/12/2013 B 202 16/04/2014 A 202 16/01/2014 C 202 02/10/2013 C 202 15/07/2013 B 202 13/05/2013 B 202 11/03/2014 B 202 11/11/2013 B 202 23/09/2013 B 202 18/05/2014 A 202 16/08/2014 C 203 08/09/2015 A 203 15/07/2014 A 203 18/03/2013 A 203 11/03/2014 A 203 11/11/2013 A 203 27/11/2012 A ; run; Want output: Id Indexdate drug switch 201 19/08/2013 B 1 202 02/10/2013 C 1 203 27/11/2012 A 0 swtich: 1=switch 0=nonswitch I accpeted the answer from @mkeintz proc sort out=have2; by id indexdate;run; data want (drop=_:); do _ndrug=1 by 1 until (last.id); do until (last.drug); set have2; by id drug notsorted; if _ndrug=2 and first.drug then do; switch=1; output; end; end; end; switch=0; if _ndrug=1 then output; run; The output is: Id Indexdate drug switch 201 19/08/2013 B 1 202 02/10/2013 C 1 203 08/09/2015 A 0 The subject 203 uses the last drug date as the indexdate. But I want the first drug date as the index date (27/11/2012). Many thanks!

lulu3 · ‎07-29-2020

Hi @mkeintz , Your answer was super helpful. But I just found that when I select the subject 203 (nonswitch subject), the last drug date became the indexdate. I would like to choose the first drug date as the indexdate. (27/11/2012 not 08/09/2015). I was wondering if you have any suggestions for this? Thank you very much!

lulu3 · ‎07-28-2020

Thank you very much! It helps me a lot.

lulu3 · ‎07-28-2020

Hi Everyone, I would like to distinguish the switch and nonswitch patients. Drug switching cohorts: patients in naive drug will be followed until the first swtiching to the second drug other than index drug, the switching date will be designated as the index date. For example: data have; input id indexdate : ddmmyy10. drug $; format indexdate ddmmyy10.; datalines;; 201 18/07/2013 A 201 27/12/2013 A 201 13/06/2013 A 201 19/08/2013 B 201 01/05/2014 B 201 14/10/2013 B 201 20/02/2014 B 201 27/03/2014 B 201 16/09/2013 B 201 18/12/2013 B 202 16/04/2014 A 202 16/01/2014 C 202 02/10/2013 C 202 15/07/2013 B 202 13/05/2013 B 202 11/03/2014 B 202 11/11/2013 B 202 23/09/2013 B 202 18/05/2014 A 202 16/08/2014 C 203 08/09/2015 A 203 15/07/2014 A 203 18/03/2013 A 203 11/03/2014 A 203 11/11/2013 A 203 27/11/2012 A ; run; Want output: Id Indexdate drug switch 201 19/08/2013 B 1 202 02/10/2013 C 1 203 27/11/2012 A 0 swtich: 1=switch 0=nonswitch proc sort data=have out=have1; by id indexdate; run; Thanks in advance!!!

Online Status	Offline
Date Last Visited	‎02-24-2023 09:28 PM

how to split text in different lines

Re: exclude patient who had >=1 claim for drug during the 90 days prio...

Re: exclude patient who had >=1 claim for drug during the 90 days prio...

Re: exclude patient who had >=1 claim for drug during the 90 days prio...

exclude patient who had >=1 claim for drug during the 90 days prior to...

Count obervations by id

select varibles from two dataset

select subject who had ≥2 claims on separate dates for an asthma diagn...

Re: Convert Charater number to Numeric number with dash

Convert Charater number to Numeric number with dash

Re: Count obervations by id

Re: Count obervations by id

Re: Count obervations by id

Re: Count obervations by id

Re: select matched data

how to split text in different lines

Re: exclude patient who had >=1 claim for drug during the 90 days prio...

Re: exclude patient who had >=1 claim for drug during the 90 days prio...

Re: exclude patient who had >=1 claim for drug during the 90 days prio...

exclude patient who had >=1 claim for drug during the 90 days prior to...

Count obervations by id

select varibles from two dataset

select subject who had ≥2 claims on separate dates for an asthma diagn...

Re: Convert Charater number to Numeric number with dash

Convert Charater number to Numeric number with dash

Re: switch and nonswitch subject

switch and nonswitch subject

Re: Select switch and nonswtich subject

Re: Select switch and nonswtich subject

Select switch and nonswtich subject