Help using Base SAS procedures

Proc Report putting date into excel

Reply
Occasional Contributor
Posts: 5

Proc Report putting date into excel

I am using PROC REPORT to generate an xls file using the ExcelXP tagset.  When I open the .xls file via Excel version 2010, the date appears as a date, but Excel does not recognize the data as a date.  How can I pass the date format to excel. I have tried multiple styles and formats and have been unable get Excel to see the cell as a date.  I would like to be able to use sort and filter functions in Excel on the date field, but I am unable to. 

Super User
Super User
Posts: 9,599

Re: Proc Report putting date into excel

Posted in reply to dwknepper
Ask a Question
Discussion stats
  • 1 reply
  • 146 views
  • 0 likes
  • 2 in conversation