How can I transform a column into date format?

Question

One of my date column doesn't read in date format, but I need to use the function WEEKDAY() on it. How can I transform the data format of that column into date format?

UPDATE: It is a csv file, following is one of the rows

01OCT2007,4.92,7.75

Answer 1

How about this (where foo.txt contains your data without column names)

data foo;
    infile "foo.txt" delimiter=',';
    informat a date.;
    format a date.;
    input a b c;
run;

?

psj