Formatting time from excel to SAS 9.4

[sasuser94]

Hi,

I am fairly new to SAS 9.4 and I'm trying to format time that is equivalent to my times in the excel sheet. I imported the data and ran a proc print and it showed the times i wanted in 24 hour like i wanted but when i run a proc means to get the average time it displays a several digit number. I was wondering if someone could help me with coding this. 

[Kurt_Bremser]

If the means procedure does not carry over the format to the average in the output, I would let it create a dataset and then apply the format to the variable with proc datasets (or a data step if performance is not an issue).

[VDD]

Us a fixed length format.  Means is the average of all observations being evaluated.  that is why as a programmer you need to take control of your wants and sometimes force them into a format.