topic Re: about weekdatew. in SAS Programming

about weekdatew.

tianerhu — Wed, 18 Aug 2021 23:43:40 GMT

data CCA;
b = '2Jan1583'd;
run;
proc print data = CCA;
format  b weekdate31.;
run;

why it is 'NOV' ?

Re: about weekdatew.

tarheel13 — Wed, 18 Aug 2021 23:59:38 GMT

It's not?

I ran your code and this is what I get in SAS ODA.


Obs	b
1	Sunday, January 2, 1583

Re: about weekdatew.

ballardw — Thu, 19 Aug 2021 00:15:56 GMT

@tarheel13 wrote:

It's not?

I ran your code and this is what I get in SAS ODA.

Obs b

1 Sunday, January 2, 1583

Same with SAS 9.4.4

Re: about weekdatew.

tianerhu — Thu, 19 Aug 2021 00:50:36 GMT

I am sorry . the year is not 1583 , is 1582 , the following is the revised code :

data CCA;
b = '1Jan1582'd;
run;
proc print data = CCA;
format  b weekdate31.;
run;

Re: about weekdatew.

tarheel13 — Thu, 19 Aug 2021 01:01:56 GMT

Okay. I see the same as you. But why are you using a date from the 1500s?

Re: about weekdatew.

tianerhu — Thu, 19 Aug 2021 01:04:47 GMT

I just want to try . Thank you for your help.

Re: about weekdatew.

tarheel13 — Thu, 19 Aug 2021 01:05:36 GMT

Okay. If you use different years like 1982 or 2003, it won't show 'NOV' at the beginning.

Re: about weekdatew.

tianerhu — Thu, 19 Aug 2021 01:09:19 GMT

yes, you are right.
From 1582.1.1---1582.1.9, it displays the wrong value .

Re: about weekdatew.

tarheel13 — Thu, 19 Aug 2021 01:10:26 GMT

Well, the good news is I feel like it is pretty unlikely that you would ever work with date values from the 1500s loll.

Re: about weekdatew.

tianerhu — Thu, 19 Aug 2021 01:15:34 GMT

yes, i agree with you.

Re: about weekdatew.

ballardw — Thu, 19 Aug 2021 01:20:28 GMT

@tianerhu wrote:

I am sorry . the year is not 1583 , is 1582 , the following is the revised code :
data CCA;
b = '1Jan1582'd;
run;
proc print data = CCA;
format  b weekdate31.;
run;

From the documentation on dates:

SAS can perform calculations on dates ranging from A.D. November 1582 to A.D. 19,900.

In other words, none of the functions such as determining the day of week are really guaranteed to work before Nov 1582 reliably.

Try this for some interesting results in Jan 1582.

data CCA;
 do b = '1Jan1582'd to '15Nov1582'd ;
   output;
 end;
run;
proc print data = CCA;
format  b weekdate31.;
run;

Re: about weekdatew.

tianerhu — Thu, 19 Aug 2021 01:32:48 GMT

Thank you for your help.