I am having trouble with a data set that I imported as a txt file. There are missing values represented with blanks, but sas is filling those values in with the next available value instead of ".". For example, the first line of observations is "1000 203 82 56 3.599999905 4.309999943 Buckingham 46 female 62 121 medium 118 59 29 38 720"; as you can see, there is a missing value between 59 and 29. However, sas scooted the 29 over into that cell instead of putting ".", and instead put "." in the last column for that observation. My data step is as follows:
data diabetes;
infile diabetes DLM="09"x missover firstobs=2;
input
ID
chol
stab_glu
hdl
ratio
glyhb
location $
age
gender $
height
weight
frame $
BP_1s
BP_1d
BP_2s
BP_2d
waist
hip
time_ppn;
run;
Am I missing something in my code? I thought that missover would tell sas to put "." in for blanks, but it doesn't seem to be working 😞 help would be much appreciated!!!
P.S. I attached the txt file below in case maybe the issue is something with the data file itself.