topic Re: SAS VA report detailed data exporting as excel showing incorrect value in date fields in SAS Visual Analytics

SAS VA report detailed data exporting as excel showing incorrect value in date fields

pgadde — Fri, 12 Jul 2019 20:54:51 GMT

Hi,

When i export the SAS VA report which has tabular data into EXCEL using detailed data option. The date column is showing SAS date instead of the actual value. Is this a bug?

Re: SAS VA report detailed data exporting as excel showing incorrect value in date fields

SASKiwi — Fri, 12 Jul 2019 22:21:17 GMT

Please post an example of what is a "SAS date" and what is an "actual value". I suspect this is just another example of Excel guessing what data format you want and changing it accordingly.

Re: SAS VA report detailed data exporting as excel showing incorrect value in date fields

pgadde — Mon, 15 Jul 2019 19:54:53 GMT

Hi,

Below is the value of the date when exported as formatted

April 2, 2019 12:00:00 AM

But when exported as detailed the value in that date column (Service date) changes to 43556
and it is constant for all the rows.

Re: SAS VA report detailed data exporting as excel showing incorrect value in date fields

Madelyn_SAS — Mon, 15 Jul 2019 20:21:14 GMT

When you export detailed data, do you have the Formatted check box enabled as well?

Re: SAS VA report detailed data exporting as excel showing incorrect value in date fields

pgadde — Tue, 16 Jul 2019 16:11:46 GMT

Actually i found the solution to this issue. I need to select both the formatted and detailed data check boxes for the data to be in correct format. If I select only detailed then the date formatting is gone.

Re: SAS VA report detailed data exporting as excel showing incorrect value in date fields

SASKiwi — Tue, 16 Jul 2019 20:45:22 GMT

Please update this post as answered since you have found a solution.