About Aljosa

Aljosa · ‎05-19-2020

Hi all, I have a column named ID filled out like this (with blancs): data have; input ID $; infile datalines missover; datalines; 1 2 3 4 5 ; I would like to fill out all blancs with the last value populated, so the column I want would look like this: data want; input ID $; infile datalines missover; datalines; 1 2 3 3 3 4 5 5 ; Thank you for your help. Kind regards

Aljosa · ‎03-10-2020

OMG this works!!! Its amazing ;)))) You are my life saver!!! Thank you million times dear Kurt!!! Have a wonderful day++++++++

Aljosa · ‎03-06-2020

Hi, when I run the table "have" I get this (so, I have a problem somewhere): If however I run your main program directly on my original table with all patients, I get this: (Note that in your main program I added only "term2" in instruction keep at the end) So, I see only 4 rows for patient number 1, and no hyperuricemia there... In the program below I put all events for the patient number 1: data have; infile cards dlm='09'x dsd truncover; input patient :$10. visitdt :ddmmyy10. INTENSITY :$20. (date_onset date_end) (:ddmmyy10.) term2 :$30.; format visitdt date_onset date_end ddmmyy10.; datalines; 1 31.12.2015 Grade 1 (Mild) . . lowering hemoglobin 1 31.12.2015 Grade 1 (Mild) . . hypokalemia 1 31.12.2015 Grade 1 (Mild) . . increase blood glucose 1 31.12.2015 Grade 4 . . hyperuricemia 1 18.01.2016 Grade 1 (Mild) . . lowering hemoglobin 1 18.01.2016 Grade 3 (Severe) . . hyperuricemia 1 18.01.2016 Grade 1 (Mild) . . increase AST 1 18.01.2016 Grade 2 (Moderate) . . hypokalemia 1 22.01.2016 . . lengthen about qtcf 1 22.01.2016 Grade 1 (Mild) . . lowering blood calcium 1 15.02.2016 Grade 3 (Severe) . . hyperuricemia 1 15.02.2016 Grade 2 (Moderate) . . athralgia 1 18.02.2016 Grade 1 (Mild) . . hyperuricemia 1 18.02.2016 Grade 2 (Moderate) . . hypokalemia 1 18.02.2016 Grade 1 (Mild) . . lowering blood calcium 1 23.02.2016 Grade 3 (Severe) . . hyperuricemia 1 23.02.2016 Grade 1 (Mild) . . increase AST 1 23.02.2016 Grade 1 (Mild) . . lowering hemoglobin 1 23.03.2016 Grade 1 (Mild) . . hyperglycemia 1 23.03.2016 . . lengthen about qtcf 1 23.03.2016 Grade 3 (Severe) . . hyperuricemia 1 23.03.2016 Grade 3 (Severe) . . hypokalemia 1 23.03.2016 Grade 1 (Mild) . . increase AST 1 23.03.2016 Grade 3 (Severe) . . lowering hemoglobin 1 21.04.2016 Grade 2 (Moderate) . . hyperuricemia 1 21.04.2016 Grade 3 (Severe) . . lowering hemoglobin 1 21.04.2016 Grade 1 (Mild) . . hypokalemia 1 19.05.2016 Grade 3 (Severe) . . hyperuricemia 1 19.05.2016 Grade 2 (Moderate) . . lowering hemoglobin 1 16.06.2016 Grade 2 (Moderate) . . lowering hemoglobin 1 16.06.2016 Grade 1 (Mild) . . increase blood glucose 1 16.06.2016 Grade 1 (Mild) . . increase AST 1 16.06.2016 Grade 4 . . hyperuricemia 1 19.07.2016 Grade 3 (Severe) . . hyperuricemia 1 19.07.2016 Grade 2 (Moderate) . . hypokalemia 1 19.07.2016 Grade 2 (Moderate) . . lowering hemoglobin 1 19.07.2016 Grade 1 (Mild) . . ALT increase 1 19.07.2016 Grade 2 (Moderate) . . increase blood glucose 1 19.07.2016 Grade 1 (Mild) . . increase AST 1 16.08.2016 Grade 1 (Mild) . . hypokalemia 1 16.08.2016 Grade 1 (Mild) . . hyperuricemia 1 16.08.2016 Grade 2 (Moderate) . . lowering hemoglobin 1 16.08.2016 . . lengthen about qtcf 1 03.10.2016 . . lengthen about qtcf 1 02.11.2016 Grade 3 (Severe) . . lowering hemoglobin 1 03.11.2016 . . lengthen about qtcf 1 22.11.2016 Grade 1 (Mild) . . hypokalemia 1 22.11.2016 Grade 3 (Severe) . . hyperuricemia 1 22.11.2016 Grade 1 (Mild) . . lowering hemoglobin 1 01.12.2016 Grade 1 (Mild) . . lowering blood calcium 1 01.12.2016 Grade 1 (Mild) . . lowering hemoglobin 1 01.12.2016 Grade 3 (Severe) . . hyperuricemia 1 22.12.2016 Grade 1 (Mild) . . brown skin 1 22.12.2016 Grade 1 (Mild) . . increase blood glucose 1 22.12.2016 Grade 2 (Moderate) . . lowering hemoglobin 1 22.12.2016 Grade 1 (Mild) . . increase AST 1 22.12.2016 Grade 3 (Severe) . . hyperuricemia 1 19.01.2017 Grade 3 (Severe) . . hyperuricemia 1 19.01.2017 Grade 2 (Moderate) . . lowering hemoglobin 1 19.01.2017 Grade 1 (Mild) . . increase blood glucose 1 19.01.2017 Grade 2 (Moderate) . . hypokalemia 1 22.02.2017 Grade 2 (Moderate) . . hypokalemia 1 22.02.2017 Grade 1 (Mild) . . ALT increase 1 22.02.2017 Grade 1 (Mild) . . lowering hemoglobin 1 22.02.2017 Grade 2 (Moderate) . . increase blood glucose 1 22.02.2017 Grade 2 (Moderate) . . increase AST 1 20.04.2017 . . lengthen about qtcf 1 23.05.2017 . . lengthen about qtcf 1 23.05.2017 Grade 2 (Moderate) . . increase blood glucose 1 23.05.2017 Grade 3 (Severe) . . hepatitis 1 23.05.2017 Grade 1 (Mild) . . hyperuricemia 1 23.05.2017 Grade 2 (Moderate) . . hypokalemia 1 22.06.2017 . . lengthen about qtcf 1 22.08.2017 Grade 2 (Moderate) . . hypokalemia ; Using this dataset above, I would like in my final table my rows start like this: In this final table above I describe only 3 events how it should look like. The variable VISITDT is populating DATE_ONSET and DATE_END, and when there is adverse event (term2) interruption, it creates another row for the event. and so on... Thank you. Kind regards. Aljosa

