Calcite | Level 5

## Calculate n of Weekday from Date since Date

Hello..

Quick Example:

Date A = 31Dec2012

Date B = 12Dec2012

Then I want to know which nth Weekday Date A is since Date B

In this example Date A would be the 3rd Monday since Date B.

Is there anyway to calculate this automatically? Output like 3-2 (3rd-Monday)

Regards,

Raphael

1 ACCEPTED SOLUTION

Accepted Solutions
Calcite | Level 5

## Re: Calculate n of Weekday from Date since Date

DATA _NULL_;

DATEA='31DEC2012'D;

DATEB='12DEC2012'D;

VAR=COMPRESS(INTCK('WEEK', DATEB, DATEA)||"-"||WEEKDAY(DATEA));

PUT VAR;

RUN;

6 REPLIES 6
Super User

## Re: Calculate n of Weekday from Date since Date

You may be able to accomplish this using a combination of INTCK which returns intervals between SAS date values such as weeks, and the WEEKDAY function which will return day of the week of a SAS date value. Check the online help for syntax, intervals supported and starts (not everyone considers the week to start on the same day).

Calcite | Level 5

## Re: Calculate n of Weekday from Date since Date

It doesn't matter in this situation on which day the week starts. "Check online help"-Answers are useless. Thanks anyway.

Quartz | Level 8

## Re: Calculate n of Weekday from Date since Date

Check out the below code and see if it works for you.

data one;

length output \$10;

date_a = '31Dec2012'd;

date_b = '12Dec2012'd;

weeka = week(date_a,'u');

weekdaya = weekday(date_a);

weekb = week(date_b,'u');

output = strip(put(weeka-weekb,best.))||'-'||strip(put(weekdaya,best.));

format date_a date_b date9.;

run;

Calcite | Level 5

## Re: Calculate n of Weekday from Date since Date

Bit complicated :smileysilly:

Will post my solution.. Bit smaller.. But thanks

Calcite | Level 5

## Re: Calculate n of Weekday from Date since Date

DATA _NULL_;

DATEA='31DEC2012'D;

DATEB='12DEC2012'D;

VAR=COMPRESS(INTCK('WEEK', DATEB, DATEA)||"-"||WEEKDAY(DATEA));

PUT VAR;

RUN;

Super User

## Re: Calculate n of Weekday from Date since Date

Don't feed the trolls...

Discussion stats
• 6 replies
• 878 views
• 1 like
• 4 in conversation