06-08-2017 11:32 AM
Pictured in the attachment is my summary table, created using the wizard in SAS Enterprise Guide. In my data set, the Time fields are all formatted to look like 03:08:12, 12:23:36, 19:12:46, etc. However, when I show them in the Summary Table as AVG's they lose their time formatting. How can I alter the format in the Time variables so they show in the origional time format and look like the examples listed above?
06-08-2017 11:34 AM - edited 06-08-2017 11:34 AM
Post your data or some of it in the form of a datatep, most users in here will not download files
06-08-2017 01:31 PM
In the Summary Table wizard page 2, bottom right, this is where you can specify a format like TIME8.
If you need to have different formats depending on the column, you have to use just the Summary Tables.