topic Re: Find the Beginning Date of a Week in New SAS User

Find the Beginning Date of a Week

RADAGBE9 — Thu, 24 Oct 2019 21:58:05 GMT

Hi,

I'm trying to find the Week Begin Date from a Given Date with Saturday as the Starting point. I've tried the following code but it always yields a Sunday Start Date. I would like x=24Oct2019 to return 10/20/19 (Saturday) & 26Oct2019 to return 10/26/19 (Also Saturday).

data _null_;

x='24Oct2019'd;

e=intnx("week",x,0,"B")

put e=;

format e mmddyy10;

run;

Thanks

Re: Find the Beginning Date of a Week

PGStats — Thu, 24 Oct 2019 22:08:25 GMT

data _null_;
do x='20Oct2019'd to '30Oct2019'd;
	e=intnx("week.7",x,0,"B");
	put (x e) (+1 yymmdd10.);
	end;
run;

  2019-10-20 2019-10-19
  2019-10-21 2019-10-19
  2019-10-22 2019-10-19
  2019-10-23 2019-10-19
  2019-10-24 2019-10-19
  2019-10-25 2019-10-19
  2019-10-26 2019-10-26
  2019-10-27 2019-10-26
  2019-10-28 2019-10-26
  2019-10-29 2019-10-26
  2019-10-30 2019-10-26

Re: Find the Beginning Date of a Week

PaigeMiller — Thu, 24 Oct 2019 22:09:47 GMT

e=intnx("week.7",x,0,"B")

Re: Find the Beginning Date of a Week

RADAGBE9 — Thu, 24 Oct 2019 22:19:12 GMT

Thanks. Worked Perfectly.

Re: Find the Beginning Date of a Week

jpprovost — Fri, 25 Oct 2019 02:42:18 GMT

@PGStats wrote:

data _null_;
do x='20Oct2019'd to '30Oct2019'd;
	e=intnx("week.7",x,0,"B");
	put (x e) (+1 yymmdd10.);
	end;
run;

  2019-10-20 2019-10-19
  2019-10-21 2019-10-19
  2019-10-22 2019-10-19
  2019-10-23 2019-10-19
  2019-10-24 2019-10-19
  2019-10-25 2019-10-19
  2019-10-26 2019-10-26
  2019-10-27 2019-10-26
  2019-10-28 2019-10-26
  2019-10-29 2019-10-26
  2019-10-30 2019-10-26

Hi @PGStats ,

Just a curiosity question. What does this line do?

	put (x e) (+1 yymmdd10.);

I know that put will conver num to char, but I don't understand the "+1"?

Re: Find the Beginning Date of a Week

PGStats — Fri, 25 Oct 2019 02:48:50 GMT

The +1 adds a space character. Try removing it!

Re: Find the Beginning Date of a Week

jpprovost — Fri, 25 Oct 2019 02:51:06 GMT

@PGStats wrote:

The +1 adds a space character. Try removing it!

I'll for sure. There's so many "behind the scene" tricks with SAS that I don't know. I didn't know that you can use put (var1 var2) (format) in that way.

Thanks for your help.