Here's my code below. Whenever I run it, the duration variable counts 0 for every observation in my dataset. Not sure why it's not calculating the duration in months between a patient's initial diagnosis date and the date of their death. Can someone take a look at my code and tell me if they see something wrong?   DATA survival_analysis; SET pancreas_temp4; duration = INTCK("DTMONTH", initial_dx_date1, coalesce(date_of_death1, date_last_fu_or_d1)); put duration = ; IF vital_status1 = 0 or not missing(date_of_death1) then censored = 1; ELSE IF vital_status1 = 1 then censored = 0; LABEL duration = "Duration in Months"; RUN; And here is a clip of the SAS log file:  537 DATA survival_analysis; SET pancreas_temp4; 538 539 duration = INTCK("DTMONTH", initial_dx_date1, coalesce(date_of_death1, 539! date_last_fu_or_d1)); 540 put duration = ; 541 542 IF vital_status1 = 0 or not missing(date_of_death1) then censored = 1; 543 ELSE IF vital_status1 = 1 then censored = 0; 544 545 LABEL duration = "Duration in Months"; 546 RUN; duration=0 duration=0 duration=0 duration=0 duration=0 duration=0 duration=0 duration=0 duration=0 duration=0 duration=0 duration=0   See all those lovely zeros? Why?! I checked all my dates and they are all the same format MMDDYY10, so I am not sure what's wrong. Any help is appreciated. Also, here is some sample data.       1 = alive, 0 = dead           vital_status1 initial_dx_date1 date_of_death1 date_last_fu_or_d1 1 08/02/2016 . 10/13/2017 0 02/25/2010 07/15/2010 07/15/2010 0 07/05/2010 . 08/14/2011 0 02/21/2012 07/11/2012 07/11/2012 0 03/24/2014 . 10/10/2014 1 02/03/2014 . 01/25/2018 1 01/30/2017 . 02/22/2018 0 06/15/2012 10/22/2013 10/22/2013 0 11/20/2009 06/10/2010 06/10/2010 0 10/21/2010 10/11/2015 10/11/2015 0 11/22/2011 07/28/2014 07/28/2014 1 05/22/2012 . 02/18/2014 0 07/08/2013 11/24/2013 11/24/2013 0 10/02/2013 12/25/2014 12/25/2014 0 05/17/2011 09/09/2016 09/09/2016 0 05/05/2011 09/10/2013 09/10/2013 ... View more

Hello all,   I am about intermediate level with SAS programming and beginner level with SQL. I am having difficulty subsetting my dataset by certain criteria. The dataset contains patients who have had cancer either once or multiple times. However, if the patients FIRST cancer was not pancreatic, then they need to be deleted. This part I have done. The second step is to get rid of the remaining patients who are in the dataset with any type of cancer, but never had a first cancer listed as pancreatic cancer. One goal of this project is to take a look at patients who had pancreatic cancer as their first cancer, and for those who have had multiple cancers, find out what other types of cancers they got after their pancreatic cancer diagnosis.   One way I was trying to do this was by Patient_ID, but I am not aware of any DISTINCT equivalency statements in SAS and I don't know SQL that well.  Below is the code I used to get rid of those whose first cancer was not pancreatic. It is also subset by histology type as I do not want patients with certain histological types of pancreatic cancer:   DATA pancreas_temp1; SET pancreas; IF Histologic_Type_ICD_O_3 not in (8150, 8151, 8152, 8153, 8155, 8240, 8241, 8246) AND Sequence_number IN ("One primary only", "1st of 2 or more primaries") then DELETE; IF Primary_Site___labeled not =: 'C25' AND Sequence_number IN ("One primary only", "1st of 2 or more primaries") then DELETE; RUN; Here is a sample of my dataset. I have sorted it by Patient_ID which is what revealed the problem - patients with no "Only one primary" or "1st of 2 or more primaries" are in this dataset: Patient_ID Sequence_number Primary_site__labeled Histologic_Type_ICD_O_3 16 2nd of 2 or more primaries C20.9 - Rectum, NOS 8140 18 2nd of 2 or more primaries C38.1-Anterior mediastinum 8801 22 2nd of 2 or more primaries C42.1-Bone marrow 9732 22 3rd of 3 or more primaries C50.9-Breast, NOS 8500 25 One primary only C25.2-Tail of pancreas 8246 31 4th of 4 or more primaries C50.4-Upper-outer quadrant of breast 8500 31 5th of 5 or more primaries C34.1-Upper lobe, lung 8070 32 1st of 2 or more primaries C25.0-Head of pancreas 8155     Here is what I want: Patient_ID Sequence_number Primary_site__labeled Histologic_Type_ICD_O_3 25 One primary only C25.2-Tail of pancreas 8246 32 1st of 2 or more primaries C25.0-Head of pancreas 8155 32 2nd of 2 or more primaries C64.9-Kidney, NOS 8312   Patients 16, 18, 22, and 31 need to go because it is apparent that their first cancer is not listed so we can't tell if it was pancreatic or not.    Any help is appreciated. Thank you! ... View more

