SAS Office Analytics, SAS Add-In for Microsoft Office, and other integrations

SAS Add-in - Proper format of date for Drill-Thru data in Pivot table

Reply
New Contributor
Posts: 3

SAS Add-in - Proper format of date for Drill-Thru data in Pivot table

We have several pivot tables using the Add-in where when selecting a cell to drill-thru for details will only provide the date by default as a number.

We must reformat it in the worksheet each time to display the date properly.

If the variable is display in the pivot table, it is displayed as date.

What is missing to enable auto formatting for the cell drill-thru detail to provided date variables as dates ?

What format (or not) should the date variables be ?
We have contacted tech support on this question and never recieved an response that has solved our problem. Message was edited by: jrmathieu
New Contributor
Posts: 3

Re: SAS Add-in - Proper format of date for Drill-Thru data in Pivot table

Is there any best practices to use for dates within the Add-in, Excel and pivot tables ?
Thank you,
John Mathieu
Ask a Question
Discussion stats
  • 1 reply
  • 153 views
  • 0 likes
  • 1 in conversation