cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
hendrixl114
‎01-24-2019
  • 6 Posts
  • 0 Likes Given
  • 0 Solutions
  • 0 Likes Received

Re: Stratified random sample by group with count conditions (and possi...

by Calcite | Level 5 in SAS Programming
‎07-21-2017 10:08 AM
‎07-21-2017 10:08 AM
I have used surveyselect, but I need a way to draw all of the As for each facility before sampling the Bs.  If I remove the A first from the dataset I need to be able to select only 15-A patients from each facility.  I think i need some sort of macro that will cycle through the observations at each faciity and apply the conditions, but I don't know how to do this.  I'm actually not as worried about the PPS as getting the correct number of A and B per facility.   ... View more

Stratified random sample by group with count conditions (and possibly ...

by Calcite | Level 5 in SAS Programming
‎07-21-2017 09:43 AM
‎07-21-2017 09:43 AM
Hello, I have a complicated sampling strategy that I am trying to program in SAS 9.4 and am hoping someone can help me.    My dataset of ~150,000 includes patients at 1230 facilities that received two types of treatment.  ~4000 received treatment A while ~146,000 received treatment B.  I need to generate a dataset with no more than 15 patients selected from each facility, but keep as many of the 4000 A patients as I can.  So for example if a facility had 5 A patients I would keep all 5 A patients then draw a random sample of 10 B patients from that facility to get n=15.  If there are no A patients at the facility then I would take a random sample of 15 B patients, likewise if there are 15 A patients at the facility I would keep all 15 of them.   There are a few facilities where there are more than 15 A patients, so I would need to draw a random sample of 15 A patients for these facilities.  I would then lose a few A patients from my overall sample.   Because the number of patients A+B from each facility ranges from 0 to >1000, I don't know if I can use PPS or weighting in this algorithm or if I will need to adjust for sampling weights in my analysis later.   I have attached a small sample dataset.   Any help would be greatly appreciated!   Thanks, Laura ... View more

Re: Sequencing multiple treatment dates within a time window

by Calcite | Level 5 in SAS Health and Life Sciences
‎08-29-2014 12:37 PM
‎08-29-2014 12:37 PM
This works!!! Thank you so much, you have no idea how much I appreciate your help!! ... View more

Re: Sequencing multiple treatment dates within a time window

by Calcite | Level 5 in SAS Health and Life Sciences
‎08-28-2014 11:12 AM
‎08-28-2014 11:12 AM
Yes, sorry!  Those dates are for a 3-month window!  Let me do this again, changing the dates to be correct this time...i think these are right now patient ID     dxdate          first_rtdate          first_surgdate              first_btdate         first_htdate     1                01JAN2008     01AUG2008                                                  .                  01JUL2008 2               01MAY2004     01NOV2009         01DEC2004               15DEC2004          01NOV2004 3               01SEP2003     01FEB2005           01DEC2004                                        01APR2004 4               01JUL2005                                  01SEP2005                                         01FEB2006 5.              01OCT2001                                   01OCT2007 6.              01JAN2002     01JUL2002               15JUL2007 7.              01NOV2009     01DEC2009               01DEC2013 patient ID     txseq 1                    HT,RT 2                    HT,SURG,BT 3                    HT,SURG,RT 4                   HT 5.                  NO TREATMENT 6.                  RT 7.                  NO TREATMENT ... View more

Re: Sequencing multiple treatment dates within a time window

by Calcite | Level 5 in SAS Health and Life Sciences
‎08-28-2014 10:39 AM
‎08-28-2014 10:39 AM
Thanks for your help!  Patient 7 has no treatment because the only treatment date, for RT, was only 1 month after diagnosis.  The earliest treatment date in my 'window' should be dxdate +180.  I am only interested in treatment dates dx+180 days to dxdate +3 years. In other words, the 'initial' window is dx+180<txdate<3yrs.  Once I determine the first treatment within that window, I need to set another window, for all subsequent treatments within 1 year of that first treatment date.  Then I need to create the txseq variable (which will include the initial treatment date). Laura ... View more

Sequencing multiple treatment dates within a time window

by Calcite | Level 5 in SAS Health and Life Sciences
‎08-28-2014 08:40 AM
‎08-28-2014 08:40 AM
I have a dataset containing dates of treatment for cancer patients.  A patient can have radiation, surgery, brachytherapy, hormone treatment, or no treatment. I need to find the first treatment that occurred in a time window of diagnosis date + 180 days to diagnosis date + 3 years, then determine the sequence of all other 'first' treatments that occurred within 1 year after the first treatment and construct a variable that indicates the treatment sequence within this time window..  My dataset looks like this: patient ID     dxdate          first_rtdate          first_surgdate              first_btdate         first_htdate     1                01JAN2008     01JUN2008                                                  .                  01MAY2008 2               01MAY2004     01MAY2009         15JUN2004               01SEP2004          01JUN2004 3               01SEP2003     01MAR2004           01DEC2003                                        15SEP2003 4               01JUL2005                                                                                             15JUL2005 5.              01OCT2001                                   01OCT2007 6.              01JAN2002     15JUL2002               15JUL2007 7.              01NOV2009     01DEC2009               01DEC2013 What I need to end up with is a variable for treatment sequence, including the first treatment, within this first treatment-365day window that looks like patient ID     txseq 1                    HT,RT 2                    HT,SURG,BT 3                    HT,SURG,RT 4                   HT 5.                  NO TREATMENT 6.                  RT 7.                  NO TREATMENT I'd be very grateful for any help! Thank you ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎01-24-2019 10:54 AM
Quick links