DATES for Sundays

[BrahmanandaRao]

Hi Guys ,

I want dates for all sundays in a year

using data step and proc step

Regards,

ANAND

[Kurt_Bremser]

What have you tried already? Please show us your code.

[VDD]

Date formats is what you are looking for.

https://v8doc.sas.com/sashtml/lrcon/zenid-63.htm

to find Sundays, use weekday.

[PeterClemmensen]

For 2019

data AllSundays;
   do date='01jan2019'd to '31dec2019'd;
      if weekday(date)=1 then output;
   end;
   format date date9.;
run;

[BrahmanandaRao · Accepted solution]

Thank your very much 

Regards,

Anand

[BrahmanandaRao]

Hi 

I want to create separate  flag variable weekday column along witth date this same code how it is?

Obs	date	Weekday
1	07-Jan-19	Sunday
2	14-Jan-19	Sunday
3	21-Jan-19	Sunday
4	28-Jan-19	Sunday
5	04-Feb-19	Sunday
6	11-Feb-19	Sunday
7	18-Feb-19	Sunday
8	25-Feb-19	Sunday
9	04-Mar-19	Sunday
10	11-Mar-19	Sunday
11	18-Mar-19	Sunday
12	25-Mar-19	Sunday
13	01-Apr-19	Sunday
14	08-Apr-19	Sunday
15	15-Apr-19	Sunday
16	22-Apr-19	Sunday
17	29-Apr-19	Sunday
18	06-May-19	Sunday
19	13-May-19	Sunday
20	20-May-19	Sunday
21	27-May-19	Sunday
22	03-Jun-19	Sunday
23	10-Jun-19	Sunday
24	17-Jun-19	Sunday
25	24-Jun-19	Sunday
26	01-Jul-19	Sunday
27	08-Jul-19	Sunday
28	15-Jul-19	Sunday
29	22-Jul-19	Sunday
30	29-Jul-19	Sunday
31	05-Aug-19	Sunday
32	12-Aug-19	Sunday
33	19-Aug-19	Sunday
34	26-Aug-19	Sunday
35	02-Sep-19	Sunday
36	09-Sep-19	Sunday
37	16-Sep-19	Sunday
38	23-Sep-19	Sunday
39	30-Sep-19	Sunday
40	07-Oct-19	Sunday
41	14-Oct-19	Sunday
42	21-Oct-19	Sunday
43	28-Oct-19	Sunday
44	04-Nov-19	Sunday
45	11-Nov-19	Sunday
46	18-Nov-19	Sunday
47	25-Nov-19	Sunday
48	02-Dec-19	Sunday
49	09-Dec-19	Sunday
50	16-Dec-19	Sunday
51	23-Dec-19	Sunday
52	30-Dec-19	Sunday

[PeterClemmensen]

You can either do this with a simple format like this

data AllSundays;
   do date='01jan2019'd to '31dec2019'd;
      Weekday=date;
      if weekday(date)=1 then output;
   end;
   format Weekday downame. date date9.;
run;

or like below if you want Weekday to be a character variable.

data AllSundays;
   do date='01jan2019'd to '31dec2019'd;
      Weekday=put(date, downame. -l);
      if weekday(date)=1 then output;
   end;
   format date date9.;
run;

[BrahmanandaRao]

Hi Draycut

Thank your for solution

Obs date 

06JAN2019	Sunday
13JAN2019	Sunday
20JAN2019	Sunday
27JAN2019	Sunday
03FEB2019	Sunday
10FEB2019	Sunday
17FEB2019	Sunday
24FEB2019	Sunday
03MAR2019	Sunday
10MAR2019	Sunday
17MAR2019	Sunday
24MAR2019	Sunday
31MAR2019	Sunday
07APR2019	Sunday
14APR2019	Sunday
21APR2019	Sunday
28APR2019	Sunday
05MAY2019	Sunday
12MAY2019	Sunday
19MAY2019	Sunday
26MAY2019	Sunday
02JUN2019	Sunday
09JUN2019	Sunday
16JUN2019	Sunday
23JUN2019	Sunday
30JUN2019	Sunday
07JUL2019	Sunday
14JUL2019	Sunday
21JUL2019	Sunday
28JUL2019	Sunday
04AUG2019	Sunday
11AUG2019	Sunday
18AUG2019	Sunday
25AUG2019	Sunday
01SEP2019	Sunday
08SEP2019	Sunday
15SEP2019	Sunday
22SEP2019	Sunday
29SEP2019	Sunday
06OCT2019	Sunday
13OCT2019	Sunday
20OCT2019	Sunday
27OCT2019	Sunday
03NOV2019	Sunday
10NOV2019	Sunday
17NOV2019	Sunday
24NOV2019	Sunday
01DEC2019	Sunday
08DEC2019	Sunday
15DEC2019	Sunday
22DEC2019	Sunday
29DEC2019	Sunday

[PeterClemmensen]

@BrahmanandaRao, please mark my solution as accepted and not your own 🙂

This helps future users navigate the forum.