character datetime to datetime

[Orange4]

hello - i have been given a dataset called "char_dates" with a variable called "date_added" formatted as $CHAR20. and would like it converted to datetime.

examples of date_added entries:  

3/21/2019 17:05 EDT

3/7/2019 18:10 EST

I have attempted the conversion with the following, but have been unsuccessful:

data num_dates;

set char_dates;

new_date = input(date_added, anydtdtm19.);

format new_date datetime19.;

run;

Any advice?

Mike

[PaigeMiller]

Unsuccessful? Please explain. What happens that is unsuccessful? Why do you think the result is unsuccessful? Are there error messages (if so, please show us)?

[Orange4]

my apologies - no error is created; rather the output is missing / null

[PaigeMiller · Accepted solution]

Get rid of the alphabetic characters EDT or EST

new_date = input(compress(date_added,,'a'), anydtdtm19.);

[Orange4]

brilliant - thanks so much!