Help using Base SAS procedures

Attribute issue of Datetime when exporting to Excel

Reply
Qi
N/A
Posts: 1

Attribute issue of Datetime when exporting to Excel

In a SAS dataset, I used "datetime." to format a field. And the field was Numeric. Then I exported that dataset to Excel 2003, the format of that field looked the same as what it was in SAS. However, that column in Excel was unchangeable. Looks like the attribute was changed to String, not Date after exporting. I need to continue to work on that column in Excel, but now I can't. Please help!

New Contributor
Posts: 4

Re: Attribute issue of Datetime when exporting to Excel

You did not say how you were exporting the data to Excel (e.g. Export wizard, proc export, or ODS tagsets.execlxp). However, if you read pages 10 and 11 of the paper below, it will explain a work-around for the tagsets.excelxp approach. If you are using a different method, it will give you hint of what the issues are:

http://www2.sas.com/proceedings/forum2008/036-2008.pdf

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