Thanks, Astounding. You save me a lot of time by try and error. The example of the answer are as follows: data two; infile CSV; OPTIONS DATESTYLE=MDY; INPUT @1 Incident best12. @14 Summary $1. ... Victor ... View more

y=input(put(dp1,10.),anydtdte10.); format y mmddyy10.; wday1=weekday(y); Obs incident idx1 idx2 dp1 dp y wday1 createdon_d CreatedOn resolvedon_d Resolvedon closedon_d Closedon 1 81402 STG CSV 4/1/2021 . 1/4/2021 2 4/1/2021 10:43 4/1/2021 5:43 NULL 4/1/2021 10:45 4/1/2021 5:45 2 81403 STG CSV 4/1/2021 . 1/4/2021 2 4/1/2021 10:43 4/1/2021 5:43 NULL 4/1/2021 10:46 4/1/2021 5:46 Why dp1 was converted from 4/1/2021 into 1/4/2021? ... View more

The issues are that y=input(put(dp1,10.),anydtdte10.); did not convert dp1(4/1/2021) into right date. Instead, y(1/4/2021) was converted. The question is that how does anydtdte know dp1 is mmddyy format or ddmmyy format. In the whole report that from 4/1/2021 through 14/12/2021 were treated as ddmmyy until reaching 4/13/2021, then were treated as mmddyy format. Please advose. Thank you. ... View more