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?
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.
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.
When you export detailed data, do you have the Formatted check box enabled as well?
-------------------------------------------------------------------------
Four tips to remember when you contact SAS Technical Support
Creating Beautiful Reports
SAS Visual Analytics Learning Center
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.
Please update this post as answered since you have found a solution.
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!See how to use one filter for multiple data sources by mapping your data from SAS’ Alexandria McCall.
Find more tutorials on the SAS Users YouTube channel.