topic Re: create a SAS data set by direct data entry with Missing Values in SAS Programming

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

Ronein — Tue, 16 Oct 2018 08:18:06 GMT

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;

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

PeterClemmensen — Tue, 16 Oct 2018 08:42:25 GMT

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;

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

singhsahab — Tue, 16 Oct 2018 09:39:48 GMT

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;