topic Re: informat anydtdte issue in SAS Programming

informat anydtdte issue

VictorHsieh — Sun, 30 May 2021 15:01:57 GMT

Re: informat anydtdte issue

PaigeMiller — Sun, 30 May 2021 15:07:06 GMT

Please include text (like code and data) in your message directly, rather than through attachments. Many people will not download attachments, and specifically Microsoft Office documents are a security threat when downloaded.

Re: informat anydtdte issue

VictorHsieh — Sun, 30 May 2021 15:23:08 GMT

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.

Re: informat anydtdte issue

VictorHsieh — Sun, 30 May 2021 15:37:41 GMT

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?

Re: informat anydtdte issue

Astounding — Sun, 30 May 2021 16:41:44 GMT

SAS doesn't know whether ambiguous data is in mdy form or dmy form. Do you know? If so, you can use the DATESTYLE option to tell SAS which interpretation to use, either of:

options datestyle=dmy;

options datestyle=mdy;

Re: informat anydtdte issue

Tom — Sun, 30 May 2021 16:48:02 GMT

The ANYDTxxxx informat will have to GUESS which parts of the string is the month and which is day when the day value is less than 13. It will use the DATESTYLE setting to tell it which to use.

Set it to the style you want it to use.

I cannot tell from your question whether you want MDY or DMY.

Is '4/1/2021' supposed to be the fourth of January or April first?

Re: informat anydtdte issue

Sajid01 — Sun, 30 May 2021 16:49:17 GMT

@VictorHsieh
The following option will tell you what the data style will be in the case of ambiguity.

proc options option=datestyle;
run;

If the response in the log output is like the following

 DATESTYLE=MDY     Specifies the sequence of month, day, and year when ANYDTDTE, ANYDTDTM, or ANYDTTME informat data is ambiguous.

You need to run this option on your system and it will explain.

Re: informat anydtdte issue

s_lassen — Sun, 30 May 2021 16:58:38 GMT

Why dp1 was converted from 4/1/2021 into 1/4/2021?

That depends, in the end, on the SAS installation you are running on. As @Astounding remarked, SAS does not "know" which date informat you want as the default. It guesses from the setting of the LOCALE system option, if it is European you will most often get DMY, if it is American, you will definitely get MDY. So, if you are using ANYDTDTE., always assign the DATESTYLE option first. Otherwise, your program will give one result on some installations, and another on other installations.

Being European (Danish) myself, I work half the time (or thereabout) on installations that use LOCALE=DA_DK, and the rest of the time on installations using the SAS System default, which is EN_US or something like that. And they give different results for ANYDTDTE without the DATESTYLE option.

Re: informat anydtdte issue

VictorHsieh — Sun, 30 May 2021 17:38:38 GMT

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