Hello,   I am having a difficult time trying to figure out how to merge the two different variables into one variable.   My data set looks like the following:   ID=> Patient ID Chemo_Start_Date=> Date when chemotherapy started Death=> 1=Death 0=Survived Death_Date=> Date when patient died Observation_Finish_date=> Date when follow-up is finished FU_DTH   --------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ID           Chemo_Start_Date    Death     Death_Date     Observation_Finish_Date        10001           2011-08-22            1            2012-03-01                2015-05-30                                              10002           2010-05-15            0                      .                        2015-05-30                                    ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------   The follow-up duration (FU) for patients who died (Death=1) should be the difference in dates between the Chemo_Start_Date and Death_Date.   The follow-up duration (FU) for patients who survived (Death=0) should be the difference in dates between the Chemo_Start_Date and Observation_Finish_Date.   So I tried the following:   data w.cancer_DT; set w.cancer; FU = DATDIF(Chemo_Start_Date, Death_Date, 'ACT/ACT'); where death=1; run;   data w.cancer_SUR; set w.cancer; FU = DATDIF(Chemo_Start_Date, Observation_Finish_Date, 'ACT/ACT'); where deat=0; run;   data w.cancer_All; set w.cancer_DT w.cancer_SUR; run;     My result looks like the following, which is what I needed: --------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ID           Chemo_Start_Date    Death     Death_Date     Observation_Finish_Date     FU_Survival      10001           2011-08-22            1            2012-03-01                2015-05-30                        192                        10002           2010-05-15            0                      .                        2015-05-30                         841.                       ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------   However, is there a way to do this in a simple way without seperating files?   Any help or advice will be greatly appreciated.   Thank you. ... View more

Hello,   I want to create a dummy variable for the patient data.   Patients 10002, 10003, 10004 were dead, and  Patients 10005, 10006, 10007 have survived so far.     ----------------------------------------------- Patient_ID      Death_Date  10002            2013-06-04 10003            2011-08-15 10004            2012-12-14 10005  10006 10007 --------------------------------------------- Depending on if Death_Date is present or not, I want to make  a new variable DEATH (1= Death, 0=Surived)          so I tried the following:    data w.patient; set w.patient; Death=.; if (Death_Date=".") then Death = 1 if (Death_Date=" ") then Death = 0 run;    However, it is marking all the death   What have I done wrong?   Any advice or help would be appreciated.   Thank you.    P.S Ultimately, I want to make my data set as  the following:  ----------------------------------------------- Patient_ID      Death_Date     Death  10002            2013-06-04           1  10003            2011-08-15           1 10004            2012-12-14           1 10005                                         0 10006                                         0 10007                                         0 ---------------------------------------------             ... View more

Hello,   I would like to delete the first variable of the values of the variable CONTEST:   (Package_ID= identification number for each package / CONT_CD=unique code for the contents in the package)   -------------------------------------- Package_ID    CONT_CD 1001                 XA123 1002                 XA225 1003                 YA336 ---------------------------------------   I would like to simply get ride of the first letter of the Variable CONT_CD so it looks like the following:   -------------------------------------- Package_ID    CONT_CD 1001                 A123 1002                 A225 1003                 A336 ---------------------------------------   I have tried the following,,   data w.package_want set w.package; CONT_CD = SUBSTR(2,5) in CONT_CD; RUN;   but I am getting an error.   Any advice or help would be really helpful.   Thank you.       ... View more

Hello,   This may sound like a very basic question... but,   I am working with a set of chemotherapy data that contains 3 types of chemotherapy and it would be really helpful if there is a way to run Chi-Squared Test in SAS without seperating the files.   My data and variables looks like the following:   Patient_ID=ID assigned to Patient Chemo_Type=Type of Chemotherapy (1=type A, 2=type B, 3=type C) Readmiited_YN=Readmission to Hospital after Chemotherapy (1=readmission, 0=no readmission),     Patient_ID    Chemo_Type   Readmitted_YN 10012                        1                       1 10013                        2                       0 10014                        3                       0 10015                        2                       1 10016                        2                       0 10017                        3                       1 10018                        1                       1 10019                        2                       1 . . . (cont')   with this data set I have to do a run a chi-squared test for Chemo_Type=1 vs. Chemo_Type=2 & Chemo_Type=1 vs. Chemo_Type=3 (*I do NOT need to run a chi-squared test for Chemo_type=2 vs. Chemo_type=3)   Is there a way to run the chi-squared test for Chemo_Type=1 vs. Chemo_Type=2 & Chemo_Type=1 vs. Chemo_Type=3 with the current data set I have?   I am currently doing the following :   -------------------------------------------------------------------------------------------   data w.cancer_1vs2; set w.cancer; if Chemo_type=3 then delete;   proc freq data=w.cancer_1vs2; tables Chemo_Type*Readmitted_YN/chisq; run;   data w.cancer_1vs3; set w.cancer; if Chemo_type=2 then delete;   proc freq data=w.cancer_1vs3; tables Chemo_Type*Readmitted_YN/chisq; run; ---------------------------------------------------------------------------------------------   Is there a way to run this in a single file (w.cancer) without having to delete the undesired Chemo_Type for running Chi-Squared Test?   Thank you.                     ... View more

Hello,   I am simply trying to create a new date variable in my cancer survival data set to mark the end of the observation date as 2015-06-30. The new date variable named "obs_fn" should all have the same date: 2015-06-30.   I have tried the following:   data w.cancer; set w.cancer; format obs_fn yymmddn8.; obs_fn = 20160630; run;   The new variable "" appears as 9999-12-31   I am not sure what I have done wrong.   Is there a way to make this work correctly in SAS enterpirse?   Thank you. ... View more

Hello,   I am trying to work with a sample data about people's visit to a certain state and sort out whether each person has visited    the capital (Washington D.C ) or not and how many times each person visited there by flight.   The major problem I am having is grouping with the new variables.    Below is my sample data .   ID= personal identification number    FLIGHT_TICKET_N= flight ticket number   STATE = state in the U.S (DC=Washington D.C, captial city of the U.S)    data VISIT; input ID$ FLIGHT_TICKET_N STATE$; cards; 10063 1111 DC 10063 1112 DC 10063 1113 DC 10073 2221 DC 10073 2223 TX 10083 3331 CA 10083 3332 WA run;   data visit; set visit; captial="."; if substr(STATE,1,2) in ("DC") then captial=1; if captial ~= 1 then captial=0; run;   data visit_1; set visit; by ID; if first.ID then acc_capital=0; acc_capital + captial; run;   so far it works as I intended. However, when I tried this:  proc sort data=visit_1 out=visit_2 nodupkey; by ID; run;   The results do not correctly reflect:   #1. whether each person has visited the capital city or not   #2. the accumulated number of visit to the capital city for each person.   as shown in the picture.    I really need to figure this out.   I am I would appreciate any help.   Thank you in advance.  ... View more