I have a variable that I've named time_period which contains dates listed in the following format as a numeric variable: 201511
201511
201612
201701
201701
... SAS reads these as a "SAS date" and therefore converts 201511 (which is intended to be Nov 2015) to Sep 20, 2511. I found this out when I tried formatting to a word date so I can understand how SAS was reading it: data mydata;
set sample;
sasdate=input(time_period, YYMON.); /*YYMMDDw.*/
format sasdate worddate12.;
run; From what I understand, I need to take this numeric value and convert it to a date value. Some responses explain that you need to ad an "01" in the code to act as a "dd", so I tried the following: data cdiff.date; set cdiff.c; format sasdate date9.; sasdate = input(time_period !! "01", yymmdd8.); run; This did not work, the output is "." down the entire column. Other examples suggest adding a specific date in the date field (I think), but that replaces all the dates with this specific date in my new column. I am not sure how to approach this. Thanks
... View more