topic Calculate n of Weekday from Date since Date in SAS Programming

Calculate n of Weekday from Date since Date

Raphael_ — Fri, 04 Jan 2013 15:10:52 GMT

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

Re: Calculate n of Weekday from Date since Date

ballardw — Fri, 04 Jan 2013 15:55:52 GMT

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).

Re: Calculate n of Weekday from Date since Date

NickR — Fri, 04 Jan 2013 16:04:20 GMT

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;

Re: Calculate n of Weekday from Date since Date

Raphael_ — Fri, 04 Jan 2013 16:09:39 GMT

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

Re: Calculate n of Weekday from Date since Date

Raphael_ — Fri, 04 Jan 2013 16:10:06 GMT

Bit complicated :smileysilly:

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

Re: Calculate n of Weekday from Date since Date

Raphael_ — Fri, 04 Jan 2013 16:10:18 GMT

DATA _NULL_;

DATEA='31DEC2012'D;

DATEB='12DEC2012'D;

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

PUT VAR;

RUN;

Re: Calculate n of Weekday from Date since Date

Reeza — Fri, 04 Jan 2013 16:21:18 GMT

Don't feed the trolls...