Aljosa · ‎03-06-2020

Hello Kurt, It doesnt work, as I get the table without adverse events. I would need a table summarizing, per patient, each adverse event with its start and end date, taking into account interruptions (example for hyperuricemia, the event was interrupted on 22.jan.2016). Kind regards.

Aljosa · ‎03-05-2020

data have; infile cards expandtabs truncover; input patient $100. visitdt (:ddmmyy10.) INTENSITY $100. (date_onset date_end) (:ddmmyy10.) term2 $100.; format visitdt date_onset date_end ddmmyy10.; datalines; 1 31.12.2015 Grade 1 (Mild) . . lowering hemoglobin 1 31.12.2015 Grade 1 (Mild) . . increase blood glucose 1 31.12.2015 Grade 4 . . hyperuricemia 1 31.12.2015 Grade 1 (Mild) . . hypokalemia 1 18.01.2016 Grade 1 (Mild) . . lowering hemoglobin 1 18.01.2016 Grade 1 (Mild) . . increase AST 1 18.01.2016 Grade 3 (Severe) . . hyperuricemia 1 18.01.2016 Grade 2 (Moderate) . . hypokalemia 1 22.01.2016 . . lengthen about qtcf 1 22.01.2016 Grade 1 (Mild) . . lowering blood calcium 1 15.02.2016 Grade 2 (Moderate) . . athralgia 1 15.02.2016 Grade 3 (Severe) . . hyperuricemia 1 18.02.2016 Grade 1 (Mild) . . hyperuricemia 1 18.02.2016 Grade 1 (Mild) . . lowering blood calcium 1 18.02.2016 Grade 2 (Moderate) . . hypokalemia 1 23.02.2016 Grade 1 (Mild) . . lowering hemoglobin 1 23.02.2016 Grade 1 (Mild) . . increase AST 1 23.02.2016 Grade 3 (Severe) . . hyperuricemia 1 23.03.2016 Grade 3 (Severe) . . lowering hemoglobin 1 23.03.2016 Grade 1 (Mild) . . increase AST 1 23.03.2016 . . lengthen about qtcf 1 23.03.2016 Grade 3 (Severe) . . hyperuricemia 1 23.03.2016 Grade 1 (Mild) . . hyperglycemia run; Like this?

