How do I format the variables using the Summary Table Wizard?

[Amber_Nicole94]

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?

[PeterClemmensen]

Post your data or some of it in the form of a datatep, most users in here will not download files 🙂

[BrunoMueller]

Hi

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.