Every friday data to compare

BaalaRaaji — Fri, 18 Jan 2019 00:06:25 GMT

Hi Guys,

Can you please help me to write a code for weekly report using weekday function and to automatically run on every monday morning.

I got daily data like below for 6 months..

calendar_date	_FREQ_	Balance
10Jan2019	5180	1480096401.80
11Jan2019	5185	1479431521.37
12Jan2019	5185	1479431521.37
13Jan2019	5185	1479431521.37
14Jan2019	5183	1479938213.77
15Jan2019	5192	1481255273.06
16Jan2019	5198	1486672020.87
17Jan2019	5199	1481255277.06
18Jan2019	6000	1486672080.87

Logic for: -

- the report should run every monday to pick friday data only (like 18th jan 2019)..

- the report should compare last two fridays numbers (like 11th jan 2019 and 18th jan 2019)

appreciate if you can send me the sample codes using weekdays for weekly report using daily data tables..

thanks you

Re: Every friday data to compare

ChrisNZ — Fri, 18 Jan 2019 04:25:09 GMT

You don't really say what you want.

This answers the expressed need:

data WANT;
  set HAVE;                       
  where put(CALENDAR_DATE,downame. -l)='Friday';
  DELTA=(BALANCE-lag(BALANCE))/lag(BALANCE);
  format DELTA percent8.2;
run;

CALENDAR_DATE	BALANCE	DELTA
11JAN2019	1479431521.4	.
18JAN2019	1486672080.9	0.49%

topic Re: Every friday data to compare in SAS Programming

Every friday data to compare

Re: Every friday data to compare