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.
... View more