When I run proc lifetest, nearly all of my observations are deleted with the following message, "169 observations with invalid time, censoring, or strata values were deleted." I can't figure out why it's doing this. Below is my data after I create the censoring variable from the code I pasted below. I apologize if it's long, but I figured you want to see the whole thing. This survival analysis is supposed to model recurrence of breast cancer where LastFUStatus1 can = 4 meaning Alive, with recurrence and everything else does != alive with recurrence. DateFirstRecur1 is self-explanatory, it is the date the patient had their first recurrence of their cancer. Insurance status ( 0 = uninsured, 1 = insured):  SAS Output Duration in Months InsuranceStatus1 LastFUStatus1 DateFirstRecur1 censored_disease . 1 2 . 0 . 0 . . 0 24 1 4 20JUN2016:00:00:00 1 . 1 2 . 0 . 0 . . 0 . 1 1 . 0 16 0 7 06SEP2013:00:00:00 1 . 1 2 . 0 . 0 . . 0 . 1 2 . 0 . 0 2 . 0 . 1 . . 0 . 0 . . 0 29 1 4 25FEB2013:00:00:00 1 . 1 2 . 0 . 1 2 . 0 . 1 2 . 0 . 1 2 . 0 . 1 2 . 0 . 1 2 . 0 . 1 2 . 0 . 1 7 . 0 . 1 2 . 0 . 1 2 . 0 . 0 2 . 0 . 1 2 . 0 . 1 . . 0 . 0 . . 0 . 0 . . 0 . 0 . . 0 . 1 2 . 0 . 1 . . 0 . 1 2 . 0 . 1 1 . 0 . 1 2 . 0 . 1 2 . 0 . 1 2 . 0 . 1 2 . 0 . 1 2 . 0 . 1 2 . 0 . 1 2 . 0 . 1 2 . 0 . 1 . . 0 . 1 2 . 0 7 1 . 10NOV2008:00:00:00 1 . 0 . . 0 . 1 2 . 0 . 1 . . 0 . 1 2 . 0 . 1 2 . 0 . 1 2 . 0 . 1 2 . 0 . 0 . . 0 18 1 2 19NOV2014:00:00:00 1 11 1 4 11MAY2010:00:00:00 1 . 1 2 . 0 48 1 8 08APR2013:00:00:00 1 . 1 2 . 0 . 1 2 . 0 . 1 2 . 0 . 1 2 . 0 47 1 2 23FEB2011:00:00:00 1 . 1 2 . 0 . 1 2 . 0 . 1 2 . 0 . 1 2 . 0 . 0 . . 0 . 1 2 . 0 . 1 2 . 0 . 1 . . 0 13 1 1 13NOV2009:00:00:00 1 . 1 2 . 0 . 1 2 . 0 . 1 . . 0 . 1 . . 0 . 1 2 . 0 . 1 2 . 0 . 1 2 . 0 . 1 2 . 0 . 1 2 . 0 . 0 . . 0 . 1 . . 0 . 1 2 . 0 . 1 . . 0 . 0 2 . 0 . 1 2 . 0 . 1 2 . 0 . 1 2 . 0 . 1 . . 0 . 1 2 . 0 . 1 . . 0 . 1 8 . 0 . 1 2 . 0 . 1 2 . 0 101 1 8 23MAR2010:00:00:00 1 . 0 2 . 0 . 1 . . 0 . 1 . . 0 . 1 2 . 0 . 0 2 . 0 . 1 2 . 0 . 1 2 . 0 . 0 2 . 0 . 1 2 . 0 . 1 2 . 0 . 1 2 . 0 . 1 5 . 0 . 0 . . 0 11 1 8 05MAY2016:00:00:00 1 . 1 2 . 0 . 1 2 . 0 . 1 2 . 0 . 1 2 . 0 . 1 2 . 0 . 0 . . 0 . 1 2 . 0 . 1 . . 0 . 1 . . 0 . 0 . . 0 . 1 8 . 0 . 1 2 . 0 . 1 2 . 0 . 1 2 . 0 . 1 2 . 0 . 1 . . 0 . 1 2 . 0 . 1 2 . 0 . 1 2 . 0 . 1 2 . 0 . 1 2 . 0 . 1 1 . 0 . 1 2 . 0 . 1 . . 0 1 1 . 06MAR2001:00:00:00 1 . 1 . . 0 . 1 2 . 0 39 1 8 23JAN2015:00:00:00 1 . 0 2 . 0 . 1 8 . 0 . 1 2 . 0 . 1 2 . 0 . 1 2 . 0 40 1 2 16OCT2012:00:00:00 1 . 0 2 . 0 . 1 2 . 0 . 0 . . 0 12 1 . 21MAR2007:00:00:00 1 12 1 . 21MAR2007:00:00:00 1 . 1 2 . 0 . 0 . . 0 . 1 . . 0 . 1 2 . 0 . 1 2 . 0 . 0 2 . 0 . 1 2 . 0 . 1 . . 0 . 1 1 . 0 . 1 2 . 0 . 1 . . 0 24 1 7 02DEC2004:00:00:00 1 20 1 7 14NOV2012:00:00:00 1 . 1 . . 0 . 1 2 . 0 66 1 4 04MAR2016:00:00:00 1 . 1 1 . 0 . 1 . . 0 . 0 . . 0 33 1 8 04NOV2011:00:00:00 1 . 1 2 . 0 . 1 . . 0 . 1 2 . 0 . 1 . . 0 . 1 . . 0 . 1 . . 0 . 0 . . 0 . 1 2 . 0 . 0 . . 0 13 1 . 02APR2002:00:00:00 1 . 0 1 . 0 . 1 . . 0 . 1 2 . 0 39 1 8 30NOV2010:00:00:00 1 . 0 . . 0 . 1 2 . 0 . 1 2 . 0 . 1 2 . 0 . 0 . . 0 . 0 5 . 0 . 1 2 . 0 . 1 2 . 0 . 0 . . 0   And here is my code:  DATA disease_interval; SET trends_temp5; months = intck("dtmonth", DateOfInitDx1, DateFirstRecur1); put months =; IF LastFUStatus1 = 4 or not missing(DateFirstRecur1) then censored_disease = 1; ELSE IF LastFUStatus1 ne 4 or missing(DateFirstRecur1) then censored_disease = 0; *Delete ****** due to inconsistent data; IF Lname = "HO*****" and Fname = "K******" then DELETE; LABEL months = "Duration in Months"; RUN; PROC LIFETEST DATA = disease_interval plots = survival(cb=hw test atrisk(outside(0.10))) graphics; FORMAT InsuranceStatus1 InsuranceType.; strata InsuranceStatus1; time months*censored_disease(0); symbol1 v=none; RUN; And my output:  SAS Output Summary of the Number of Censored and Uncensored ValuesStratum InsuranceStatus1 Total Failed Censored PercentCensored1 Insured2 UninsuredTotal   21 21 0 0.00 1 1 0 0.00 22 22 0 0.00 Note: 169 observations with invalid time, censoring, or strata values were deleted. ... View more

