converting a date in sas

[sap1958]

data Customer2;
set Customer1;
format TotalSalary Dollar10.2;
format Birthdate MMDDYY10.;
run;

In Customer1 the date is in this format 22AUG1966:00:00:00
I used this formula to convert the date to the desired format of 08/22/1966. It would be the same for other dates. However the code is not converting the date as I want. Any ideas as to why.

 

[MatthiasB]

Just to make sure: the SAS format basically changes the >output< format, it does not change the content of the variable. You read in a datetime, you want date only displayed. Add line "BirthDate = datepart(BirthDate);" and you should be set.

Cheers,
Matthias