Aljosa · ‎03-05-2020

1 31DEC2015 Grade 1 (Mild) . . lowering hemoglobin 1 31DEC2015 Grade 1 (Mild) . . increase blood glucose 1 31DEC2015 Grade 4 . . hyperuricemia 1 31DEC2015 Grade 1 (Mild) . . hypokalemia 1 18.01.2016 Grade 1 (Mild) . . lowering hemoglobin 1 18.01.2016 Grade 1 (Mild) . . increase AST 1 18.01.2016 Grade 3 (Severe) . . hyperuricemia 1 18.01.2016 Grade 2 (Moderate) . . hypokalemia 1 22.01.2016 . . lengthen about qtcf 1 22.01.2016 Grade 1 (Mild) . . lowering blood calcium 1 15FEB2016 Grade 2 (Moderate) . . athralgia 1 15FEB2016 Grade 3 (Severe) . . hyperuricemia 1 18FEB2016 Grade 1 (Mild) . . hyperuricemia 1 18FEB2016 Grade 1 (Mild) . . lowering blood calcium 1 18FEB2016 Grade 2 (Moderate) . . hypokalemia 1 23FEB2016 Grade 1 (Mild) . . lowering hemoglobin 1 23FEB2016 Grade 1 (Mild) . . increase AST 1 23FEB2016 Grade 3 (Severe) . . hyperuricemia 1 23.03.2016 Grade 3 (Severe) . . lowering hemoglobin 1 23.03.2016 Grade 1 (Mild) . . increase AST 1 23.03.2016 . . lengthen about qtcf 1 23.03.2016 Grade 3 (Severe) . . hyperuricemia 1 23.03.2016 Grade 1 (Mild) . . hyperglycemia Like this? Here you have dates and blanks... I used "insert SAS code" tool Regards

Aljosa · ‎03-05-2020

How to do it? I copy my spreadsheet here in text? It doesnt work. I dont remember how I did it last time. Thank you.

Aljosa · ‎03-05-2020

