DATA Step, Macro, Functions and more

Reading data lines

Accepted Solution Solved
Reply
Frequent Contributor
Posts: 142
Accepted Solution

Reading data lines

data sampled;
infile datalines truncover;
 input trtgrp subject time  ipred ;
   datalines;
1 1 0 0
;
run;

Log
 NOTE: Invalid data for subject in line 78 3-5.
 RULE:      ----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8----+----9----+----0                     
 
 78  CHAR   1 1.0  0                                                                        
     ZONE   32303223222222222222222222222222222222222222222222222222222222222222222222222222
     NUMR   10190000000000000000000000000000000000000000000000000000000000000000000000000000
 trtgrp=1 subject=. time=0 ipred=. _ERROR_=1 _N_=1
 NOTE: The data set WORK.SAMPLED has 1 observations and 4 variables.
 NOTE: DATA statement used (Total process time):
       real time           0.00 seconds
       cpu time            0.01 seconds

I have a very short data lines program and am using truncover, but I get an error that subject and ipred is missing.  Can anyone tell me why subject and ipred are missing?   All of the data are numeric.


Accepted Solutions
Solution
Friday
Super User
Posts: 2,049

Re: Reading data lines

Posted in reply to jacksonan123

Your code worked fine when i tested

data sampled;
infile datalines truncover;
input trtgrp subject time ipred ;
datalines;
1 1 0 0
;
run;

proc print noobs;run;

Log:

832 data sampled;
833 infile datalines truncover;
834 input trtgrp subject time ipred ;
835 datalines;

NOTE: The data set WORK.SAMPLED has 1 observations and 4 variables.
NOTE: DATA statement used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds

 

SAS Output

trtgrp subject time ipred
1 1 0 0

View solution in original post


All Replies
Solution
Friday
Super User
Posts: 2,049

Re: Reading data lines

Posted in reply to jacksonan123

Your code worked fine when i tested

data sampled;
infile datalines truncover;
input trtgrp subject time ipred ;
datalines;
1 1 0 0
;
run;

proc print noobs;run;

Log:

832 data sampled;
833 infile datalines truncover;
834 input trtgrp subject time ipred ;
835 datalines;

NOTE: The data set WORK.SAMPLED has 1 observations and 4 variables.
NOTE: DATA statement used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds

 

SAS Output

trtgrp subject time ipred
1 1 0 0
Frequent Contributor
Posts: 142

Re: Reading data lines

Posted in reply to novinosrin

I think that for some reason the code was in an area that I had commented.  When I moved the code it did work ok.

☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 51 views
  • 0 likes
  • 2 in conversation