https://communities.sas.com/t5/SAS-Enterprise-Guide/Trouble-with-date-format-on-data-imported-from-SQL-Server-to-SAS/m-p/887477#M43402 <P>What is the process or SAS code are you using to import the data into SAS?</P> Wed, 02 Aug 2023 12:29:51 GMT SASJedi 2023-08-02T12:29:51Z https://communities.sas.com/t5/SAS-Enterprise-Guide/Trouble-with-date-format-on-data-imported-from-SQL-Server-to-SAS/m-p/887447#M43401 <P>Hi,</P><P>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".</P><P>&nbsp;</P><P>I wonder if it is possible to set the date format in the SAS as&nbsp;YYMMDDD10.</P><P>&nbsp;</P><P>Cheers.&nbsp;</P> Wed, 02 Aug 2023 08:13:38 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Trouble-with-date-format-on-data-imported-from-SQL-Server-to-SAS/m-p/887447#M43401 weeburn 2023-08-02T08:13:38Z https://communities.sas.com/t5/SAS-Enterprise-Guide/Trouble-with-date-format-on-data-imported-from-SQL-Server-to-SAS/m-p/887477#M43402 <P>What is the process or SAS code are you using to import the data into SAS?</P> Wed, 02 Aug 2023 12:29:51 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Trouble-with-date-format-on-data-imported-from-SQL-Server-to-SAS/m-p/887477#M43402 SASJedi 2023-08-02T12:29:51Z