Overview

Data items that have an Elapsed Time format do not display formatted values in data-driven content objects. This problem occurs even though the values are formatted as expected in other objects such as list tables. Typically, this problem occurs when the data is imported from Microsoft Excel and certain time formats are applied to the column. Here is an example:

1. In Microsoft Excel, the col_time column is formatted as h:mm.
   
2. In SAS Visual Analytics, the col_time data item is a Category with an Elapsed Time (TIME8.) format.
   
3. When you add col_time to a data-driven content object, the col_time values are unformatted. 
   

The same values are formatted as expected in a list table.

Workaround

To display formatted time values in data-driven content objects, perform these steps:

1. At the top of the Data pane, select New data item ► Calculated item.
2. In the menu bar of the New Calculated Data Item window, select Datetime from the Result Type drop-down list.
3. In the left pane, select Operators.
4. From Numeric (advanced) category, drag over TreatAs.
5. In the formula, select _Datetime_ from the drop-down list
6. In the left pane, select Data Items.
7. From the list of Data Items, drag the time data item over to the formula.
8. Name and save the new data item.
9. On the Data pane, the default format for the new data item is Date, Time (DATETIME0). Click the Edit button next to the Format box to open the Format dialog box.
10. Change the format to Time, and then select the preferred appearance from the Format drop-down list at the bottom of the dialog box. Click OK to save your changes.
11. Add the new data item to the data-driven content object. The values should now be formatted as time.

 

Operating System and Release Information

Product Family	Product	System	Product Release		SAS Release
			Reported	Fixed*	Reported	Fixed*
SAS System	SAS Visual Analytics	Cloud Foundry	8.3		Viya
		Linux for x64	8.3		Viya
		Microsoft® Windows® for x64	8.3		Viya

* For software releases that are not yet generally available, the Fixed Release is the software release in which the problem is planned to be fixed.

---

Data items that have an Elapsed Time format do not display formatted values in data-driven content objects. This problem occurs even though the values are formatted as expected in other objects such as list tables. Typically, this problem occurs when the data is imported from Microsoft Excel and certain time formats are applied to the column.

Type:	Problem Note
Priority:	medium

Date Modified:	2019-07-26 13:00:50
Date Created:	2019-07-24 15:30:33