Exploring, predicting and reporting with SAS Visual Analytics and SAS Visual Statistics

Trouble keeping date format when exporting to Excel

Reply
Occasional Contributor
Posts: 15

Trouble keeping date format when exporting to Excel

Hi SAS VA community!

 

I'm dealing with a situation that is driving me nuts: when I choose to export data from a VA report to Excel, it messes up with date formats.

 

For example, I have this graph I need to export in order to work with the data, it has a date variable named FECTERMINADO which in EG I set its format as datetime27.6; in VA it is formatted as MMMYYYY. When I export it to Excel I get a bunch of ##'s. I've tried everything but I keep failing on keeping the format... Smiley Sad

 

columnas.png

 

sample.png

 

Please, any help will be much appreciated!

 

Thanks in advance, regards;

SAS Employee
Posts: 31

Re: Trouble keeping date format when exporting to Excel

Posted in reply to GuillermoPH

Just a quick sanity check: did you try expanding the excel column with the ### values in it?  I have sometimes had excel represent values that way until I expand the column width enough to show the full values.  

Ask a Question
Discussion stats
  • 1 reply
  • 95 views
  • 0 likes
  • 2 in conversation