https://communities.sas.com/t5/New-SAS-User/Formatting-time-from-excel-to-SAS-9-4/m-p/539847#M7135 <P>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).</P> Sat, 02 Mar 2019 10:13:11 GMT Kurt_Bremser 2019-03-02T10:13:11Z https://communities.sas.com/t5/New-SAS-User/Formatting-time-from-excel-to-SAS-9-4/m-p/539822#M7129 <P>Hi,</P><P>&nbsp;</P><P>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.&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P> Sat, 02 Mar 2019 01:05:43 GMT https://communities.sas.com/t5/New-SAS-User/Formatting-time-from-excel-to-SAS-9-4/m-p/539822#M7129 sasuser94 2019-03-02T01:05:43Z https://communities.sas.com/t5/New-SAS-User/Formatting-time-from-excel-to-SAS-9-4/m-p/539847#M7135 <P>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).</P> Sat, 02 Mar 2019 10:13:11 GMT https://communities.sas.com/t5/New-SAS-User/Formatting-time-from-excel-to-SAS-9-4/m-p/539847#M7135 Kurt_Bremser 2019-03-02T10:13:11Z https://communities.sas.com/t5/New-SAS-User/Formatting-time-from-excel-to-SAS-9-4/m-p/539852#M7137 <P>Us a fixed length format.&nbsp; Means is the average of all observations being evaluated.&nbsp; that is why as a programmer you need to take control of your wants and sometimes force them into a format.</P> Sat, 02 Mar 2019 14:20:09 GMT https://communities.sas.com/t5/New-SAS-User/Formatting-time-from-excel-to-SAS-9-4/m-p/539852#M7137 VDD 2019-03-02T14:20:09Z