BookmarkSubscribeRSS Feed
GuillermoPH
Obsidian | Level 7

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... 😞

 

columnas.png

 

sample.png

 

Please, any help will be much appreciated!

 

Thanks in advance, regards;

1 REPLY 1
MikeJenista
SAS Employee

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.  

sas-innovate-wordmark-2025-midnight.png

Register Today!

Join us for SAS Innovate 2025, our biggest and most exciting global event of the year, in Orlando, FL, from May 6-9. Sign up by March 14 for just $795.


Register now!

Tips for filtering data sources in SAS Visual Analytics

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.

Discussion stats
  • 1 reply
  • 1093 views
  • 0 likes
  • 2 in conversation