topic Re: PROC SQL: Calculate date difference but working days only in SAS Programming

PROC SQL: Calculate date difference but working days only

ywon111 — Fri, 19 Jun 2020 02:44:32 GMT

This gives me number of days for datediff, but trying to get working days only:

PROC SQL;
CREATE TABLE a AS
SELECT
t1.industry,
"&extdate"d+1 - t1.event_from_date as datediff
FROM sss t1

...

Thanks

ChrisNZ — Fri, 19 Jun 2020 03:03:59 GMT

Different countries have different holidays.

How do you identify a working day?

ywon111 — Fri, 19 Jun 2020 03:09:06 GMT

Thanks for your reply.

Just want to get week days for now.

PGStats — Fri, 19 Jun 2020 03:31:57 GMT

intck("weekday", t1.event_from_date, "&extdate"d) as dateDiff,

ywon111 — Fri, 19 Jun 2020 03:32:11 GMT

Solved, just use intck