About Pooja

Pooja · ‎10-02-2013

Oops..you're right Vince, I forgot to change the variable name!:smileyblush: Thanks a lot for your help!

Pooja · ‎10-02-2013

Reeza, Vince's code ran with no errors. Only the newday array had missing values for all the columns. The data look exactly like how you described it. The output dataset was like: Patient_ID start_dat end_day day1......day1825 newday1....newday365 111 2 367 0 1 1 1 1 2 2 2 ............................ with the entire newday array missing. Thanks!

Pooja · ‎10-02-2013

Thanks for the clarification Vincent. I used the code but for the newday array I get all missing values. All the 365 columns for all the patients are missing.

Pooja · ‎10-02-2013

I had data over a longer period so day1 is the day they indexed on the medication. However I need data only over a particular 365 days snapshot. Yes start_day and end_day are continuous numbers between 1 and 1825 and represent the 365 day period over which I need data. The final product I am hoping for is a new array newday1-newday365. Thanks!

Pooja · ‎10-02-2013

Hello Amir, For each patient day1 is not the same as the start_date. I have the start_date as a separate variable which is a continuous number between 1 and 1825. You are right I want to have exactly 365 days following start_date so end_date would be irrelevant. Thanks!

Pooja · ‎10-02-2013

Hello Vince, Thanks for your code. What exactly do you mean by day1 of collection? I know which day the 365 day period for each patient starts and which day it ends. Please could you clarify? day{i} would not necessarily be 0 for days outside of the start_date and end_date. I need a particular snapshot of the data and hence I am trying to get 365 out of the 1825 days. Thanks!

Pooja · ‎10-02-2013

Hello All, I have a dataset where each row represents a patient and each column a day. The columns have 0 if the patient is on no medication, 1 if the patient is on one medication, 2 if the patient is on 2 medications and so on. There are 1825 days in the form of an array day1-day1825. I need to select 365 days from these 1825 days for each patient. The start and end date will vary for each patient. How do I create this new array of 365 days for each patient based on the individual patients specific start and end date. What I have Patient_id Start_date End_date Day1.......day1825 What I need Patient_Id Start_date End_date Day1...day365 Based on each individual patients start and end date. Any guidance will be appreciated. Regards, Pooja Desai The University of Texas at Austin

Pooja · ‎04-09-2013

Please disregard my previous comment. I see that the situation I mentioned has already been considered! Thank a lot for your help, PGStats, I really appreciate it!! Pooja

Pooja · ‎04-08-2013

Hello PG, Thank you very much. This is awesome! I had another follow-up question on this code. If dayEnd=dayStart+365 would it be possible to identify other distinct multiple therapy periods- periods of at least 60 days or more of multiple therapy without a 31 day gap- which occur after a greater than 31 days gap after the identified episode but before the dayEnd. Thanks again--I really appreciate your help. Pooja

Pooja · ‎04-08-2013

Hello, By that I mean that for a patient to be classified as taking more than one medication they should have two medications for 60 days one after the other. If there is a gap of less than 31 days (during the gap the patient can be taking one medication or no medication)then that still counts as a part of the multiple medication episode. Example: d1 d2 d3 d4 d5 d6 d7 d8 d9-d19 d20-30 d31-d41 d42-d52 d53-d58 dd59 d60 d61 d62 d63 d64 d65 d66 d67 d68 d69 d70 d71 d72 d73 d74 Patient1 1 1 1 1 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 1 1 1 1 1 2 2 2 2 2 2 2 For patient1 once the patient starts taking 2 medications on day 5 he continues doing so till day 75. There are 5 days from day 63 to day 67 where he took only one medication but since it is lesser than 31 days it is counted as a part of the multiple medication episode. d1 d2 d3 d4 d5 d6 d7-d65 d66 d67 d68-d101 d102 d103 d104 d105 d106 d107-d175 d176 d177 d178 d179 Patient2 1 2 2 2 2 2 2 2 2 2 1 1 1 1 1 1 2 2 2 2 2 2 2 Patient2 uses multiple medications from day 2 till day 67. he then has a gap from day 68 to day 105. Since this is greater than 31 days, when he starts using multiple medications again on day 106 to day 179, this counts as a second episode. I want to follow the patients for 365 days after their first at least 60-day multiple medication episode. So we would follow patient1 for 365 days after day 5 and patient2 for 365 days after day 2. During this 365 days period, I need to count all the multiple medication episodes which are at least 60 days in length without a gap (gap=when the patient takes 1 or 0 medications) of 31 days or greater. If the patient takes multiple medications for less than 60 days, it is not considered as a multiple medications episode. I hope this makes it clearer. Thanks a lot! Pooja

