Hi, I need to convert the texted date variable to a particular format. Eg: data have; input R_Date$20.; cards; 31/01/2000 15/3/2015 30-5-2010 30-12-2018 31/7/20 15/2/12 18/05/15 11-08-08 2000 1998 ; Expected result 01/31/2000 03/15/2015 05/30/2010 12/30/2018 07/31/2020 02/15/2012 05/18/2015 08/11/2008 01/01/2000 01/01/1998   Kindly suggest a code to get MM/DD/YYYY format. ... View more

Hi, I need to list out the medical stages of the patients. In the output the values of each stage should be unique in order. I shared the example set below. data have; input ID Date1 mmddyy10. stages$10.; format Date1 mmddyy10.; cards; 123 02/05/2000 7,2,2 456 08/08/1999 5,5,1 789 07/02/2012 1,1 187 06/06/2003 7,9 753 12/12/1993 2,9,2,2,2 654 01/11/2001 2,9,2 321 04/05/2000 12,5,9,5 987 03/02/1999 14 178 05/06/1998 5 845 03/03/2020 9,9,9 159 09/08/2020 1,3,18 run; Expected output :  stages Stg 7,2,2 7,2 5,5,1 5,1 1,1 1 7,9 7,9 2,9,2,2,2 9,2 2,9,2 9,2 12,5,9,5 12,9,5 14 14 5 5 9,9,9 9 1,3,18 1,3,18 The values should matches the corresponding ID and date. Kindly suggest a code. Thanks in advance! ... View more

Hi,   I have a drug dataset for a research study. I need to separate the values by '/' in the column. Kindly go through the sample set for the reference.   data have; input Drug$80.; cards; metformin/Glicipage Glibenclimide/glicipage Alphaglid/glucose/SGLT2 Metformin/Glucose ; Expected Output:   Drug1 Metformin Glicipage Glibenclimide Alphaglid Glucose SGLT2 ... View more

Hi Experts,   I need to do an analysis of the Time-dependent cox model for the given dataset. I get an error in the PROC PHREG procedure for the given dataset model. Kindly suggest to me how to deal with the time-dependent cox model with the proper code to get a result. 77 proc phreg data=cox; 78 model End_Dur*EPI_Log(1) 79 run; ERROR 73-322: Expecting an =. proc phreg data=cox; model End_Dur*EPI_Log(1) run; I considered the EPI_stage (1,2) as Log '0'(Normal) and EPI_stage (3) as Log '1'(Event)  End_Dur in Years   ... View more

  Hi all,   I have a dataset in below format. I need to remove the duplicates by ID var1 and dt. The date variable is in varchar datatype. The date has a problem with same date but different timing. I have to remove the minimum timings on same date. In the below sample  ID 123 has two height value on the same date but I need only one value and that should be the max time. In the same scenario ID 321 has in wt category.   data have; input ID var1$ val dt$21.; cards; 123 ht 145 2019-09-14 09:06:00.0 123 wt 78 2019-08-12 06:43:42.0 123 bp 24.8 2019-09-30 14:33:47.0 123 ht 146 2019-09-14 13:38:45.0 321 ht 173 2019-12-06 11:20:53.0 321 wt 85 2019-08-16 09:54:39.0 321 ht 173 2019-09-17 13:15:22.0 321 wt 86 2019-08-16 10:50:03.0 ;  Thanks in advance! ... View more

Hi all,   The date column in the table full_patient_reg is varchar. I converted it to mmddyy10. format. When I try to export the entire table to SQL Server I receive an error like below.    data proj.full_patient_reg;  set full_patient_reg;  run;   NOTE: SAS variable labels, formats, and lengths are not written to DBMS tables. ERROR: CLI execute error: [Microsoft][ODBC SQL Server Driver]Datetime field overflow NOTE: The SAS System stopped processing this step because of errors. NOTE: There were 441255 observations read from the data set WORK.FULL_PATIENT_REG. WARNING: The data set PROJ.full_patient_reg may be incomplete. When this step was stopped there were 441254 observations and 20 variables. ERROR: ROLLBACK issued due to errors for data set PROJ.full_patient_reg.DATA.   Please help me to sort out the error.  Thanks in advance! ... View more