while reading data the column PF is empty (Blank) but dist and day is populated , hence the data for dist is read into PF column and data for Day into Dist.
You are using list mode to read the data so you need to represent the missing values with a period.
If the data is actually in fixed columns (hard to tell from your post since you pasted the code/data directly into the mesage instead of using the Insert Code or Insert SAS Code icons) then read it using column based or formatted input style instead. Then the blank spaces will be treated as indicating a missing value instead of just padding.
Display of the final output showing time as 06:25 instead of 6.25 using format does not work.
Not sure if there is a SAS format to display hours and minutes separated by period instead of colon. You could build your own picture format using PROC FORMAT.
... View more