Hi, I'm actually writting the code. I would like to export the results in Excel where instead of having an alphanumerical number like '20080223' I would actually have the numerical equivalent in Excel (39805) that is for 23 of febuary 2008 (Starting date = 1900). PROC SQL; CREATE TABLE work.date AS SELECT t1.account_number, t1.opening_date FROM client AS t1 WHERE t1.opening_date NOT = ' '; QUIT;
... View more