Hi, I am trying to read this (attached) pipe delimited file into SAS but  proc import throw's an error like this:   4936 proc import 4936! datafile="C:\Users\test\VisitSummary.csv" 4937 out=IRT 4938 dbms=csv replace ; 4939 4940 DELIMITER='|'; 4941 getnames=Yes; 4942 datarow=2; 4943 run; Unable to sample external file, no data in first 5 records. ERROR: Import unsuccessful. See SAS Log for details. NOTE: The SAS System stopped processing this step because of errors. NOTE: PROCEDURE IMPORT used (Total process time): real time 3.54 seconds cpu time 0.12 seconds   data step has no error but it always comes as 0 observation. 4944 data WORK.IRT_2 ; 4945 infile 'C:\Users\test\VisitSummary.csv' 4946 delimiter = '|' DSD  lrecl=32767 firstobs=2 missover; 4947 4948 input 4949 4950 TRIALID $ 4951 COUNTRYID $ 4952 Country $ 4953 SITEID $ 4954 Principal_Investigator $ 4955 Location_Name $ 4956 SUBJID $ 4957 SUBJID2 $ 4958 YOB $ 4959 Current_Status On_Treatment $ 4960 Active_Inactive $ 4961 Part $ 4962 Cohort $ 4963 Dose_Regimen $ 4964 Stratum $ 4965 Treatment_Name $ 4966 Visit_Name $ 4967 Visit_Date $ 4968 Treatment_Dose $ 4969 Kit_Numbers_Assigned $ 4970 Kit_Type_Description $ 4971 Lot_Numbers_Assigned $ 4972 Batch_Numbers_Assigned $ 4973 Kit_Verification_Date $ 4974 Username $ 4975 ; 4976 run; NOTE: The infile 'C:\Users\test\VisitSummary.csv' is: Filename=C:\Users\test\VisitSummary.csv, RECFM=V,LRECL=32767,File Size (bytes)=147679, Last Modified=13Jul2023:10:01:54, Create Time=29Nov2021:12:42:10 NOTE: 0 records were read from the infile 'C:\Users\test\VisitSummary.csv'. NOTE: The data set WORK.IRT_2 has 0 observations and 26 variables. NOTE: DATA statement used (Total process time): real time 3.32 seconds cpu time 0.01 seconds     Please help me read this file into SAS. I am not sure what mistake I am doing here. I have attached a copy of the file as well.   ... View more

Hi,    I need to add new variables Nextcycle, indicating if the subject has moved to next cycle or not, see my data below, if the EOT end of treatment is not null, then the row above the end of treatment should have the nextcycle value as 'No' or else its Yes. the row before the last.Id Should be 'No' if the end of treatment is present. The red column must be added to the new table (which I have manually added) Subject Visit Visit_date Nextcycle A001 Screening 10/27/2021 Yes A001 cycle1 12/1/2021 Yes A001 cycle2 1/17/2022 Yes A001 cycle3 2/28/2022 Yes A001 cycle4 4/19/2022 Yes A001 cycle5 5/30/2022 Yes A001 cycle6 7/11/2022 Yes A001 cycle7 8/22/2022 Yes A001 cycle8 10/3/2022 Yes A001 cycle9 11/17/2022 Yes A001 cycle10 1/2/2023 Yes A001 cycle11 2/15/2023 Yes A001 cycle12 3/27/2023 Yes A002 Screening 11/22/2022 Yes A002 cycle1 1/14/2023 Yes A002 cycle2 2/28/2023 Yes A003 Screening 9/30/2022 Yes A003 cycle1 11/2/2022 Yes A003 cycle2 11/23/2022 Yes A003 cycle3 1/2/2023 No A003 EOT 1/9/2023   A004 Screening 9/1/2022 Yes A005 cycle1 9/23/2022 Yes A005 cycle2 10/31/2022 No A005 EOT 11/2/2022   ... View more

My data looks like below, SubjectID instancename Dosing date Dosing interval (weeks) 0001 C1D1 1-Jan-22   0001 C2D1 22-Jan-22 3 0001 C3D1 12-Feb-22 3 0001 C4D1 26-Mar-22 6 0001 C5D1 7-May-22 6 0001 C6D1 19-Jun-22 6 0001 C7D1 31-Jul-22 6 0001 C8D1 11-Sep-22 6 0001 C9D1 23-Oct-22 6 0001 C10D1 4-Dec-22 6 0002 C1D1 14-Feb-23   0002 C2D1 7-Mar-23 3 0002 C3D1 28-Mar-23 3 0003 C1D1 10-Jan-22   0003 C2D1 2-Feb-22 3 0003 C3D1 22-Feb-22 3 0003 C4D1 6-Apr-22 6 0003 C5D1 17-May-22 6 0003 C6D1 29-Jun-22 6 0004 C1D1 29-Mar-23   0005 C1D1 14-Apr-23   and so no.... for each subjectID the visit are upto 15 cycles and I would like to calculate the future dates based on the Dosing interval, example: I need calculate the dates for C4D1 and beyond for subject and for 0004 C2D1 and beyond.  also if there is end of treatment date in between then I wanted to stop the calculation for future visits, please help me on how to code this. If possible I would like to use the previous cycle dates for calculation rather than the C1D1 if prior cycle is not missing.  ... View more

I am creating a output using proc report, and below is the codes. I have 20 variables, for which i have to repeat the same step (compute block).   proc report data = final_lab; column subject RFSTDAT_DER_RAW SCREEN  C1D1 C1D3 C1D8 C1D15 C1D22 C1D29 C1D36 C2D1 C2D3 C2D8 C2D15 C2D22 C2D29 C2D36 C3D1 C3D8 C3D15 C3D22 C4D1 C4D8 C4D15 C4D22 C5D1 C6D1 C7D1 C8D1 C9D1 C10D1 CXD1 ; define Subject                          / Display 'Subject' ; Define RFSTDAT_DER_RAW / Display 'First Dose Date'; Define Screen                         / Display 'Screening'; Define C1D1                           / Display 'Cycle 1 Day1' ; compute C1D1; if C1D1 = 'ND' then call define('C1D1 ', "style", "style=[background=grey]"); else if C1D1 LE 1 then call define('C1D1 ', "style", "style=[background=lightyellow]"); else if C1D1 >= 1 and C1D1 =<2 then call define('C1D1 ', "style", "style=[background=lightgreen]"); else if C1D1 >= 3 and C1D1 < 6then call define('C1D1 ', "style", "style=[background=orange]"); else if C1D1 >= 6 and C1D1 < 8 then call define('C1D1 ', "style", "style=[background=lightblue]"); else if C1D1 >= 8 then call define('C1D1 ', "style", "style=[background=red]"); endcomp; run;   this compute block must be repeated for all the rest of the variable  (C1D3 C1D8 C1D15 C1D22 C1D29 C1D36 C2D1 C2D3 C2D8 C2D15 C2D22 C2D29 C2D36 C3D1 C3D8 C3D15 C3D22 C4D1 C4D8 C4D15 C4D22 C5D1 C6D1 C7D1 C8D1 C9D1 C10D1 CXD1 ) ,tried doing do loop but the variable name is not in sequence order so I was unbale to do so.   is there a way to automate this for the reminder of the variable? ... View more