PATIENT VISITDT INTENSITY DATE_ONSET DATE_END term2 1 31DEC2015 Grade 1 (Mild) . . lowering hemoglobin 1 31DEC2015 Grade 1 (Mild) . . increase blood glucose 1 31DEC2015 Grade 4 . . hyperuricemia 1 31DEC2015 Grade 1 (Mild) . . hypokalemia 1 18.janv.16 Grade 1 (Mild) . . lowering hemoglobin 1 18.janv.16 Grade 1 (Mild) . . increase AST 1 18.janv.16 Grade 3 (Severe) . . hyperuricemia 1 18.janv.16 Grade 2 (Moderate) . . hypokalemia 1 22.janv.16 . . lengthen about qtcf 1 22.janv.16 Grade 1 (Mild) . . lowering blood calcium 1 15FEB2016 Grade 2 (Moderate) . . athralgia 1 15FEB2016 Grade 3 (Severe) . . hyperuricemia 1 18FEB2016 Grade 1 (Mild) . . hyperuricemia 1 18FEB2016 Grade 1 (Mild) . . lowering blood calcium 1 18FEB2016 Grade 2 (Moderate) . . hypokalemia 1 23FEB2016 Grade 1 (Mild) . . lowering hemoglobin 1 23FEB2016 Grade 1 (Mild) . . increase AST 1 23FEB2016 Grade 3 (Severe) . . hyperuricemia 1 23.mars.16 Grade 3 (Severe) . . lowering hemoglobin 1 23.mars.16 Grade 1 (Mild) . . increase AST 1 23.mars.16 . . lengthen about qtcf 1 23.mars.16 Grade 3 (Severe) . . hyperuricemia 1 23.mars.16 Grade 1 (Mild) . . hyperglycemia Hi all, In the table above you can see an example of patients reporting adverse events within different visits in hospitals. VISITDT is a visit date. term2 is adverse event verbatim. columns DATE_ONSET(=start date) and DATE_END are still not populated. I've chosen as example "hyperuricemia" to explain my problem. You can see that this patient #1 had hyperuricemia in all visits, except on the visit on 22.jan.2016. Thus, in my final table I would like to have only 2 rows for hyperuricemia (including max INTENSITY): 1st row: term2=hyperuricemia DATE_ONSET=31.dec.2015 DATE_END=18.jan.2016 INTENSITY=Grade 4 2nd row: term2=hyperuricemia DATE_ONSET=15.feb.2016 DATE_END=23.mar.2016 INTENSITY=Grade 3 (Severe) Basically I know how to have first and last date with proc sort, but my main problem is how to take into account the interruptions. Please could anyone help? I think program should look row by row, and if no hyperuricemia then it should take the previous VISITDT as end date. Then when program see hyperuricemia again it should take VISITDT as a new DATE_ONSET, and so on... THANK YOU!

Aljosa · ‎03-05-2020

Hi all, In the attached document you can see an example of the table summarizing patients adverse events within different visits in hospitals. VISITDT is a visit date. term2 is adverse event verbatim. columns DATE_ONSET(=start date) and DATE_END are still not populated. I put each visit in different color. And I took as example "hyperuricemia" which I highlighted in red color, to explain my problem. You can see that this patient #1 had hyperuricemia in all visits, except on the visit on 22.jan.2016. Thus, in my final table I would like to have only 2 rows for hyperuricemia (including max INTENSITY): 1st row: term2=hyperuricemia DATE_ONSET=31.dec.2015 DATE_END=18.jan.2016 INTENSITY=Grade 4 2nd row: term2=hyperuricemia DATE_ONSET=15.feb.2016 DATE_END=23.mar.2016 INTENSITY=Grade 3 (Severe) Basically I know how to have first and last date with proc sort, but my main problem is how to take into account the interruptions. Please could anyone help? I think program should look row by row, and if no hyperuricemia then it should take the previous VISITDT as end date. Then when program see hyperuricemia again it should take VISITDT as a new DATE_ONSET, and so on... THANK YOU!

Aljosa · ‎11-06-2019

Dear all, Thank you for providing me with your various solutions. I am sorry for my late answer. @mkeintz, I used your last program as the solution. But first I cleaned my data : -I did "proc sort" on a rows that have the same start date but different end date, -I deleted all drugs that have missing start date and end date. Then I run your program, and after I checked all data fusions on all occurrences, and all looks to work perfectly. Thank you so much. Have a nice day. Aljosa

Aljosa · ‎10-28-2019

