@jenim514 wrote:
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!!
Please repost your code in a code box opened using the forum's {I} icon.
When I copy the text posted above into my editor I get a blank line between datalines; and your -21 value. So you may have some invalid character in your data that the forum windows removes/ replaces. If there is a blank line in your data then the input is getting confused with the end of line character from the blank line since you didn't provide any of the options to control flow when an end of line is encountered before the complete input statement is read such as MISSOVER, TRUNCOVER and is defaulting to FLOWEVER. So the -21 is read as the second variable, VISIT, and then encounters "Screening" as the third variable and since VISITDY is numeric you get invalid data.
Remove the blank line. Or add TRUNCOVER to the infile statement, though you'll get an observation with missing values for all records.
... View more