BookmarkSubscribeRSS Feed
RADAGBE9
Fluorite | Level 6

I'm trying to create an excel Pivot Table from a SAS dataset located in  permanent library. The issue I'm having is the Date column is not converting correctly. It gives me a warning: 

"Date and time values will not be converted."

When I continue, it creates a pivot table but the date column changes to meaningless values.

 

Any assistance on this please?

 

Thanks

 

3 REPLIES 3
FredrikE
Rhodochrosite | Level 12

Is it the same if you just export the data as a table, not a pivot?

 

If so you can create a pivot from the table in excel instead?

 

//fredrik

RADAGBE9
Fluorite | Level 6

I was trying to avoid the row limitation in excel and that's why I decided to keep my file in SAS and build the pivot table off of it.

 

Thanks

KatS_SAS
SAS Employee

It sounds like you were opening the SAS data set directly from your local file system.   In order to keep date and/or time values formatted in pivot tables, you need to open it from a SAS library, either defined in SAS Management Console or a simple LIBNAME statement in the SAS Programs window. 

sas-innovate-2024.png

Don't miss out on SAS Innovate - Register now for the FREE Livestream!

Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.

 

Register now!

Discussion stats
  • 3 replies
  • 1172 views
  • 0 likes
  • 3 in conversation