https://communities.sas.com/t5/SAS-Programming/Date-Format-yyyy/m-p/801295#M315345 <P>Hi,</P> <P>&nbsp;</P> <P>I want to import a date-column that contains the year (yyyy). How is it possible, to import this data with a date format instead of this char-format? Thank you for helping me!</P> <P>&nbsp;</P> <PRE><CODE class=" language-sas">data test; FORMAT year $CHAR22.; input year ; datalines; [...]</CODE></PRE> Thu, 10 Mar 2022 12:09:14 GMT Konkordanz 2022-03-10T12:09:14Z https://communities.sas.com/t5/SAS-Programming/Date-Format-yyyy/m-p/801295#M315345 <P>Hi,</P> <P>&nbsp;</P> <P>I want to import a date-column that contains the year (yyyy). How is it possible, to import this data with a date format instead of this char-format? Thank you for helping me!</P> <P>&nbsp;</P> <PRE><CODE class=" language-sas">data test; FORMAT year $CHAR22.; input year ; datalines; [...]</CODE></PRE> Thu, 10 Mar 2022 12:09:14 GMT https://communities.sas.com/t5/SAS-Programming/Date-Format-yyyy/m-p/801295#M315345 Konkordanz 2022-03-10T12:09:14Z https://communities.sas.com/t5/SAS-Programming/Date-Format-yyyy/m-p/801299#M315346 <P>Just remove the FORMAT statement. SAS will automatically read this as numeric. To make a SAS date value out of it, you have to use the MDY function and decide which day of the year you want to assume.</P> Thu, 10 Mar 2022 12:32:42 GMT https://communities.sas.com/t5/SAS-Programming/Date-Format-yyyy/m-p/801299#M315346 Kurt_Bremser 2022-03-10T12:32:42Z