BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
Amarnadh
Obsidian | Level 7

Hi Team,

 

When import the data from MS SQL  Date field (with Date type) to SAS , system converting automatically as Character type, kindly let me know is there any setting which i am missing 

 

Regards,

Amarnadh

 

1 ACCEPTED SOLUTION

Accepted Solutions
JuanS_OCS
Azurite | Level 17

Hello @Amarnadh,

 

what version of SQL Server have you got? And How are you connecting to it (ODBC, OLEDB, Access to SQL Server)?

 

There is a known issue in SQL Server 2008 if connecting with OLE DB http://support.sas.com/kb/39/188.html

It is also know for the same, connecting with ODBC: http://support.sas.com/kb/40/080.html

 

Hope it helps! 

View solution in original post

3 REPLIES 3
JuanS_OCS
Azurite | Level 17

Hello @Amarnadh,

 

what version of SQL Server have you got? And How are you connecting to it (ODBC, OLEDB, Access to SQL Server)?

 

There is a known issue in SQL Server 2008 if connecting with OLE DB http://support.sas.com/kb/39/188.html

It is also know for the same, connecting with ODBC: http://support.sas.com/kb/40/080.html

 

Hope it helps! 

Kurt_Bremser
Super User

Do a google search for "sas import MS SQL date" and see if the results are helpful. The two KB articles mentioned by @JuanS_OCS will also pop up, and several related posts here on the communities.

JuanS_OCS
Azurite | Level 17

Indeed @Kurt_Bremser! I repeatedly suggest diverse SAS communities colleagues to google or search at support.sas.com.

 

I think that should be able to help many people, even quicker than what we can 🙂

hackathon24-white-horiz.png

2025 SAS Hackathon: There is still time!

Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!

Register Now

Creating Custom Steps in SAS Studio

Check out this tutorial series to learn how to build your own steps in SAS Studio.

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
  • 3 replies
  • 1909 views
  • 2 likes
  • 3 in conversation