Hi all, I will provide few more examples of my data, because it is more complex. The dot means missing data, it also means the treatment is "ongoing" If I have this : patientid name date_start date_end comment 1 drug A 23.06.2015 . here the dot disappear, regarding the following line 1 drug A 23.06.2015 25.09.2015 1 drug A 25.09.2015 . here the dot disappear, regarding the following line 1 drug A 25.09.2015 12.11.2015 1 drug A 13.11.2015 22.12.2015 2 drug B 12.11.2015 25.11.2015 2 drug B 26.11.2015 . here the dot disappear, regarding the following line 2 drug B 26.11.2015 22.06.2016 2 drug B 12.11.2016 25.11.2016 3 drug C 12.11.2015 25.11.2015 3 drug C 26.11.2015 . here we don't know what happened from 26.11.2015 to 12.11.2016, so we need to keep the dot. 3 drug C 12.11.2016 25.11.2016 4 drug D 12.11.2015 25.11.2015 4 drug D 26.11.2015 . here the dot disappear, regarding the following line 4 drug D 26.11.2015 22.06.2016 4 drug D 12.11.2016 25.11.2016 I would like in my final table to have this: patientid name date_start date_end 1 drug A 23.06.2015 22.12.2015 2 drug B 12.11.2015 22.06.2016 2 drug B 12.11.2016 25.11.2016 3 drug C 12.11.2015 . 3 drug C 12.11.2016 25.11.2016 4 drug D 12.11.2015 22.06.2016 4 drug D 12.11.2016 25.11.2016 Note: when we compare the previous end date with the following start date, we can say that drug intake is continuous if those two dates are same, or if the following start date is = previous end date+1. Also, note that I never have a dot in start date, its always in end date. It looks so complicated to me, I have a feeling this thing is impossible to resolve... Thank you very much +++ Kind regards.

Aljosa · ‎10-28-2019

Hi all, Thank you for your answers, I am looking to all your programs, I will come back to you as soon as I finish. I think major issues for most of programs are when we have dots in dates (=missing dates), they must be taken into consideration, as max dates. Kind regards.

Aljosa · ‎10-25-2019

Dear @novinosrin , I doesn't work good. If I have : patientid name date_start date_end 1 Drug A 22.10.2015 08.11.2015 1 Drug A 09.11.2015 . Instead of having this : patientid name date_start date_end 1 Drug A 22.10.2015 . ...I have this: patientid name date_start date_end 1 Drug A 22.10.2015 08.11.2015 Is there something to change in program so it can work? Thank you. Kind regards. Aljosa

Aljosa · ‎10-24-2019

Hello, I have a listing of patients and their dates of use of drugs. For example, for patient n°1 Drug A I have 2 lines, while in fact this patient never stopped his drug consumption, so instead of having first line start=22/10/2015 - end=08/11/2015 and second line start=09/11/2015 - end=16/12/2015, I would like in my final table to have only 1 line: start=22/10/2015 - end=16/12/2015. However, for patient n°1 Drug B, the treatment is NOT continuous (as he was without the drug on 05/11/2015, so for Drug B I need to keep both 2 lines in my final table. Please help, I tried with retain, with LAG... but without success... Thank you. my initial table: patientid name date_start date_end 1 Drug A 22.10.2015 08.11.2015 1 Drug A 09.11.2015 16.12.2015 1 Drug B 22.10.2015 04.11.2015 1 Drug B 06.11.2015 . and my final table would be: patientid name date_start date_end 1 Drug A 22.10.2015 16.12.2015 1 Drug B 22.10.2015 04.11.2015 1 Drug B 06.11.2015 .

Online Status	Offline
Date Last Visited	‎05-20-2020 06:51 AM

How to fill out blanc fileds with the last value populated

Re: dates interruptions

Re: dates interruptions

Re: dates interruptions

Re: dates interruptions

Re: dates interruptions

Re: dates interruptions

dates interruptions

dates interruptions

Re: continuous date

Re: How to fill out blanc fileds with the last value populated

Re: dates interruptions

How to fill out blanc fileds with the last value populated

Re: dates interruptions

Re: dates interruptions

Re: dates interruptions

Re: dates interruptions

Re: dates interruptions

Re: dates interruptions

dates interruptions

dates interruptions

Re: continuous date

Re: continuous date

Re: continuous date

Re: continuous date

continuous date