Desktop productivity for business analysts and programmers

MS SQL Date to SAS DATE

Accepted Solution Solved
Reply
Contributor
Posts: 33
Accepted Solution

MS SQL Date to SAS DATE

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

 


Accepted Solutions
Solution
‎12-15-2017 05:16 AM
Trusted Advisor
Posts: 1,839

Re: MS SQL Date to SAS DATE

[ Edited ]

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


All Replies
Solution
‎12-15-2017 05:16 AM
Trusted Advisor
Posts: 1,839

Re: MS SQL Date to SAS DATE

[ Edited ]

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! 

Super User
Posts: 10,534

Re: MS SQL Date to SAS DATE

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.

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
How to convert datasets to data steps
How to post code
Trusted Advisor
Posts: 1,839

Re: MS SQL Date to SAS DATE

Posted in reply to KurtBremser

Indeed @KurtBremser! 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 Smiley Happy

☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 3 replies
  • 204 views
  • 2 likes
  • 3 in conversation