SAS Procedures

Help using Base SAS procedures
BookmarkSubscribeRSS Feed
dwknepper
Calcite | Level 5

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. 

1 REPLY 1

sas-innovate-white.png

Join us for our biggest event of the year!

Four days of inspiring keynotes, product reveals, hands-on learning opportunities, deep-dive demos, and peer-led breakouts. Don't miss out, May 6-9, in Orlando, Florida.

 

View the full agenda.

Register now!

What is Bayesian Analysis?

Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

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