Hello all. I am importing a table with multiple date columns that end up importing to character columns, because these date columns also contain "N/A" values. Im wondering if theres a way to properly format these columns into dates, since the dates listed are just random numbers now... Example: Closing_Date 44866 44866 44866 44866 44866 44866 44866 44866 44866 44866 44846 44866 I have tried the following code (found in the SAS community) data work.Table2;
set work.Table1;
Closing_Date = input(Date, 5.) + '30DEC1899'd;
format Closing_Date date9.;
run; and I receive the following error: 24
25 GOPTIONS ACCESSIBLE;
26 data work.Table2;
27 set work.Table1;
28 Closing_Date = input(Date,5.) + '30DEC1899'd;
29 format Closing_Date date9.;
______
484
NOTE 484-185: Format $DATE was not found or could not be loaded.
... View more
