I received an excell file from a company and made corrections to it. The
dates that came from the company are formatted as "general", but they display
as MM/DD/YYYY. When we added dated to the file, (MM/DD/YYYY) they were added
as the Date format *M/D/YY. When I tried to change them to general, they
displayed as a number, not a date. When I import the file into SAS, they are
read as numeric variables. Is there any way to format all of the dates in
the spread sheet so that they are read as the same variable type by SAS?
THANK YOU!
--
CD