topic Re: How to find the week of the date in SAS Programming

How to find the week of the date

fama — Wed, 06 Nov 2019 06:04:55 GMT

Hi all,

I was just wondering how I am able to find the week of the variable date.

the variable shows the dates in YYMMDD format (2015-08-20), however the proc contents shows the variable ac character $14.

So the week of 2015-08-20 is 34. The dataset is too big and I am not able to work with Excel. I should use SAS function.

You help will be appreciated.

Thanks

Re: How to find the week of the date

Kurt_Bremser — Wed, 06 Nov 2019 06:13:11 GMT

Convert to a real SAS date value, and use the week() function:

data _null_;
chardate = '2015-08-20';
numdate = input(chardate,yymmdd10.);
format numdate yymmddd10.;
weeknum = week(numdate);
put _all_;
run;

Log:

24         data _null_;
25         chardate = '2015-08-20';
26         numdate = input(chardate,yymmdd10.);
27         format numdate yymmddd10.;
28         weeknum = week(numdate);
29         put _all_;
30         run;

chardate=2015-08-20 numdate=2015-08-20 weeknum=33 _ERROR_=0 _N_=1
NOTE: DATA statement used (Total process time):
      real time           0.00 seconds
      cpu time            0.00 seconds

Re: How to find the week of the date

sustagens — Wed, 06 Nov 2019 06:23:43 GMT

If your variable containing the date is of character type, you must convert it to a numeric format first.

Input converts your character variable read in the format yymmdd10.

data want;
date_char_fmt='2015-08-20';
week_of_date=week(input(date_char_fmt,yymmdd10.));
run;

Re: How to find the week of the date

SASKiwi — Wed, 06 Nov 2019 06:25:49 GMT

There are different definitions for deriving the week of the year. These are explained in the documentation: https://documentation.sas.com/?docsetId=lefunctionsref&docsetTarget=n1ka2ulrvrjlasn0z7beco2yrgas.htm&docsetVersion=9.4&locale=en