@sas940 wrote:
THank you. I cannot comment on the "why" between the 11.1 as that is simply what I see. My apologies
Sometimes it is worth investigating such oddities as it could indicate that the actual "original" value was something else and the values you see now have been modified, and maybe not in your best interest. An 11.1 informat could have truncated values or moved a least significant digit to a decimal value which was later removed.
You might want to look at the result of this example code for the values of X. The last could well have been a date in YYMMDD format but gets mangled by an unusual informat.
data example;
input x 11.1;
datalines;
1
12
312
0312
20312
200312
0200312
20200312
;
If you don't need to add one or more decimal positions to a value when read because the source data does not have any decimal but the value should have some then an Informat with a decimal is inappropriate.
... View more