create a SAS data set by direct data entry with Missing Values

[Ronein]

Hello

In following example there are 2 missing values in  observation2 and 1 missing value in observation1.

There are 5 observations.

SAS fail to read it correctly.

May anyone correct the code below and explain

data weight3;     
infile datalines missover;   
input IDnumber $ Week1 Week16;    
WeightLoss2=Week1-Week16;        
cards;              
2477 195  163
2431 
2456 173  155
2412 135  116
     148  143
; 
Run;

[PeterClemmensen · Accepted solution]

Add an exact pointer to the IDNumber variable like this

data weight3;     
infile datalines missover;   
input IDnumber $ 1-4 Week1 Week16;    
WeightLoss2=Week1-Week16;        
cards;              
2477 195  163
2431 
2456 173  155
2412 135  116
     148  143
; 
Run;

[singhsahab]

data weight3;
input IDnumber $ 1-4 Week1 6-8 Week16 11-13;
WeightLoss2=Week1-Week16;
cards;
2477 195 163
2431
2456 173 155
2412 135 116
148 143
;
Run;