topic Re: flagged end of the month in SAS Programming https://communities.sas.com/t5/SAS-Programming/flagged-end-of-the-month/m-p/828838#M327439 <P>So simply a flag that is = 1 when the date is the last day of the month?</P> Tue, 16 Aug 2022 12:57:22 GMT PeterClemmensen 2022-08-16T12:57:22Z flagged end of the month https://communities.sas.com/t5/SAS-Programming/flagged-end-of-the-month/m-p/828837#M327438 <P>Hello,</P> <P>&nbsp;</P> <P>I have the below data set and wanted to flagged end of the month, can I ask for help?</P> <P>&nbsp;</P> <P>thanks a lot.</P> <P>&nbsp;</P> <TABLE width="165"> <TBODY> <TR> <TD width="42">count</TD> <TD width="75">date</TD> <TD width="48">source</TD> </TR> <TR> <TD>98171</TD> <TD>01Jan2022</TD> <TD>CA</TD> </TR> <TR> <TD>15394</TD> <TD>01Jan2022</TD> <TD>LD</TD> </TR> <TR> <TD>15395</TD> <TD>02Jan2022</TD> <TD>LD</TD> </TR> <TR> <TD>98076</TD> <TD>02Jan2022</TD> <TD>CA</TD> </TR> <TR> <TD>15383</TD> <TD>03Jan2022</TD> <TD>LD</TD> </TR> <TR> <TD>98054</TD> <TD>03Jan2022</TD> <TD>CA</TD> </TR> <TR> <TD>15410</TD> <TD>04Jan2022</TD> <TD>LD</TD> </TR> <TR> <TD>97828</TD> <TD>04Jan2022</TD> <TD>CA</TD> </TR> <TR> <TD>15447</TD> <TD>05Jan2022</TD> <TD>LD</TD> </TR> <TR> <TD>97835</TD> <TD>05Jan2022</TD> <TD>CA</TD> </TR> <TR> <TD>15433</TD> <TD>06Jan2022</TD> <TD>LD</TD> </TR> <TR> <TD>97796</TD> <TD>06Jan2022</TD> <TD>CA</TD> </TR> <TR> <TD>15441</TD> <TD>07Jan2022</TD> <TD>LD</TD> </TR> <TR> <TD>97809</TD> <TD>07Jan2022</TD> <TD>CA</TD> </TR> <TR> <TD>97765</TD> <TD>08Jan2022</TD> <TD>CA</TD> </TR> <TR> <TD>15496</TD> <TD>08Jan2022</TD> <TD>LD</TD> </TR> <TR> <TD>15511</TD> <TD>09Jan2022</TD> <TD>LD</TD> </TR> <TR> <TD>97785</TD> <TD>09Jan2022</TD> <TD>CA</TD> </TR> <TR> <TD>15537</TD> <TD>10Jan2022</TD> <TD>LD</TD> </TR> <TR> <TD>97766</TD> <TD>10Jan2022</TD> <TD>CA</TD> </TR> <TR> <TD>15565</TD> <TD>11Jan2022</TD> <TD>LD</TD> </TR> <TR> <TD>97695</TD> <TD>11Jan2022</TD> <TD>CA</TD> </TR> <TR> <TD>15592</TD> <TD>12Jan2022</TD> <TD>LD</TD> </TR> <TR> <TD>97670</TD> <TD>12Jan2022</TD> <TD>CA</TD> </TR> <TR> <TD>15617</TD> <TD>13Jan2022</TD> <TD>LD</TD> </TR> <TR> <TD>97688</TD> <TD>13Jan2022</TD> <TD>CA</TD> </TR> <TR> <TD>97694</TD> <TD>14Jan2022</TD> <TD>CA</TD> </TR> <TR> <TD>15647</TD> <TD>14Jan2022</TD> <TD>LD</TD> </TR> <TR> <TD>15659</TD> <TD>15Jan2022</TD> <TD>LD</TD> </TR> <TR> <TD>97696</TD> <TD>15Jan2022</TD> <TD>CA</TD> </TR> <TR> <TD>97678</TD> <TD>16Jan2022</TD> <TD>CA</TD> </TR> <TR> <TD>15669</TD> <TD>16Jan2022</TD> <TD>LD</TD> </TR> <TR> <TD>15669</TD> <TD>17Jan2022</TD> <TD>LD</TD> </TR> <TR> <TD>97682</TD> <TD>17Jan2022</TD> <TD>CA</TD> </TR> <TR> <TD>15673</TD> <TD>18Jan2022</TD> <TD>LD</TD> </TR> <TR> <TD>97620</TD> <TD>18Jan2022</TD> <TD>CA</TD> </TR> <TR> <TD>15683</TD> <TD>19Jan2022</TD> <TD>LD</TD> </TR> <TR> <TD>97550</TD> <TD>19Jan2022</TD> <TD>CA</TD> </TR> <TR> <TD>15692</TD> <TD>20Jan2022</TD> <TD>LD</TD> </TR> <TR> <TD>97512</TD> <TD>20Jan2022</TD> <TD>CA</TD> </TR> <TR> <TD>15709</TD> <TD>21Jan2022</TD> <TD>LD</TD> </TR> <TR> <TD>97508</TD> <TD>21Jan2022</TD> <TD>CA</TD> </TR> <TR> <TD>15740</TD> <TD>22Jan2022</TD> <TD>LD</TD> </TR> <TR> <TD>97494</TD> <TD>22Jan2022</TD> <TD>CA</TD> </TR> <TR> <TD>15762</TD> <TD>23Jan2022</TD> <TD>LD</TD> </TR> <TR> <TD>97483</TD> <TD>23Jan2022</TD> <TD>CA</TD> </TR> <TR> <TD>15779</TD> <TD>24Jan2022</TD> <TD>LD</TD> </TR> <TR> <TD>97405</TD> <TD>24Jan2022</TD> <TD>CA</TD> </TR> <TR> <TD>15784</TD> <TD>25Jan2022</TD> <TD>LD</TD> </TR> <TR> <TD>96809</TD> <TD>25Jan2022</TD> <TD>CA</TD> </TR> <TR> <TD>15798</TD> <TD>26Jan2022</TD> <TD>LD</TD> </TR> <TR> <TD>96757</TD> <TD>26Jan2022</TD> <TD>CA</TD> </TR> <TR> <TD>96783</TD> <TD>27Jan2022</TD> <TD>CA</TD> </TR> <TR> <TD>15835</TD> <TD>27Jan2022</TD> <TD>LD</TD> </TR> <TR> <TD>96780</TD> <TD>28Jan2022</TD> <TD>CA</TD> </TR> <TR> <TD>15852</TD> <TD>28Jan2022</TD> <TD>LD</TD> </TR> <TR> <TD>15871</TD> <TD>29Jan2022</TD> <TD>LD</TD> </TR> <TR> <TD>96770</TD> <TD>29Jan2022</TD> <TD>CA</TD> </TR> <TR> <TD>15883</TD> <TD>30Jan2022</TD> <TD>LD</TD> </TR> <TR> <TD>96754</TD> <TD>30Jan2022</TD> <TD>CA</TD> </TR> <TR> <TD>15889</TD> <TD>31Jan2022</TD> <TD>LD</TD> </TR> <TR> <TD>96741</TD> <TD>31Jan2022</TD> <TD>CA</TD> </TR> <TR> <TD>96651</TD> <TD>01Feb2022</TD> <TD>CA</TD> </TR> <TR> <TD>15899</TD> <TD>01Feb2022</TD> <TD>LD</TD> </TR> <TR> <TD>15924</TD> <TD>02Feb2022</TD> <TD>LD</TD> </TR> <TR> <TD>96676</TD> <TD>02Feb2022</TD> <TD>CA</TD> </TR> <TR> <TD>15925</TD> <TD>03Feb2022</TD> <TD>LD</TD> </TR> <TR> <TD>96699</TD> <TD>03Feb2022</TD> <TD>CA</TD> </TR> <TR> <TD>15951</TD> <TD>04Feb2022</TD> <TD>LD</TD> </TR> <TR> <TD>96725</TD> <TD>04Feb2022</TD> <TD>CA</TD> </TR> <TR> <TD>15986</TD> <TD>05Feb2022</TD> <TD>LD</TD> </TR> <TR> <TD>96477</TD> <TD>05Feb2022</TD> <TD>CA</TD> </TR> <TR> <TD>15996</TD> <TD>06Feb2022</TD> <TD>LD</TD> </TR> <TR> <TD>96399</TD> <TD>06Feb2022</TD> <TD>CA</TD> </TR> <TR> <TD>15998</TD> <TD>07Feb2022</TD> <TD>LD</TD> </TR> <TR> <TD>96364</TD> <TD>07Feb2022</TD> <TD>CA</TD> </TR> <TR> <TD>16022</TD> <TD>08Feb2022</TD> <TD>LD</TD> </TR> <TR> <TD>96306</TD> <TD>08Feb2022</TD> <TD>CA</TD> </TR> <TR> <TD>16052</TD> <TD>09Feb2022</TD> <TD>LD</TD> </TR> <TR> <TD>96293</TD> <TD>09Feb2022</TD> <TD>CA</TD> </TR> <TR> <TD>16081</TD> <TD>10Feb2022</TD> <TD>LD</TD> </TR> <TR> <TD>96309</TD> <TD>10Feb2022</TD> <TD>CA</TD> </TR> <TR> <TD>16099</TD> <TD>11Feb2022</TD> <TD>LD</TD> </TR> <TR> <TD>96331</TD> <TD>11Feb2022</TD> <TD>CA</TD> </TR> <TR> <TD>16131</TD> <TD>12Feb2022</TD> <TD>LD</TD> </TR> <TR> <TD>96349</TD> <TD>12Feb2022</TD> <TD>CA</TD> </TR> <TR> <TD>16142</TD> <TD>13Feb2022</TD> <TD>LD</TD> </TR> <TR> <TD>96378</TD> <TD>13Feb2022</TD> <TD>CA</TD> </TR> <TR> <TD>16128</TD> <TD>14Feb2022</TD> <TD>LD</TD> </TR> <TR> <TD>96372</TD> <TD>14Feb2022</TD> <TD>CA</TD> </TR> <TR> <TD>16147</TD> <TD>15Feb2022</TD> <TD>LD</TD> </TR> <TR> <TD>96356</TD> <TD>15Feb2022</TD> <TD>CA</TD> </TR> <TR> <TD>16191</TD> <TD>16Feb2022</TD> <TD>LD</TD> </TR> <TR> <TD>96341</TD> <TD>16Feb2022</TD> <TD>CA</TD> </TR> <TR> <TD>16223</TD> <TD>17Feb2022</TD> <TD>LD</TD> </TR> <TR> <TD>96336</TD> <TD>17Feb2022</TD> <TD>CA</TD> </TR> <TR> <TD>16255</TD> <TD>18Feb2022</TD> <TD>LD</TD> </TR> <TR> <TD>96327</TD> <TD>18Feb2022</TD> <TD>CA</TD> </TR> <TR> <TD>16266</TD> <TD>19Feb2022</TD> <TD>LD</TD> </TR> <TR> <TD>96344</TD> <TD>19Feb2022</TD> <TD>CA</TD> </TR> <TR> <TD>16285</TD> <TD>20Feb2022</TD> <TD>LD</TD> </TR> <TR> <TD>96337</TD> <TD>20Feb2022</TD> <TD>CA</TD> </TR> <TR> <TD>16270</TD> <TD>21Feb2022</TD> <TD>LD</TD> </TR> <TR> <TD>96278</TD> <TD>21Feb2022</TD> <TD>CA</TD> </TR> <TR> <TD>16263</TD> <TD>22Feb2022</TD> <TD>LD</TD> </TR> <TR> <TD>96173</TD> <TD>22Feb2022</TD> <TD>CA</TD> </TR> <TR> <TD>16311</TD> <TD>23Feb2022</TD> <TD>LD</TD> </TR> <TR> <TD>96198</TD> <TD>23Feb2022</TD> <TD>CA</TD> </TR> <TR> <TD>16322</TD> <TD>24Feb2022</TD> <TD>LD</TD> </TR> <TR> <TD>96229</TD> <TD>24Feb2022</TD> <TD>CA</TD> </TR> <TR> <TD>16330</TD> <TD>25Feb2022</TD> <TD>LD</TD> </TR> <TR> <TD>96272</TD> <TD>25Feb2022</TD> <TD>CA</TD> </TR> <TR> <TD>16353</TD> <TD>26Feb2022</TD> <TD>LD</TD> </TR> <TR> <TD>96265</TD> <TD>26Feb2022</TD> <TD>CA</TD> </TR> <TR> <TD>16383</TD> <TD>27Feb2022</TD> <TD>LD</TD> </TR> <TR> <TD>96285</TD> <TD>27Feb2022</TD> <TD>CA</TD> </TR> <TR> <TD>16396</TD> <TD>28Feb2022</TD> <TD>LD</TD> </TR> <TR> <TD>96127</TD> <TD>28Feb2022</TD> <TD>CA</TD> </TR> <TR> <TD>16417</TD> <TD>01Mar2022</TD> <TD>LD</TD> </TR> <TR> <TD>95795</TD> <TD>01Mar2022</TD> <TD>CA</TD> </TR> <TR> <TD>16444</TD> <TD>02Mar2022</TD> <TD>LD</TD> </TR> <TR> <TD>95841</TD> <TD>02Mar2022</TD> <TD>CA</TD> </TR> <TR> <TD>16432</TD> <TD>03Mar2022</TD> <TD>LD</TD> </TR> <TR> <TD>95858</TD> <TD>03Mar2022</TD> <TD>CA</TD> </TR> <TR> <TD>16436</TD> <TD>04Mar2022</TD> <TD>LD</TD> </TR> <TR> <TD>95869</TD> <TD>04Mar2022</TD> <TD>CA</TD> </TR> <TR> <TD>95891</TD> <TD>05Mar2022</TD> <TD>CA</TD> </TR> <TR> <TD>16463</TD> <TD>05Mar2022</TD> <TD>LD</TD> </TR> <TR> <TD>16484</TD> <TD>06Mar2022</TD> <TD>LD</TD> </TR> <TR> <TD>95922</TD> <TD>06Mar2022</TD> <TD>CA</TD> </TR> <TR> <TD>16496</TD> <TD>07Mar2022</TD> <TD>LD</TD> </TR> <TR> <TD>95858</TD> <TD>07Mar2022</TD> <TD>CA</TD> </TR> <TR> <TD>16494</TD> <TD>08Mar2022</TD> <TD>LD</TD> </TR> <TR> <TD>95667</TD> <TD>08Mar2022</TD> <TD>CA</TD> </TR> <TR> <TD>16523</TD> <TD>09Mar2022</TD> <TD>LD</TD> </TR> <TR> <TD>95683</TD> <TD>09Mar2022</TD> <TD>CA</TD> </TR> <TR> <TD>16560</TD> <TD>10Mar2022</TD> <TD>LD</TD> </TR> <TR> <TD>95712</TD> <TD>10Mar2022</TD> <TD>CA</TD> </TR> <TR> <TD>16587</TD> <TD>11Mar2022</TD> <TD>LD</TD> </TR> <TR> <TD>95726</TD> <TD>11Mar2022</TD> <TD>CA</TD> </TR> <TR> <TD>16623</TD> <TD>12Mar2022</TD> <TD>LD</TD> </TR> <TR> <TD>95715</TD> <TD>12Mar2022</TD> <TD>CA</TD> </TR> <TR> <TD>16626</TD> <TD>13Mar2022</TD> <TD>LD</TD> </TR> <TR> <TD>95726</TD> <TD>13Mar2022</TD> <TD>CA</TD> </TR> <TR> <TD>16638</TD> <TD>14Mar2022</TD> <TD>LD</TD> </TR> <TR> <TD>95704</TD> <TD>14Mar2022</TD> <TD>CA</TD> </TR> <TR> <TD>16668</TD> <TD>15Mar2022</TD> <TD>LD</TD> </TR> <TR> <TD>95653</TD> <TD>15Mar2022</TD> <TD>CA</TD> </TR> <TR> <TD>16694</TD> <TD>16Mar2022</TD> <TD>LD</TD> </TR> <TR> <TD>95656</TD> <TD>16Mar2022</TD> <TD>CA</TD> </TR> <TR> <TD>16715</TD> <TD>17Mar2022</TD> <TD>LD</TD> </TR> <TR> <TD>95683</TD> <TD>17Mar2022</TD> <TD>CA</TD> </TR> <TR> <TD>16723</TD> <TD>18Mar2022</TD> <TD>LD</TD> </TR> <TR> <TD>95698</TD> <TD>18Mar2022</TD> <TD>CA</TD> </TR> <TR> <TD>16762</TD> <TD>19Mar2022</TD> <TD>LD</TD> </TR> <TR> <TD>95734</TD> <TD>19Mar2022</TD> <TD>CA</TD> </TR> <TR> <TD>16783</TD> <TD>20Mar2022</TD> <TD>LD</TD> </TR> <TR> <TD>95754</TD> <TD>20Mar2022</TD> <TD>CA</TD> </TR> <TR> <TD>16790</TD> <TD>21Mar2022</TD> <TD>LD</TD> </TR> <TR> <TD>95707</TD> <TD>21Mar2022</TD> <TD>CA</TD> </TR> <TR> <TD>16807</TD> <TD>22Mar2022</TD> <TD>LD</TD> </TR> <TR> <TD>95558</TD> <TD>22Mar2022</TD> <TD>CA</TD> </TR> <TR> <TD>16826</TD> <TD>23Mar2022</TD> <TD>LD</TD> </TR> <TR> <TD>95576</TD> <TD>23Mar2022</TD> <TD>CA</TD> </TR> <TR> <TD>16821</TD> <TD>24Mar2022</TD> <TD>LD</TD> </TR> <TR> <TD>95580</TD> <TD>24Mar2022</TD> <TD>CA</TD> </TR> <TR> <TD>16851</TD> <TD>25Mar2022</TD> <TD>LD</TD> </TR> <TR> <TD>95653</TD> <TD>25Mar2022</TD> <TD>CA</TD> </TR> <TR> <TD>16872</TD> <TD>26Mar2022</TD> <TD>LD</TD> </TR> <TR> <TD>95716</TD> <TD>26Mar2022</TD> <TD>CA</TD> </TR> <TR> <TD>16881</TD> <TD>27Mar2022</TD> <TD>LD</TD> </TR> <TR> <TD>95726</TD> <TD>27Mar2022</TD> <TD>CA</TD> </TR> <TR> <TD>16904</TD> <TD>28Mar2022</TD> <TD>LD</TD> </TR> <TR> <TD>95629</TD> <TD>28Mar2022</TD> <TD>CA</TD> </TR> <TR> <TD>16928</TD> <TD>29Mar2022</TD> <TD>LD</TD> </TR> <TR> <TD>95538</TD> <TD>29Mar2022</TD> <TD>CA</TD> </TR> <TR> <TD>16902</TD> <TD>30Mar2022</TD> <TD>LD</TD> </TR> <TR> <TD>95559</TD> <TD>30Mar2022</TD> <TD>CA</TD> </TR> <TR> <TD>16837</TD> <TD>31Mar2022</TD> <TD>LD</TD> </TR> <TR> <TD>95538</TD> <TD>31Mar2022</TD> <TD>CA</TD> </TR> <TR> <TD>16827</TD> <TD>01Apr2022</TD> <TD>LD</TD> </TR> <TR> <TD>95583</TD> <TD>01Apr2022</TD> <TD>CA</TD> </TR> <TR> <TD>16870</TD> <TD>02Apr2022</TD> <TD>LD</TD> </TR> <TR> <TD>95658</TD> <TD>02Apr2022</TD> <TD>CA</TD> </TR> <TR> <TD>16891</TD> <TD>03Apr2022</TD> <TD>LD</TD> </TR> <TR> <TD>95695</TD> <TD>03Apr2022</TD> <TD>CA</TD> </TR> <TR> <TD>16907</TD> <TD>04Apr2022</TD> <TD>LD</TD> </TR> <TR> <TD>95663</TD> <TD>04Apr2022</TD> <TD>CA</TD> </TR> <TR> <TD>16927</TD> <TD>05Apr2022</TD> <TD>LD</TD> </TR> <TR> <TD>95620</TD> <TD>05Apr2022</TD> <TD>CA</TD> </TR> <TR> <TD>16891</TD> <TD>06Apr2022</TD> <TD>LD</TD> </TR> <TR> <TD>95588</TD> <TD>06Apr2022</TD> <TD>CA</TD> </TR> <TR> <TD>16895</TD> <TD>07Apr2022</TD> <TD>LD</TD> </TR> <TR> <TD>95585</TD> <TD>07Apr2022</TD> <TD>CA</TD> </TR> <TR> <TD>16918</TD> <TD>08Apr2022</TD> <TD>LD</TD> </TR> <TR> <TD>95617</TD> <TD>08Apr2022</TD> <TD>CA</TD> </TR> <TR> <TD>16944</TD> <TD>09Apr2022</TD> <TD>LD</TD> </TR> <TR> <TD>95592</TD> <TD>09Apr2022</TD> <TD>CA</TD> </TR> <TR> <TD>16955</TD> <TD>10Apr2022</TD> <TD>LD</TD> </TR> <TR> <TD>95627</TD> <TD>10Apr2022</TD> <TD>CA</TD> </TR> <TR> <TD>16951</TD> <TD>11Apr2022</TD> <TD>LD</TD> </TR> <TR> <TD>95593</TD> <TD>11Apr2022</TD> <TD>CA</TD> </TR> <TR> <TD>16973</TD> <TD>12Apr2022</TD> <TD>LD</TD> </TR> <TR> <TD>95516</TD> <TD>12Apr2022</TD> <TD>CA</TD> </TR> <TR> <TD>17002</TD> <TD>13Apr2022</TD> <TD>LD</TD> </TR> <TR> <TD>95509</TD> <TD>13Apr2022</TD> <TD>CA</TD> </TR> <TR> <TD>17025</TD> <TD>14Apr2022</TD> <TD>LD</TD> </TR> <TR> <TD>95517</TD> <TD>14Apr2022</TD> <TD>CA</TD> </TR> <TR> <TD>17048</TD> <TD>15Apr2022</TD> <TD>LD</TD> </TR> <TR> <TD>95581</TD> <TD>15Apr2022</TD> <TD>CA</TD> </TR> <TR> <TD>17050</TD> <TD>16Apr2022</TD> <TD>LD</TD> </TR> <TR> <TD>95572</TD> <TD>16Apr2022</TD> <TD>CA</TD> </TR> <TR> <TD>17067</TD> <TD>17Apr2022</TD> <TD>LD</TD> </TR> <TR> <TD>95613</TD> <TD>17Apr2022</TD> <TD>CA</TD> </TR> <TR> <TD>17080</TD> <TD>18Apr2022</TD> <TD>LD</TD> </TR> <TR> <TD>95557</TD> <TD>18Apr2022</TD> <TD>CA</TD> </TR> <TR> <TD>17120</TD> <TD>19Apr2022</TD> <TD>LD</TD> </TR> <TR> <TD>95506</TD> <TD>19Apr2022</TD> <TD>CA</TD> </TR> <TR> <TD>17146</TD> <TD>20Apr2022</TD> <TD>LD</TD> </TR> <TR> <TD>95504</TD> <TD>20Apr2022</TD> <TD>CA</TD> </TR> <TR> <TD>17155</TD> <TD>21Apr2022</TD> <TD>LD</TD> </TR> <TR> <TD>95529</TD> <TD>21Apr2022</TD> <TD>CA</TD> </TR> <TR> <TD>17191</TD> <TD>22Apr2022</TD> <TD>LD</TD> </TR> <TR> <TD>95576</TD> <TD>22Apr2022</TD> <TD>CA</TD> </TR> <TR> <TD>17220</TD> <TD>23Apr2022</TD> <TD>LD</TD> </TR> <TR> <TD>95628</TD> <TD>23Apr2022</TD> <TD>CA</TD> </TR> <TR> <TD>17228</TD> <TD>24Apr2022</TD> <TD>LD</TD> </TR> <TR> <TD>95693</TD> <TD>24Apr2022</TD> <TD>CA</TD> </TR> <TR> <TD>17219</TD> <TD>25Apr2022</TD> <TD>LD</TD> </TR> <TR> <TD>95688</TD> <TD>25Apr2022</TD> <TD>CA</TD> </TR> <TR> <TD>17237</TD> <TD>26Apr2022</TD> <TD>LD</TD> </TR> <TR> <TD>95562</TD> <TD>26Apr2022</TD> <TD>CA</TD> </TR> <TR> <TD>17255</TD> <TD>27Apr2022</TD> <TD>LD</TD> </TR> <TR> <TD>95556</TD> <TD>27Apr2022</TD> <TD>CA</TD> </TR> <TR> <TD>17297</TD> <TD>28Apr2022</TD> <TD>LD</TD> </TR> <TR> <TD>95573</TD> <TD>28Apr2022</TD> <TD>CA</TD> </TR> <TR> <TD>17327</TD> <TD>29Apr2022</TD> <TD>LD</TD> </TR> <TR> <TD>95621</TD> <TD>29Apr2022</TD> <TD>CA</TD> </TR> <TR> <TD>17349</TD> <TD>30Apr2022</TD> <TD>LD</TD> </TR> <TR> <TD>95669</TD> <TD>30Apr2022</TD> <TD>CA</TD> </TR> <TR> <TD>17361</TD> <TD>01May2022</TD> <TD>LD</TD> </TR> <TR> <TD>95710</TD> <TD>01May2022</TD> <TD>CA</TD> </TR> <TR> <TD>17364</TD> <TD>02May2022</TD> <TD>LD</TD> </TR> <TR> <TD>95686</TD> <TD>02May2022</TD> <TD>CA</TD> </TR> <TR> <TD>17386</TD> <TD>03May2022</TD> <TD>LD</TD> </TR> <TR> <TD>95639</TD> <TD>03May2022</TD> <TD>CA</TD> </TR> <TR> <TD>17381</TD> <TD>04May2022</TD> <TD>LD</TD> </TR> <TR> <TD>95625</TD> <TD>04May2022</TD> <TD>CA</TD> </TR> <TR> <TD>17387</TD> <TD>05May2022</TD> <TD>LD</TD> </TR> <TR> <TD>95687</TD> <TD>05May2022</TD> <TD>CA</TD> </TR> <TR> <TD>17417</TD> <TD>06May2022</TD> <TD>LD</TD> </TR> <TR> <TD>95713</TD> <TD>06May2022</TD> <TD>CA</TD> </TR> <TR> <TD>17459</TD> <TD>07May2022</TD> <TD>LD</TD> </TR> <TR> <TD>95644</TD> <TD>07May2022</TD> <TD>CA</TD> </TR> <TR> <TD>95668</TD> <TD>08May2022</TD> <TD>CA</TD> </TR> <TR> <TD>17476</TD> <TD>08May2022</TD> <TD>LD</TD> </TR> <TR> <TD>17468</TD> <TD>09May2022</TD> <TD>LD</TD> </TR> <TR> <TD>95645</TD> <TD>09May2022</TD> <TD>CA</TD> </TR> <TR> <TD>17490</TD> <TD>10May2022</TD> <TD>LD</TD> </TR> <TR> <TD>95577</TD> <TD>10May2022</TD> <TD>CA</TD> </TR> <TR> <TD>17532</TD> <TD>11May2022</TD> <TD>LD</TD> </TR> <TR> <TD>95607</TD> <TD>11May2022</TD> <TD>CA</TD> </TR> <TR> <TD>17546</TD> <TD>12May2022</TD> <TD>LD</TD> </TR> <TR> <TD>95656</TD> <TD>12May2022</TD> <TD>CA</TD> </TR> <TR> <TD>17581</TD> <TD>13May2022</TD> <TD>LD</TD> </TR> <TR> <TD>95713</TD> <TD>13May2022</TD> <TD>CA</TD> </TR> <TR> <TD>17606</TD> <TD>14May2022</TD> <TD>LD</TD> </TR> <TR> <TD>95808</TD> <TD>14May2022</TD> <TD>CA</TD> </TR> <TR> <TD>17622</TD> <TD>15May2022</TD> <TD>LD</TD> </TR> <TR> <TD>95856</TD> <TD>15May2022</TD> <TD>CA</TD> </TR> <TR> <TD>17640</TD> <TD>16May2022</TD> <TD>LD</TD> </TR> <TR> <TD>95852</TD> <TD>16May2022</TD> <TD>CA</TD> </TR> <TR> <TD>17691</TD> <TD>17May2022</TD> <TD>LD</TD> </TR> <TR> <TD>95807</TD> <TD>17May2022</TD> <TD>CA</TD> </TR> <TR> <TD>17722</TD> <TD>18May2022</TD> <TD>LD</TD> </TR> <TR> <TD>95827</TD> <TD>18May2022</TD> <TD>CA</TD> </TR> <TR> <TD>17761</TD> <TD>19May2022</TD> <TD>LD</TD> </TR> <TR> <TD>95855</TD> <TD>19May2022</TD> <TD>CA</TD> </TR> <TR> <TD>17785</TD> <TD>20May2022</TD> <TD>LD</TD> </TR> <TR> <TD>95918</TD> <TD>20May2022</TD> <TD>CA</TD> </TR> <TR> <TD>17812</TD> <TD>21May2022</TD> <TD>LD</TD> </TR> <TR> <TD>96020</TD> <TD>21May2022</TD> <TD>CA</TD> </TR> <TR> <TD>17827</TD> <TD>22May2022</TD> <TD>LD</TD> </TR> <TR> <TD>96063</TD> <TD>22May2022</TD> <TD>CA</TD> </TR> <TR> <TD>17816</TD> <TD>23May2022</TD> <TD>LD</TD> </TR> <TR> <TD>96035</TD> <TD>23May2022</TD> <TD>CA</TD> </TR> <TR> <TD>17845</TD> <TD>24May2022</TD> <TD>LD</TD> </TR> <TR> <TD>95846</TD> <TD>24May2022</TD> <TD>CA</TD> </TR> <TR> <TD>17871</TD> <TD>25May2022</TD> <TD>LD</TD> </TR> <TR> <TD>95909</TD> <TD>25May2022</TD> <TD>CA</TD> </TR> <TR> <TD>17904</TD> <TD>26May2022</TD> <TD>LD</TD> </TR> <TR> <TD>95974</TD> <TD>26May2022</TD> <TD>CA</TD> </TR> <TR> <TD>17939</TD> <TD>27May2022</TD> <TD>LD</TD> </TR> <TR> <TD>96106</TD> <TD>27May2022</TD> <TD>CA</TD> </TR> <TR> <TD>17971</TD> <TD>28May2022</TD> <TD>LD</TD> </TR> <TR> <TD>96217</TD> <TD>28May2022</TD> <TD>CA</TD> </TR> <TR> <TD>17983</TD> <TD>29May2022</TD> <TD>LD</TD> </TR> <TR> <TD>96257</TD> <TD>29May2022</TD> <TD>CA</TD> </TR> <TR> <TD>18018</TD> <TD>30May2022</TD> <TD>LD</TD> </TR> <TR> <TD>96267</TD> <TD>30May2022</TD> <TD>CA</TD> </TR> <TR> <TD>18055</TD> <TD>31May2022</TD> <TD>LD</TD> </TR> <TR> <TD>96271</TD> <TD>31May2022</TD> <TD>CA</TD> </TR> <TR> <TD>18084</TD> <TD>01Jun2022</TD> <TD>LD</TD> </TR> <TR> <TD>96393</TD> <TD>01Jun2022</TD> <TD>CA</TD> </TR> <TR> <TD>18122</TD> <TD>02Jun2022</TD> <TD>LD</TD> </TR> <TR> <TD>96488</TD> <TD>02Jun2022</TD> <TD>CA</TD> </TR> <TR> <TD>18163</TD> <TD>03Jun2022</TD> <TD>LD</TD> </TR> <TR> <TD>96598</TD> <TD>03Jun2022</TD> <TD>CA</TD> </TR> <TR> <TD>18168</TD> <TD>04Jun2022</TD> <TD>LD</TD> </TR> <TR> <TD>96709</TD> <TD>04Jun2022</TD> <TD>CA</TD> </TR> <TR> <TD>18183</TD> <TD>05Jun2022</TD> <TD>LD</TD> </TR> <TR> <TD>96729</TD> <TD>05Jun2022</TD> <TD>CA</TD> </TR> <TR> <TD>18185</TD> <TD>06Jun2022</TD> <TD>LD</TD> </TR> <TR> <TD>96617</TD> <TD>06Jun2022</TD> <TD>CA</TD> </TR> <TR> <TD>18232</TD> <TD>07Jun2022</TD> <TD>LD</TD> </TR> <TR> <TD>96542</TD> <TD>07Jun2022</TD> <TD>CA</TD> </TR> <TR> <TD>18261</TD> <TD>08Jun2022</TD> <TD>LD</TD> </TR> <TR> <TD>96578</TD> <TD>08Jun2022</TD> <TD>CA</TD> </TR> <TR> <TD>18305</TD> <TD>09Jun2022</TD> <TD>LD</TD> </TR> <TR> <TD>96633</TD> <TD>09Jun2022</TD> <TD>CA</TD> </TR> <TR> <TD>18344</TD> <TD>10Jun2022</TD> <TD>LD</TD> </TR> <TR> <TD>96756</TD> <TD>10Jun2022</TD> <TD>CA</TD> </TR> <TR> <TD>18382</TD> <TD>11Jun2022</TD> <TD>LD</TD> </TR> <TR> <TD>96863</TD> <TD>11Jun2022</TD> <TD>CA</TD> </TR> <TR> <TD>18403</TD> <TD>12Jun2022</TD> <TD>LD</TD> </TR> <TR> <TD>96925</TD> <TD>12Jun2022</TD> <TD>CA</TD> </TR> <TR> <TD>18426</TD> <TD>13Jun2022</TD> <TD>LD</TD> </TR> <TR> <TD>96905</TD> <TD>13Jun2022</TD> <TD>CA</TD> </TR> <TR> <TD>18445</TD> <TD>14Jun2022</TD> <TD>LD</TD> </TR> <TR> <TD>96866</TD> <TD>14Jun2022</TD> <TD>CA</TD> </TR> <TR> <TD>18490</TD> <TD>15Jun2022</TD> <TD>LD</TD> </TR> <TR> <TD>96918</TD> <TD>15Jun2022</TD> <TD>CA</TD> </TR> <TR> <TD>18518</TD> <TD>16Jun2022</TD> <TD>LD</TD> </TR> <TR> <TD>96996</TD> <TD>16Jun2022</TD> <TD>CA</TD> </TR> <TR> <TD>18529</TD> <TD>17Jun2022</TD> <TD>LD</TD> </TR> <TR> <TD>97053</TD> <TD>17Jun2022</TD> <TD>CA</TD> </TR> <TR> <TD>18566</TD> <TD>18Jun2022</TD> <TD>LD</TD> </TR> <TR> <TD>97163</TD> <TD>18Jun2022</TD> <TD>CA</TD> </TR> <TR> <TD>18590</TD> <TD>19Jun2022</TD> <TD>LD</TD> </TR> <TR> <TD>97229</TD> <TD>19Jun2022</TD> <TD>CA</TD> </TR> <TR> <TD>18606</TD> <TD>20Jun2022</TD> <TD>LD</TD> </TR> <TR> <TD>97054</TD> <TD>20Jun2022</TD> <TD>CA</TD> </TR> <TR> <TD>18654</TD> <TD>22Jun2022</TD> <TD>LD</TD> </TR> <TR> <TD>97187</TD> <TD>22Jun2022</TD> <TD>CA</TD> </TR> <TR> <TD>18674</TD> <TD>23Jun2022</TD> <TD>LD</TD> </TR> <TR> <TD>97298</TD> <TD>23Jun2022</TD> <TD>CA</TD> </TR> <TR> <TD>18681</TD> <TD>24Jun2022</TD> <TD>LD</TD> </TR> <TR> <TD>97401</TD> <TD>24Jun2022</TD> <TD>CA</TD> </TR> <TR> <TD>18693</TD> <TD>25Jun2022</TD> <TD>LD</TD> </TR> <TR> <TD>97502</TD> <TD>25Jun2022</TD> <TD>CA</TD> </TR> <TR> <TD>18707</TD> <TD>26Jun2022</TD> <TD>LD</TD> </TR> <TR> <TD>97423</TD> <TD>26Jun2022</TD> <TD>CA</TD> </TR> <TR> <TD>18715</TD> <TD>27Jun2022</TD> <TD>LD</TD> </TR> <TR> <TD>97407</TD> <TD>27Jun2022</TD> <TD>CA</TD> </TR> <TR> <TD>18739</TD> <TD>28Jun2022</TD> <TD>LD</TD> </TR> <TR> <TD>97361</TD> <TD>28Jun2022</TD> <TD>CA</TD> </TR> <TR> <TD>18791</TD> <TD>29Jun2022</TD> <TD>LD</TD> </TR> <TR> <TD>97437</TD> <TD>29Jun2022</TD> <TD>CA</TD> </TR> <TR> <TD>18814</TD> <TD>30Jun2022</TD> <TD>LD</TD> </TR> <TR> <TD>97510</TD> <TD>30Jun2022</TD> <TD>CA</TD> </TR> <TR> <TD>18832</TD> <TD>01Jul2022</TD> <TD>LD</TD> </TR> <TR> <TD>97676</TD> <TD>01Jul2022</TD> <TD>CA</TD> </TR> <TR> <TD>18855</TD> <TD>02Jul2022</TD> <TD>LD</TD> </TR> <TR> <TD>97687</TD> <TD>02Jul2022</TD> <TD>CA</TD> </TR> <TR> <TD>18893</TD> <TD>03Jul2022</TD> <TD>LD</TD> </TR> <TR> <TD>97703</TD> <TD>03Jul2022</TD> <TD>CA</TD> </TR> <TR> <TD>18906</TD> <TD>04Jul2022</TD> <TD>LD</TD> </TR> <TR> <TD>97665</TD> <TD>04Jul2022</TD> <TD>CA</TD> </TR> <TR> <TD>18915</TD> <TD>05Jul2022</TD> <TD>LD</TD> </TR> <TR> <TD>97393</TD> <TD>05Jul2022</TD> <TD>CA</TD> </TR> <TR> <TD>18915</TD> <TD>06Jul2022</TD> <TD>LD</TD> </TR> <TR> <TD>97403</TD> <TD>06Jul2022</TD> <TD>CA</TD> </TR> <TR> <TD>18951</TD> <TD>07Jul2022</TD> <TD>LD</TD> </TR> <TR> <TD>97454</TD> <TD>07Jul2022</TD> <TD>CA</TD> </TR> <TR> <TD>18989</TD> <TD>08Jul2022</TD> <TD>LD</TD> </TR> <TR> <TD>97499</TD> <TD>08Jul2022</TD> <TD>CA</TD> </TR> <TR> <TD>19013</TD> <TD>09Jul2022</TD> <TD>LD</TD> </TR> <TR> <TD>97511</TD> <TD>09Jul2022</TD> <TD>CA</TD> </TR> <TR> <TD>19029</TD> <TD>10Jul2022</TD> <TD>LD</TD> </TR> <TR> <TD>97549</TD> <TD>10Jul2022</TD> <TD>CA</TD> </TR> <TR> <TD>19047</TD> <TD>11Jul2022</TD> <TD>LD</TD> </TR> <TR> <TD>97522</TD> <TD>11Jul2022</TD> <TD>CA</TD> </TR> <TR> <TD>19050</TD> <TD>12Jul2022</TD> <TD>LD</TD> </TR> <TR> <TD>97424</TD> <TD>12Jul2022</TD> <TD>CA</TD> </TR> <TR> <TD>19074</TD> <TD>13Jul2022</TD> <TD>LD</TD> </TR> <TR> <TD>97448</TD> <TD>13Jul2022</TD> <TD>CA</TD> </TR> <TR> <TD>19077</TD> <TD>14Jul2022</TD> <TD>LD</TD> </TR> <TR> <TD>97477</TD> <TD>14Jul2022</TD> <TD>CA</TD> </TR> <TR> <TD>19099</TD> <TD>15Jul2022</TD> <TD>LD</TD> </TR> <TR> <TD>97499</TD> <TD>15Jul2022</TD> <TD>CA</TD> </TR> <TR> <TD>19128</TD> <TD>16Jul2022</TD> <TD>LD</TD> </TR> <TR> <TD>97526</TD> <TD>16Jul2022</TD> <TD>CA</TD> </TR> <TR> <TD>19147</TD> <TD>17Jul2022</TD> <TD>LD</TD> </TR> <TR> <TD>97553</TD> <TD>17Jul2022</TD> <TD>CA</TD> </TR> <TR> <TD>19149</TD> <TD>18Jul2022</TD> <TD>LD</TD> </TR> <TR> <TD>97538</TD> <TD>18Jul2022</TD> <TD>CA</TD> </TR> <TR> <TD>19146</TD> <TD>19Jul2022</TD> <TD>LD</TD> </TR> <TR> <TD>97454</TD> <TD>19Jul2022</TD> <TD>CA</TD> </TR> <TR> <TD>19165</TD> <TD>20Jul2022</TD> <TD>LD</TD> </TR> <TR> <TD>97464</TD> <TD>20Jul2022</TD> <TD>CA</TD> </TR> <TR> <TD>19183</TD> <TD>21Jul2022</TD> <TD>LD</TD> </TR> <TR> <TD>97538</TD> <TD>21Jul2022</TD> <TD>CA</TD> </TR> <TR> <TD>19206</TD> <TD>22Jul2022</TD> <TD>LD</TD> </TR> <TR> <TD>97598</TD> <TD>22Jul2022</TD> <TD>CA</TD> </TR> <TR> <TD>19240</TD> <TD>23Jul2022</TD> <TD>LD</TD> </TR> <TR> <TD>97667</TD> <TD>23Jul2022</TD> <TD>CA</TD> </TR> <TR> <TD>19259</TD> <TD>24Jul2022</TD> <TD>LD</TD> </TR> <TR> <TD>97697</TD> <TD>24Jul2022</TD> <TD>CA</TD> </TR> <TR> <TD>19268</TD> <TD>25Jul2022</TD> <TD>LD</TD> </TR> <TR> <TD>97642</TD> <TD>25Jul2022</TD> <TD>CA</TD> </TR> <TR> <TD>19297</TD> <TD>26Jul2022</TD> <TD>LD</TD> </TR> <TR> <TD>97448</TD> <TD>26Jul2022</TD> <TD>CA</TD> </TR> <TR> <TD>19322</TD> <TD>27Jul2022</TD> <TD>LD</TD> </TR> <TR> <TD>97474</TD> <TD>27Jul2022</TD> <TD>CA</TD> </TR> <TR> <TD>19330</TD> <TD>28Jul2022</TD> <TD>LD</TD> </TR> <TR> <TD>97538</TD> <TD>28Jul2022</TD> <TD>CA</TD> </TR> <TR> <TD>19343</TD> <TD>29Jul2022</TD> <TD>LD</TD> </TR> <TR> <TD>97648</TD> <TD>29Jul2022</TD> <TD>CA</TD> </TR> <TR> <TD>19390</TD> <TD>30Jul2022</TD> <TD>LD</TD> </TR> <TR> <TD>97755</TD> <TD>30Jul2022</TD> <TD>CA</TD> </TR> <TR> <TD>19401</TD> <TD>31Jul2022</TD> <TD>LD</TD> </TR> <TR> <TD>97772</TD> <TD>31Jul2022</TD> <TD>CA</TD> </TR> <TR> <TD>19385</TD> <TD>01Aug2022</TD> <TD>LD</TD> </TR> <TR> <TD>97727</TD> <TD>01Aug2022</TD> <TD>CA</TD> </TR> <TR> <TD>19363</TD> <TD>02Aug2022</TD> <TD>LD</TD> </TR> <TR> <TD>97604</TD> <TD>02Aug2022</TD> <TD>CA</TD> </TR> <TR> <TD>19398</TD> <TD>03Aug2022</TD> <TD>LD</TD> </TR> <TR> <TD>97701</TD> <TD>03Aug2022</TD> <TD>CA</TD> </TR> <TR> <TD>19401</TD> <TD>04Aug2022</TD> <TD>LD</TD> </TR> <TR> <TD>97784</TD> <TD>04Aug2022</TD> <TD>CA</TD> </TR> <TR> <TD>19399</TD> <TD>05Aug2022</TD> <TD>LD</TD> </TR> <TR> <TD>97836</TD> <TD>05Aug2022</TD> <TD>CA</TD> </TR> <TR> <TD>19449</TD> <TD>06Aug2022</TD> <TD>LD</TD> </TR> <TR> <TD>97782</TD> <TD>06Aug2022</TD> <TD>CA</TD> </TR> <TR> <TD>19462</TD> <TD>07Aug2022</TD> <TD>LD</TD> </TR> <TR> <TD>97777</TD> <TD>07Aug2022</TD> <TD>CA</TD> </TR> <TR> <TD>19439</TD> <TD>08Aug2022</TD> <TD>LD</TD> </TR> <TR> <TD>97751</TD> <TD>08Aug2022</TD> <TD>CA</TD> </TR> <TR> <TD>19459</TD> <TD>09Aug2022</TD> <TD>LD</TD> </TR> <TR> <TD>97700</TD> <TD>09Aug2022</TD> <TD>CA</TD> </TR> <TR> <TD>19469</TD> <TD>10Aug2022</TD> <TD>LD</TD> </TR> <TR> <TD>97717</TD> <TD>10Aug2022</TD> <TD>CA</TD> </TR> <TR> <TD>19479</TD> <TD>11Aug2022</TD> <TD>LD</TD> </TR> <TR> <TD>97745</TD> <TD>11Aug2022</TD> <TD>CA</TD> </TR> <TR> <TD>19476</TD> <TD>12Aug2022</TD> <TD>LD</TD> </TR> <TR> <TD>97771</TD> <TD>12Aug2022</TD> <TD>CA</TD> </TR> <TR> <TD>19490</TD> <TD>13Aug2022</TD> <TD>LD</TD> </TR> <TR> <TD>97808</TD> <TD>13Aug2022</TD> <TD>CA</TD> </TR> <TR> <TD>19498</TD> <TD>14Aug2022</TD> <TD>LD</TD> </TR> <TR> <TD>97831</TD> <TD>14Aug2022</TD> <TD>CA</TD> </TR> <TR> <TD>19473</TD> <TD>15Aug2022</TD> <TD>LD</TD> </TR> <TR> <TD>97785</TD> <TD>15Aug2022</TD> <TD>CA</TD> </TR> </TBODY> </TABLE> Tue, 16 Aug 2022 12:56:19 GMT https://communities.sas.com/t5/SAS-Programming/flagged-end-of-the-month/m-p/828837#M327438 Eugenio211 2022-08-16T12:56:19Z Re: flagged end of the month https://communities.sas.com/t5/SAS-Programming/flagged-end-of-the-month/m-p/828838#M327439 <P>So simply a flag that is = 1 when the date is the last day of the month?</P> Tue, 16 Aug 2022 12:57:22 GMT https://communities.sas.com/t5/SAS-Programming/flagged-end-of-the-month/m-p/828838#M327439 PeterClemmensen 2022-08-16T12:57:22Z Re: flagged end of the month https://communities.sas.com/t5/SAS-Programming/flagged-end-of-the-month/m-p/828840#M327441 yes, my goal is just to get all the last day of the month. thanks. Tue, 16 Aug 2022 13:17:26 GMT https://communities.sas.com/t5/SAS-Programming/flagged-end-of-the-month/m-p/828840#M327441 Eugenio211 2022-08-16T13:17:26Z Re: flagged end of the month https://communities.sas.com/t5/SAS-Programming/flagged-end-of-the-month/m-p/828851#M327445 <P>&nbsp;</P> <PRE class="highlight"><CODE><SPAN class="n">if date</SPAN> <SPAN class="o">=</SPAN> <SPAN class="k">intnx</SPAN><SPAN class="p">(</SPAN><SPAN class="s1">'month'</SPAN><SPAN class="p">,</SPAN><SPAN class="n">date</SPAN><SPAN class="p">,</SPAN><SPAN class="mi">1</SPAN><SPAN class="p">)</SPAN><SPAN class="o">-</SPAN><SPAN class="mi">1</SPAN><SPAN class="p">;</SPAN></CODE></PRE> <P>&nbsp;or</P> <PRE>if date = intnx('month',date,0,'E');</PRE> Tue, 16 Aug 2022 14:08:54 GMT https://communities.sas.com/t5/SAS-Programming/flagged-end-of-the-month/m-p/828851#M327445 kelxxx 2022-08-16T14:08:54Z