06-19-2018 12:34 PM
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...
Please, any help will be much appreciated!
Thanks in advance, regards;
06-26-2018 11:59 AM
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.