BookmarkSubscribeRSS Feed
☑ This topic is solved. Need further help from the community? Please sign in and ask a new question.
sri1
Obsidian | Level 7

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

1 ACCEPTED SOLUTION

Accepted Solutions
PaigeMiller
Diamond | Level 26
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;
--
Paige Miller

View solution in original post

1 REPLY 1
PaigeMiller
Diamond | Level 26
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;
--
Paige Miller
How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 1 reply
  • 636 views
  • 2 likes
  • 2 in conversation