I have a big dataset with dates in the char format dd/mm/yyyy (e.g., 07/06/2014) I would like to convert into SAS format. I tried using input (variable_name, MMDDYY10.) but with the following issues:

• some dates are missing (while not in the original dataset)
• dates do not correspond to the original: e.g., 07/06/2014 becomes 06JUN2014.

I suppose there are spaces in the original .csv file.

Can anyone help me please?

Thank you in advance!