Hello, I'm using SAS Enterprise version 7.15 HF8 (7.100.5.6214) (64-bit). I'm trying to change a date using data pulled from a Teradata server. The properties indicate the original field is Date9 and the output in SAS displays the dates as "ddmmmyyyy". I created a new table where I'm changing the date to "01JUN2019". SAS identifies the new date as a character by default. When I try to change the field to Date9, the output is in numerical format and is displayed as "21701". I appreciate any help. PROC SQL; CREATE TABLE Have AS SELECT DISTINCT '01JUN2019' AS START_DATE, GROUP BY 1 ;QUIT; data want; set have new = input(start_date, date9.); drop start_date; rename new=start_date; run;
... View more
