Hi, I have a series of character variables that are actually dates. I would like to get them into date format, but don't know how. 😞
They're currently in the format 10/2/2000. Keeping that format is fine. Knowing how to do it in a data step would be most convenient, but proc is fine too. Thanks for any help!
As I haven't any test data in the form of a datastep, I am just guessing here:
data want (drop=i); set have; array cd{3} char_date1 char_date2 char_date3; array nd{3} num_date1 num_date2 num_date3; do i=1 to 3; nd{i}=input(cd{i},ddmmyy10.); end; format num_date: date9.; run;
I assumed all your character dates were char_date1, 2 etc. and you wanted num_date1, 2 etc.
in future please post test data in the form of a datastep so we have something to run rather than guessing.
As I haven't any test data in the form of a datastep, I am just guessing here:
data want (drop=i); set have; array cd{3} char_date1 char_date2 char_date3; array nd{3} num_date1 num_date2 num_date3; do i=1 to 3; nd{i}=input(cd{i},ddmmyy10.); end; format num_date: date9.; run;
I assumed all your character dates were char_date1, 2 etc. and you wanted num_date1, 2 etc.
in future please post test data in the form of a datastep so we have something to run rather than guessing.
⏰
Today is the last day to save with the early bird rate! Register today for just $695 - $100 off the standard rate.
Plus, pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
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.