For the following problem I'm having, I'm not sure where to even begin when it comes to the code, so I don't have much code to present here, but I will describe my problem.   1. I need to find all patients who have the same MRN, then look at their date of surgeries. If they are listed more than once in the dataset by MRN, and they have the same date of surgery, this means they had more than one tumor and both tumors were removed on the same day. I need to remove the record with the lower tumor size.   2. If the patient is in the dataset more than once (their MRN will be in there more than once), but their date of surgeries are different, I then need to remove the observation(s) with the higher sequence number(s).   This is for analysis purposes. I will be running things like PROC FREQ and PROC LOGISTIC on this data set. Can anyone help, please?   DateOfSurgery1 SequenceNum1 MRN1 TumorSizecm1 12OCT2018:00:00:00 2 223XXX 4 12OCT2018:00:00:00 1 223XXX 2.5 14SEP2013:00:00:00 2 328XXX 2 14SEP2013:00:00:00 1 328XXX 0.6 10JAN2013:00:00:00 2 336XXX 4.5 20AUG2011:00:00:00 1 336XXX 4.5 17JUL2015:00:00:00 2 337XXX 4 06MAY2002:00:00:00 1 337XXX . 09AUG2017:00:00:00 3 350XXX 1.2 04OCT2017:00:00:00 4 350XXX 0.3 09JUL2011:00:00:00 2 350XXX 2.5 30AUG2012:00:00:00 1 350XXX 1 07JUN2016:00:00:00 4 354XXX 1.2 19NOV2006:00:00:00 3 354XXX 1 17FEB2014:00:00:00 1 355XXX 2.8 08JAN2013:00:00:00 2 355XXX 1.2 10DEC2013:00:00:00 2 359XXX 0.7 10DEC2013:00:00:00 1 359XXX 2.2 27MAR2015:00:00:00 2 368XXX 0.6 27MAR2015:00:00:00 1 368XXX 0.9   The expected dataset should look like this: DateOfSurgery1 SequenceNum1 MRN1 TumorSizecm1 12OCT2018:00:00:00 2 223XXX 4 14SEP2013:00:00:00 2 328XXX 2 20AUG2011:00:00:00 1 336XXX 4.5 06MAY2002:00:00:00 1 337XXX . 30AUG2012:00:00:00 1 350XXX 1 19NOV2006:00:00:00 3 354XXX 1 17FEB2014:00:00:00 1 355XXX 2.8 10DEC2013:00:00:00 1 359XXX 2.2 27MAR2015:00:00:00 1 368XXX 0.9 ... View more