https://communities.sas.com/t5/SAS-Programming/how-to-convert-string-as-Wed-Sep-15-12-28-27-2010-to-datetime/m-p/72296#M15594 Thanks very much! Thu, 16 Sep 2010 05:28:14 GMT deleted_user 2010-09-16T05:28:14Z https://communities.sas.com/t5/SAS-Programming/how-to-convert-string-as-Wed-Sep-15-12-28-27-2010-to-datetime/m-p/72294#M15592 Hi, all!<BR /> <BR /> when i get the datetime stirng as 'Wed Sep 15 12:28:27 2010', how can i convert it to a datetime variable.<BR /> use the NLDATM function, you can give a format descriptor, then can get the datetime part, so, can i use a descriptor as '%a %b %d %H:%M:%S %Y', then can convert the string to a datetime variable? Wed, 15 Sep 2010 14:07:20 GMT https://communities.sas.com/t5/SAS-Programming/how-to-convert-string-as-Wed-Sep-15-12-28-27-2010-to-datetime/m-p/72294#M15592 deleted_user 2010-09-15T14:07:20Z https://communities.sas.com/t5/SAS-Programming/how-to-convert-string-as-Wed-Sep-15-12-28-27-2010-to-datetime/m-p/72295#M15593 Instead of using the NLDATM function, would something like this work?<BR /> <BR /> data _null_;<BR /> worddate = 'Wed Sep 15 12:28:27 2010';<BR /> numberdate = input(scan(worddate, 3, ' ')!!scan(worddate, 2, ' ')!!scan(worddate, 5, ' ')!!':'!!scan(worddate, 4, ' '), datetime18.);<BR /> put 'The SAS date ' numberdate 'is ' worddate;<BR /> run; Wed, 15 Sep 2010 15:05:27 GMT https://communities.sas.com/t5/SAS-Programming/how-to-convert-string-as-Wed-Sep-15-12-28-27-2010-to-datetime/m-p/72295#M15593 polingjw 2010-09-15T15:05:27Z https://communities.sas.com/t5/SAS-Programming/how-to-convert-string-as-Wed-Sep-15-12-28-27-2010-to-datetime/m-p/72296#M15594 Thanks very much! Thu, 16 Sep 2010 05:28:14 GMT https://communities.sas.com/t5/SAS-Programming/how-to-convert-string-as-Wed-Sep-15-12-28-27-2010-to-datetime/m-p/72296#M15594 deleted_user 2010-09-16T05:28:14Z