When I import an Excel file into SAS it gives me this date fromat:
12OCT2008, (DATE9 format and informt).
I want to convert that date as it exist now in the file (i.e. I don't want to convert it during the
import process) to TEXT so that I looks and feels like:
I need the date to be TEXT because I also have missing dates in the file
and I need to lable the missing values "NS".
Pleaase advise. Thanks.