Pooja · ‎04-08-2013

Hello dd08, I was wondering if you found a solution to this problem. I have a similar issue and an looking for a solution. Thanks, Pooja

Pooja · ‎04-08-2013

Hello Everyone! I have a dataset where each column represents a day. There are 1825 columns. Each row represents a patient. Each day that the patient had a medication there is a 1 in the column and 0 for the days when the patient took no medication. On the days when the patient took more than one medication, the column has the number of medications taken by the patient on that day (could be 2, 3, etc.) I am interested in identifying patients taking multiple medication (more than 1) on at least 60 consecutive days without a 31 day gap. From the start of the at least 60-day multiple medications episode, I need to follow the patient for a year (365 days). If the patient had multiple episodes within the 365-day period i.e.say 75 days multiple medications, then for 55 days just one medication and then 100 days of multiple medications again, I need to count those episodes, too. I need to report the number of episodes of multiple medications and mean length of each episode. Please could you help me with the code on this. This is a snapshot of my dataset. day1 day2 day3 day4 day5 day6 day7 day8 day9 day10 day11 day12 Patient1 1 1 1 1 1 2 2 2 2 2 2 2 Patient2 2 2 2 2 2 1 1 1 1 2 2 2 Thank you! Pooja Desai

Pooja · ‎12-08-2012

Will do so, Steve. Thank you so much for your help! Pooja

Pooja · ‎12-08-2012

Hello Ken, Thank you very much for your reply and willingness to help. I am looking at the healthcare costs and utilization of patients initiated on four different medications for Attention Deficit Hyperactive Disorder (ADHD). I assumed one drug to be the control and used propensity score matching to match patients initiated on that drug to each of the three other drugs (I used 3 separate models). Now for the inpatient and ED costs, large proportion of the patients have zero since they did not have these events. I am interested in getting the difference in cost between the control drug and each of the 3 case drugs after controlling for the propensity score and the covariates that I used to obtain my propensity score. Based on briefly reviewing the literature, I saw that it is possible to use a two-part model for excessive zeros where the first part is a logistic regression and the second part could be gamma regression, normal regression etc. However, I am not familiar with such models. You have suggested a variant of the tobit model. I am not familiar with the differences between tobit and logit models. Please do let me know if you need more information. Any help will be greatly appreciated. Thanks, Pooja

Pooja · ‎12-06-2012

Hello, I have healthcare cost data for two different drugs (inpatient hospitalization and emergency department visits costs) which have a large number of zeros. I have also used propensity score matching to match patients taking the two drugs on a list of different covariates. Since there are so many zeros, I wanted to use a two-part model for the costs. Could someone please direct me where to look for the SAS code or help me with the basic code if they already have it ready. Thank you very much in advance. Pooja

Online Status	Offline
Date Last Visited	‎09-01-2015 07:11 AM

Re: Selecting specific column from an array.

Re: Selecting specific column from an array.

Re: Selecting specific column from an array.

Re: Selecting specific column from an array.

Re: Selecting specific column from an array.

Re: Selecting specific column from an array.

Selecting specific column from an array.

Re: Data management using SAS

Re: Data management using SAS

Re: Data management using SAS

Re: Proc genmod error

Re: Selecting specific column from an array.

Re: Selecting specific column from an array.

Re: Selecting specific column from an array.

Re: Selecting specific column from an array.

Re: Selecting specific column from an array.

Re: Selecting specific column from an array.

Selecting specific column from an array.

Re: Data management using SAS

Re: Data management using SAS

Re: Data management using SAS

Re: Help! How do I capture the complicated concomitant medication pat...

Data management using SAS

Re: Proc genmod error

Re: Two part model for correlated health care costs

Two part model for correlated health care costs