Trouble with date format on data imported from SQL Server to SAS Server

[weeburn]

Hi,

I have a dataset in SQL server. The date format (DATE_TYPE) in the SQL server has been correctly set as "date". When the data are imported into the SAS Server, the data is recognised as "Character". The data is in the format "yyyy-mm-dd".

I wonder if it is possible to set the date format in the SAS as YYMMDDD10.

Cheers. 

[SASJedi]

What is the process or SAS code are you using to import the data into SAS?