topic Re: DATES for Sundays in New SAS User https://communities.sas.com/t5/New-SAS-User/DATES-for-Sundays/m-p/556278#M9793 <P>Thank your very much&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P><P>Regards,</P><P>Anand</P> Sun, 05 May 2019 16:37:22 GMT BrahmanandaRao 2019-05-05T16:37:22Z DATES for Sundays https://communities.sas.com/t5/New-SAS-User/DATES-for-Sundays/m-p/556242#M9784 <P>Hi Guys ,</P><P>I want dates for all sundays in a year</P><P>&nbsp;</P><P>using data step and proc step</P><P>&nbsp;</P><P>&nbsp;</P><P>Regards,</P><P>ANAND</P> Sun, 05 May 2019 08:30:19 GMT https://communities.sas.com/t5/New-SAS-User/DATES-for-Sundays/m-p/556242#M9784 BrahmanandaRao 2019-05-05T08:30:19Z Re: DATES for Sundays https://communities.sas.com/t5/New-SAS-User/DATES-for-Sundays/m-p/556246#M9786 <P>What have you tried already? Please show us your code.</P> Sun, 05 May 2019 11:07:04 GMT https://communities.sas.com/t5/New-SAS-User/DATES-for-Sundays/m-p/556246#M9786 Kurt_Bremser 2019-05-05T11:07:04Z Re: DATES for Sundays https://communities.sas.com/t5/New-SAS-User/DATES-for-Sundays/m-p/556264#M9789 <P>Date formats is what you are looking for.</P> <P><FONT style="background-color: #ffffff;"><A href="https://v8doc.sas.com/sashtml/lrcon/zenid-63.htm" target="_blank">https://v8doc.sas.com/sashtml/lrcon/zenid-63.htm</A></FONT></P> <P>&nbsp;</P> <P><FONT style="background-color: #ffffff;">to find Sundays, use weekday.</FONT></P> <P>&nbsp;</P> Sun, 05 May 2019 13:53:30 GMT https://communities.sas.com/t5/New-SAS-User/DATES-for-Sundays/m-p/556264#M9789 VDD 2019-05-05T13:53:30Z Re: DATES for Sundays https://communities.sas.com/t5/New-SAS-User/DATES-for-Sundays/m-p/556277#M9792 <P>For 2019</P> <P>&nbsp;</P> <PRE><CODE class=" language-sas">data AllSundays; do date='01jan2019'd to '31dec2019'd; if weekday(date)=1 then output; end; format date date9.; run;</CODE></PRE> Sun, 05 May 2019 16:18:57 GMT https://communities.sas.com/t5/New-SAS-User/DATES-for-Sundays/m-p/556277#M9792 PeterClemmensen 2019-05-05T16:18:57Z Re: DATES for Sundays https://communities.sas.com/t5/New-SAS-User/DATES-for-Sundays/m-p/556278#M9793 <P>Thank your very much&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P><P>Regards,</P><P>Anand</P> Sun, 05 May 2019 16:37:22 GMT https://communities.sas.com/t5/New-SAS-User/DATES-for-Sundays/m-p/556278#M9793 BrahmanandaRao 2019-05-05T16:37:22Z Re: DATES for Sundays https://communities.sas.com/t5/New-SAS-User/DATES-for-Sundays/m-p/556280#M9795 <P>Hi&nbsp;</P><P>I want to create separate&nbsp; flag variable weekday column along witth date this same code how it is?</P><P>&nbsp;</P><TABLE><TBODY><TR><TD>Obs</TD><TD>date</TD><TD>Weekday</TD></TR><TR><TD>1</TD><TD>07-Jan-19</TD><TD>Sunday</TD></TR><TR><TD>2</TD><TD>14-Jan-19</TD><TD>Sunday</TD></TR><TR><TD>3</TD><TD>21-Jan-19</TD><TD>Sunday</TD></TR><TR><TD>4</TD><TD>28-Jan-19</TD><TD>Sunday</TD></TR><TR><TD>5</TD><TD>04-Feb-19</TD><TD>Sunday</TD></TR><TR><TD>6</TD><TD>11-Feb-19</TD><TD>Sunday</TD></TR><TR><TD>7</TD><TD>18-Feb-19</TD><TD>Sunday</TD></TR><TR><TD>8</TD><TD>25-Feb-19</TD><TD>Sunday</TD></TR><TR><TD>9</TD><TD>04-Mar-19</TD><TD>Sunday</TD></TR><TR><TD>10</TD><TD>11-Mar-19</TD><TD>Sunday</TD></TR><TR><TD>11</TD><TD>18-Mar-19</TD><TD>Sunday</TD></TR><TR><TD>12</TD><TD>25-Mar-19</TD><TD>Sunday</TD></TR><TR><TD>13</TD><TD>01-Apr-19</TD><TD>Sunday</TD></TR><TR><TD>14</TD><TD>08-Apr-19</TD><TD>Sunday</TD></TR><TR><TD>15</TD><TD>15-Apr-19</TD><TD>Sunday</TD></TR><TR><TD>16</TD><TD>22-Apr-19</TD><TD>Sunday</TD></TR><TR><TD>17</TD><TD>29-Apr-19</TD><TD>Sunday</TD></TR><TR><TD>18</TD><TD>06-May-19</TD><TD>Sunday</TD></TR><TR><TD>19</TD><TD>13-May-19</TD><TD>Sunday</TD></TR><TR><TD>20</TD><TD>20-May-19</TD><TD>Sunday</TD></TR><TR><TD>21</TD><TD>27-May-19</TD><TD>Sunday</TD></TR><TR><TD>22</TD><TD>03-Jun-19</TD><TD>Sunday</TD></TR><TR><TD>23</TD><TD>10-Jun-19</TD><TD>Sunday</TD></TR><TR><TD>24</TD><TD>17-Jun-19</TD><TD>Sunday</TD></TR><TR><TD>25</TD><TD>24-Jun-19</TD><TD>Sunday</TD></TR><TR><TD>26</TD><TD>01-Jul-19</TD><TD>Sunday</TD></TR><TR><TD>27</TD><TD>08-Jul-19</TD><TD>Sunday</TD></TR><TR><TD>28</TD><TD>15-Jul-19</TD><TD>Sunday</TD></TR><TR><TD>29</TD><TD>22-Jul-19</TD><TD>Sunday</TD></TR><TR><TD>30</TD><TD>29-Jul-19</TD><TD>Sunday</TD></TR><TR><TD>31</TD><TD>05-Aug-19</TD><TD>Sunday</TD></TR><TR><TD>32</TD><TD>12-Aug-19</TD><TD>Sunday</TD></TR><TR><TD>33</TD><TD>19-Aug-19</TD><TD>Sunday</TD></TR><TR><TD>34</TD><TD>26-Aug-19</TD><TD>Sunday</TD></TR><TR><TD>35</TD><TD>02-Sep-19</TD><TD>Sunday</TD></TR><TR><TD>36</TD><TD>09-Sep-19</TD><TD>Sunday</TD></TR><TR><TD>37</TD><TD>16-Sep-19</TD><TD>Sunday</TD></TR><TR><TD>38</TD><TD>23-Sep-19</TD><TD>Sunday</TD></TR><TR><TD>39</TD><TD>30-Sep-19</TD><TD>Sunday</TD></TR><TR><TD>40</TD><TD>07-Oct-19</TD><TD>Sunday</TD></TR><TR><TD>41</TD><TD>14-Oct-19</TD><TD>Sunday</TD></TR><TR><TD>42</TD><TD>21-Oct-19</TD><TD>Sunday</TD></TR><TR><TD>43</TD><TD>28-Oct-19</TD><TD>Sunday</TD></TR><TR><TD>44</TD><TD>04-Nov-19</TD><TD>Sunday</TD></TR><TR><TD>45</TD><TD>11-Nov-19</TD><TD>Sunday</TD></TR><TR><TD>46</TD><TD>18-Nov-19</TD><TD>Sunday</TD></TR><TR><TD>47</TD><TD>25-Nov-19</TD><TD>Sunday</TD></TR><TR><TD>48</TD><TD>02-Dec-19</TD><TD>Sunday</TD></TR><TR><TD>49</TD><TD>09-Dec-19</TD><TD>Sunday</TD></TR><TR><TD>50</TD><TD>16-Dec-19</TD><TD>Sunday</TD></TR><TR><TD>51</TD><TD>23-Dec-19</TD><TD>Sunday</TD></TR><TR><TD>52</TD><TD>30-Dec-19</TD><TD>Sunday</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>&nbsp;</P> Sun, 05 May 2019 16:55:27 GMT https://communities.sas.com/t5/New-SAS-User/DATES-for-Sundays/m-p/556280#M9795 BrahmanandaRao 2019-05-05T16:55:27Z Re: DATES for Sundays https://communities.sas.com/t5/New-SAS-User/DATES-for-Sundays/m-p/556281#M9796 <P>You can either do this with a simple format like this</P> <P>&nbsp;</P> <PRE><CODE class=" language-sas">data AllSundays; do date='01jan2019'd to '31dec2019'd; Weekday=date; if weekday(date)=1 then output; end; format Weekday downame. date date9.; run;</CODE></PRE> <P>or like below if you want Weekday to be a character variable.</P> <P>&nbsp;</P> <PRE><CODE class=" language-sas">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;</CODE></PRE> Sun, 05 May 2019 17:06:32 GMT https://communities.sas.com/t5/New-SAS-User/DATES-for-Sundays/m-p/556281#M9796 PeterClemmensen 2019-05-05T17:06:32Z Re: DATES for Sundays https://communities.sas.com/t5/New-SAS-User/DATES-for-Sundays/m-p/556283#M9798 <P>Hi Draycut</P><P>Thank your for solution</P><P>&nbsp;</P><DIV class="branch"><DIV><DIV align="center">Obs date&nbsp; <TABLE cellspacing="0" cellpadding="5"><TBODY><TR><TD>06JAN2019</TD><TD>Sunday</TD></TR><TR><TD>13JAN2019</TD><TD>Sunday</TD></TR><TR><TD>20JAN2019</TD><TD>Sunday</TD></TR><TR><TD>27JAN2019</TD><TD>Sunday</TD></TR><TR><TD>03FEB2019</TD><TD>Sunday</TD></TR><TR><TD>10FEB2019</TD><TD>Sunday</TD></TR><TR><TD>17FEB2019</TD><TD>Sunday</TD></TR><TR><TD>24FEB2019</TD><TD>Sunday</TD></TR><TR><TD>03MAR2019</TD><TD>Sunday</TD></TR><TR><TD>10MAR2019</TD><TD>Sunday</TD></TR><TR><TD>17MAR2019</TD><TD>Sunday</TD></TR><TR><TD>24MAR2019</TD><TD>Sunday</TD></TR><TR><TD>31MAR2019</TD><TD>Sunday</TD></TR><TR><TD>07APR2019</TD><TD>Sunday</TD></TR><TR><TD>14APR2019</TD><TD>Sunday</TD></TR><TR><TD>21APR2019</TD><TD>Sunday</TD></TR><TR><TD>28APR2019</TD><TD>Sunday</TD></TR><TR><TD>05MAY2019</TD><TD>Sunday</TD></TR><TR><TD>12MAY2019</TD><TD>Sunday</TD></TR><TR><TD>19MAY2019</TD><TD>Sunday</TD></TR><TR><TD>26MAY2019</TD><TD>Sunday</TD></TR><TR><TD>02JUN2019</TD><TD>Sunday</TD></TR><TR><TD>09JUN2019</TD><TD>Sunday</TD></TR><TR><TD>16JUN2019</TD><TD>Sunday</TD></TR><TR><TD>23JUN2019</TD><TD>Sunday</TD></TR><TR><TD>30JUN2019</TD><TD>Sunday</TD></TR><TR><TD>07JUL2019</TD><TD>Sunday</TD></TR><TR><TD>14JUL2019</TD><TD>Sunday</TD></TR><TR><TD>21JUL2019</TD><TD>Sunday</TD></TR><TR><TD>28JUL2019</TD><TD>Sunday</TD></TR><TR><TD>04AUG2019</TD><TD>Sunday</TD></TR><TR><TD>11AUG2019</TD><TD>Sunday</TD></TR><TR><TD>18AUG2019</TD><TD>Sunday</TD></TR><TR><TD>25AUG2019</TD><TD>Sunday</TD></TR><TR><TD>01SEP2019</TD><TD>Sunday</TD></TR><TR><TD>08SEP2019</TD><TD>Sunday</TD></TR><TR><TD>15SEP2019</TD><TD>Sunday</TD></TR><TR><TD>22SEP2019</TD><TD>Sunday</TD></TR><TR><TD>29SEP2019</TD><TD>Sunday</TD></TR><TR><TD>06OCT2019</TD><TD>Sunday</TD></TR><TR><TD>13OCT2019</TD><TD>Sunday</TD></TR><TR><TD>20OCT2019</TD><TD>Sunday</TD></TR><TR><TD>27OCT2019</TD><TD>Sunday</TD></TR><TR><TD>03NOV2019</TD><TD>Sunday</TD></TR><TR><TD>10NOV2019</TD><TD>Sunday</TD></TR><TR><TD>17NOV2019</TD><TD>Sunday</TD></TR><TR><TD>24NOV2019</TD><TD>Sunday</TD></TR><TR><TD>01DEC2019</TD><TD>Sunday</TD></TR><TR><TD>08DEC2019</TD><TD>Sunday</TD></TR><TR><TD>15DEC2019</TD><TD>Sunday</TD></TR><TR><TD>22DEC2019</TD><TD>Sunday</TD></TR><TR><TD>29DEC2019</TD><TD>Sunday</TD></TR></TBODY></TABLE></DIV></DIV></DIV> Sun, 05 May 2019 17:14:11 GMT https://communities.sas.com/t5/New-SAS-User/DATES-for-Sundays/m-p/556283#M9798 BrahmanandaRao 2019-05-05T17:14:11Z Re: DATES for Sundays https://communities.sas.com/t5/New-SAS-User/DATES-for-Sundays/m-p/556285#M9799 <P><a href="https://communities.sas.com/t5/user/viewprofilepage/user-id/265860">@BrahmanandaRao</a>,&nbsp;please mark <STRONG>my&nbsp;</STRONG>solution as accepted and not your own <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P> <P>&nbsp;</P> <P>This helps future users navigate the forum.</P> Sun, 05 May 2019 17:46:40 GMT https://communities.sas.com/t5/New-SAS-User/DATES-for-Sundays/m-p/556285#M9799 PeterClemmensen 2019-05-05T17:46:40Z