https://communities.sas.com/t5/SAS-Programming/How-to-seperate-date-format-20170203T222637-0000/m-p/781676#M249111 <P>i am validating a huge dataset where it has 8000 observations, may I know how can I extract the date from this format (<SPAN>20170203T222637+0000)?</SPAN></P><P>&nbsp;</P><P><SPAN>what i want: 20170203</SPAN></P><P><SPAN>what i have: </SPAN><SPAN>20170203T222637+0000</SPAN></P><P>&nbsp;</P><P><SPAN>is there another way to extract it at once for 8000 observations?</SPAN></P> Mon, 22 Nov 2021 07:22:21 GMT chenzinc 2021-11-22T07:22:21Z https://communities.sas.com/t5/SAS-Programming/How-to-seperate-date-format-20170203T222637-0000/m-p/781676#M249111 <P>i am validating a huge dataset where it has 8000 observations, may I know how can I extract the date from this format (<SPAN>20170203T222637+0000)?</SPAN></P><P>&nbsp;</P><P><SPAN>what i want: 20170203</SPAN></P><P><SPAN>what i have: </SPAN><SPAN>20170203T222637+0000</SPAN></P><P>&nbsp;</P><P><SPAN>is there another way to extract it at once for 8000 observations?</SPAN></P> Mon, 22 Nov 2021 07:22:21 GMT https://communities.sas.com/t5/SAS-Programming/How-to-seperate-date-format-20170203T222637-0000/m-p/781676#M249111 chenzinc 2021-11-22T07:22:21Z https://communities.sas.com/t5/SAS-Programming/How-to-seperate-date-format-20170203T222637-0000/m-p/781680#M249113 <P>Is this a character variable, or numeric with a B8601DX format assigned?</P> Mon, 22 Nov 2021 07:50:18 GMT https://communities.sas.com/t5/SAS-Programming/How-to-seperate-date-format-20170203T222637-0000/m-p/781680#M249113 Kurt_Bremser 2021-11-22T07:50:18Z