Hi all,
I trying to create a data set using datalines with a comma delimiter.
Here is a snip of my code:
data tv_; format visitnum visitdy best12.; length visit $100 tvstrl tvenrl $200; infile datalines delimiter=',';
input VISITNUM VISIT $ VISITDY TVSTRL $ TVENRL $ ; datalines;
-21,Screening,-1,INFORMED CONSENT SIGNED,COMPLETION OF SCREENING ASSESSMENTS 101,Cycle 1 Day 1,1,Beginning of Cycle 1 Day 1 Assessments,Completion of Cycle 1 Day 1 Assessments 108,Cycle 1 Day 8,8,Beginning of Cycle 1 Day 8 Assessments,Completion of Cycle 1 Day 8 Assessments 115,Cycle 1 Day 15,15,Beginning of Cycle 1 Day 15 Assessments,Completion of Cycle 1 Day 15 Assessments 201,Cycle 2 Day 1,29,Beginning of Cycle 2 Day 1 Assessments,Completion of Cycle 2 Day 1 Assessments
However, this first line is reading in werid and I'm not sure why.
Log errors I'm getting are:
NOTE: Invalid data for VISITDY in line 2968 5-13. RULE: ----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8----+----9----+----0 2968 -21,Screening,-1,INFORMED CONSENT SIGNED,COMPLETION OF SCREENING ASSESSMENTS VISITNUM= VISITDY= VISIT=-21 TVSTRL=-1 TVENRL=INFORMED CONSENT SIGNED _ERROR_=1 _N_=1 NOTE: Invalid data for VISITDY in line 3032 40-90. NOTE: LOST CARD.
I've attached image of what the dataset created look like 🙂 Help appreciated!!
... View more