Character date to numeric

sri1 — Thu, 20 Mar 2025 12:04:32 GMT

Hi all,

I have character dates as in below format , is there any way I can convert to numeric. I tried using date11. but didn't work.

data test;
test_date1 = "16 June 2023";

converted1 = input(test_date1, date11.);

format converted1 date9.;
put test_date1= converted1=;
run;

Thanks

Re: Character date to numeric

PaigeMiller — Thu, 20 Mar 2025 12:15:20 GMT

data have;
    test_date1="16 June 2023";
run;
data want;
    set have;
    num_test_date1=input(test_date1,anydtdte32.);
    format num_test_date1 date9.;
run;

topic Character date to numeric in SAS Programming

Character date to numeric

Re: Character date to numeric