If you create a data item using the DATEPART function, you might see the following error when you attempt to use that data item in SAS Web Report Studio:

ERROR: Function DATEPART requires a numeric expression as argument 1

To resolve this error, recreate the data item expression using the physical data rather than the business data. For example, this is how you would create the data item expression in SAS Information Map Studio:

1. Open the data item's properties.

Note: The data item should be classified as a Category.

2. On the Definition tab, click Edit to open the Expression Editor dialog box.
3. Make sure the Type is set to Numeric.
4. Clear the Expression Text field.
5. Insert DATEPART from the list of Functions. Your expression will look like this:

DATEPART(<timestampValue>)
6. Click the Data Sources tab.
7. Open the Physical Data tree, and select the date/time column that you want to use in the data item expression.
8. Click Add to Expression.
Your expression might look like this:
DATEPART(<<SASHELP.closeDate>>)
9. Click OK to save and close the Expression Editor.
10. Click OK to save and close the Properties.

Operating System and Release Information