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