Announcement

Collapse
No announcement yet.
X
Collapse
  • Page of 1
  • Filter
  • Time
  • Show
Clear All
new posts
  • #1

    Flag end dates which is greater than the end date, flag dates which are listed as 1900

    Dear All,

    Can you all help me with the following :

    Identify cases where the start date is after the end date
    Identify cases where the start date or end date has date (year 1899)
    Identify cases where the ThramNo and PlotId are same for the same bank

    Example of my data set

    Code:
    * Example generated by -dataex-. For more info, type help dataex
clear
input str62 Bank long(LoanStartDate LoanEndDate) int ThramNo str20    PlotId
"Bhutan Development Bank Limited"  21461 23287 843 "TOP-2083"
"Bhutan Development Bank Limited"  21461 23287 843 "TOP-3104"
"Bhutan Development Bank Limited"  21461 23287 843 "TOP-2083"
"Bhutan Development Bank Limited"  21461 23287 843 "TOP-2083"
"Bhutan Development Bank Limited"  23823 22355  35 "JAR-1195"
"Bhutan Development Bank Limited"  20536 22355  35 "JAR-1347"
"Bhutan Development Bank Limited"  21579 23416  67 "JAR-465" 
"Bhutan Development Bank Limited"  21579 23416  67 "JAR-250" 
"Bhutan Development Bank Limited"  21579 23416  67 "JAR-681" 
"Bhutan Development Bank Limited"  21579 23416  67 "JAR-465" 
"Bhutan Development Bank Limited"  21579 23416  67 "JAR-250" 
"Bhutan Development Bank Limited" -21915 23416  67 "JAR-681" 
"Bhutan Development Bank Limited"  21298 23079 118 "JAR-261" 
"Bhutan Development Bank Limited"  21298 23079 118 "JAR-261" 
"Bhutan Development Bank Limited"  21439 23283 121 "JAR-1198"
"Bhutan Development Bank Limited"  21439 23283 121 "JAR-1198"
"Bhutan Development Bank Limited"  21466 23171 122 "JAR-1216"
"Bhutan Development Bank Limited"  21466 23171 122 "JAR-1214"
"Bhutan Development Bank Limited" -21915 23171 118 "JAR-261" 
"Bhutan Development Bank Limited"  21466 23171 122 "JAR-1313"
"Bhutan Development Bank Limited"  21466 23171 122 "JAR-1214"
"Bhutan Development Bank Limited"  21466 23171 122 "JAR-1214"
"Bhutan Development Bank Limited"  21466 23171 122 "JAR-1196"
"Bhutan Development Bank Limited"  21466 23171 122 "JAR-1313"
"Bhutan Development Bank Limited"  20936 22759 127 "JAR-1050"
"Bhutan Development Bank Limited"  20936 22759 127 "JAR-1355"
"Bhutan Development Bank Limited"  20936 22759 127 "JAR-1184"
"Bhutan Development Bank Limited"  20936 22759 127 "JAR-1051"
"Bhutan Development Bank Limited"  20936 22759 127 "JAR-1050"
"Bhutan Development Bank Limited"  20936 22759 127 "JAR-1355"
"Bhutan Development Bank Limited"  20936 22759 127 "JAR-1184"
"Bhutan Development Bank Limited"  20936 22759 127 "JAR-1051"
"Bhutan Development Bank Limited"  21965 23800 143 "JAR-1351"
"Bhutan Development Bank Limited"  21965 23800 143 "JAR-1319"
"Bhutan Development Bank Limited"  21965 23800 143 "JAR-1256"
"Bhutan Development Bank Limited"  21510 22959 154 "JAR-306" 
"Bhutan Development Bank Limited"  21510 22959 154 "JAR-306" 
"Bhutan Development Bank Limited"  22763 24560 182 "JAR-77"  
"Bhutan Development Bank Limited"  22763 24560 182 "JAR-76"  
"Bhutan Development Bank Limited"  22763 24560 182 "JAR-19"  
"Bhutan Development Bank Limited"  22763 24560 182 "JAR-89"  
"Bhutan Development Bank Limited"  21173 22989 187 "JAR-122" 
"Bhutan Development Bank Limited"  21173 22989 187 "JAR-40"  
"Bhutan Development Bank Limited"  21173 22989 187 "JAR-122" 
"Bhutan Development Bank Limited"  21173 22989 187 "JAR-40"  
"Bhutan Development Bank Limited"  21214 22321 218 "JAR-1095"
"Bhutan Development Bank Limited"  21214 22321 218 "JAR-1095"
"Bhutan Development Bank Limited"  21082 22898 222 "JAR-270" 
"Bhutan Development Bank Limited"  22103 22817 227 "JAR-1454"
"Bhutan Development Bank Limited"  22103 22817 227 "JAR-1453"
"Bhutan Development Bank Limited"  22103 22817 227 "JAR-1455"
"Bhutan Development Bank Limited"  21985 23810 332 "JAR-666" 
"Bhutan Development Bank Limited"  21985 23810 332 "JAR-162" 
"Bhutan Development Bank Limited"  21985 23810 332 "JAR-1534"
"Bhutan Development Bank Limited"  21985 23810 332 "JAR-667" 
"Bhutan Development Bank Limited"  21985 23810 332 "JAR-789" 
"Bhutan Development Bank Limited"  21985 23810 332 "JAR-666" 
"Bhutan Development Bank Limited"  21985 23810 332 "JAR-162" 
"Bhutan Development Bank Limited"  21985 23810 332 "JAR-1534"
"Bhutan Development Bank Limited"  21985 23810 332 "JAR-667" 
"Bhutan Development Bank Limited"  21985 23810 332 "JAR-789" 
"Bhutan Development Bank Limited"  22727 24540 336 "JAR-1283"
"Bhutan Development Bank Limited"  22727 24540 336 "jar-1282"
"Bhutan Development Bank Limited"  22727 24540 336 "JAR-1546"
"Bhutan Development Bank Limited"  22727 24540 336 "jar-1547"
"Bhutan Development Bank Limited"  22727 24540 336 "jar-1549"
"Bhutan Development Bank Limited"  22727 24540 336 "JAR-1283"
"Bhutan Development Bank Limited"  22727 24540 336 "jar-1282"
"Bhutan Development Bank Limited"  22727 24540 336 "JAR-1546"
"Bhutan Development Bank Limited"  22727 24540 336 "jar-1547"
"Bhutan Development Bank Limited"  22727 24540 336 "jar-1549"
"Bhutan Development Bank Limited"  21310 23020 353 "JAR-1852"
"Bhutan Development Bank Limited"  22727 24530 363 "JAR-1340"
"Bhutan Development Bank Limited"  22727 24530 363 "JAR-1285"
"Bhutan Development Bank Limited"  22727 24530 363 "JAR-1225"
"Bhutan Development Bank Limited"  22727 24530 363 "JAR-1340"
"Bhutan Development Bank Limited"  22727 24530 363 "JAR-1285"
"Bhutan Development Bank Limited"  22727 24530 363 "JAR-1225"
"Bhutan Development Bank Limited"  21269 23830  52 "TSR-4119"
"Bhutan Development Bank Limited"  21269 23830  52 "TSR-1875"
"Bhutan Development Bank Limited"  21776 24348  83 "TSR-728" 
"Bhutan Development Bank Limited"  21776 24348  83 "TSR-713" 
"Bhutan Development Bank Limited"  21776 24348  83 "TSR-264" 
"Bhutan Development Bank Limited"  21776 24348  83 "TSR-753" 
"Bhutan Development Bank Limited"  21353 23922  95 "TSR-1022"
"Bhutan Development Bank Limited"  21353 23922  95 "TSR-524" 
"Bhutan Development Bank Limited"  21196 23772 113 "TSR-4555"
"Bhutan Development Bank Limited"  21196 23772 113 "TSR-1459"
"Bhutan Development Bank Limited"  21196 23772 113 "TSR-1293"
"Bhutan Development Bank Limited"  21196 23772 113 "TSR-3157"
"Bhutan Development Bank Limited"  21196 23772 113 "TSR-1382"
"Bhutan Development Bank Limited"  21196 23772 113 "TSR-1381"
"Bhutan Development Bank Limited"  21525 24088 121 "TSR-660" 
"Bhutan Development Bank Limited"  21525 24088 121 "TSR-660" 
"Bhutan Development Bank Limited"  21675 24256 137 "TSR-1024"
"Bhutan Development Bank Limited"  21675 24256 137 "TSR-1024"
"Bhutan Development Bank Limited"  21312 23891 157 "TSR-2300"
"Bhutan Development Bank Limited"  21312 23891 157 "TSR-1160"
"Bhutan Development Bank Limited"  21312 23891 157 "TSR-1081"
"Bhutan Development Bank Limited"  21312 23891 157 "TSR-1032"
end
format %td LoanStartDate
format %td LoanEndDate

    Thank you
    Tags: None
  • #2
    Sorry the last question was to Identify cases where the ThramNo and PlotId are same for the different bank

    Comment

    • #3

      1.

      Code:
       
 list if LoanStartDate > LoanEndDate
      2.

      Code:
      * ??? 
list if inlist(1899, year(LoanStartDate), year(LoanEndDate))
      3.

      This FAQ https://www.stata.com/support/faqs/d...ions-in-group/ may help.

      Comment

      • #4
        Nick Cox thank you can you also help me identify cases where the Varibales Thramno and PlotID is same for Two different banks.

        For example flag cases like the one below

        ThramNo PlotId Bank

        843 "TOP-2083" Bhutan Development Bank Limited 843 "TOP-2083" Bank of Bhutan

        Comment

        • #5
          #8 looks the same to me as whether some identifier is associated with different banks.

          Comment

          • #6
            Since I Have only uploaded 200 of my cases there are cases where these issue is there. Can you help me identify

            copy starting from the next line --------------------- -
            Code:
            * Example generated by -dataex-. For more info, type help dataex
clear
input str62 Bank long(LoanStartDate LoanEndDate) int ThramNo str20 PlotId
"Bhutan Development Bank Limited"                   .     . -7777 "KAD-3511  "
"Royal Insurance Corporation of Bhutan Limited"     .     .    -2 "BJ1-16"    
"Bank of Bhutan"                                21794 24441     1 "11U-17"    
"Royal Insurance Corporation of Bhutan Limited"     .     .     1 "13U-2233"  
"National Pension and Provident Fund"           17783 24107     1 "1U-260"    
"National Pension and Provident Fund"           17783 24107     1 "1U-260"    
"Bhutan National Bank Limited"                      .     .     1 "5U-1"      
"Bank of Bhutan"                                21678 24319     1 "8U-1"      
"Bank of Bhutan"                                21678 24319     1 "8U-1"      
"Bhutan National Bank Limited"                  21852 29106     1 "8U-31"     
"Bhutan Development Bank Limited"                   .     .     1 "BAR-1228"  
"Bhutan Development Bank Limited"                   .     .     1 "BAR-1245"  
"Bhutan National Bank Limited"                      .     .     1 "BAR-1228"  
"Bhutan Development Bank Limited"                   .     .     1 "BAR-1824"  
"Bhutan Development Bank Limited"                   .     .     1 "BAR-2374"  
"Bank of Bhutan"                                    .     .     1 "BAR-1228"  
"Bhutan Development Bank Limited"                   .     .     1 "BAR-2438"  
"Bhutan Development Bank Limited"                   .     .     1 "BAR-2479"  
"Bhutan Development Bank Limited"                   .     .     1 "BAR-2569"  
"Bhutan Development Bank Limited"                   .     .     1 "BAR-2571"  
"Bhutan Development Bank Limited"                   .     .     1 "BAR-3039"  
"Bhutan Development Bank Limited"                   .     .     1 "BAR-3040"  
"Bhutan Development Bank Limited"                   .     .     1 "BAR-5050"  
"Bhutan Development Bank Limited"                   .     .     1 "BAR-5052"  
"Bhutan Development Bank Limited"                   .     .     1 "BAR-522"   
"Bhutan Development Bank Limited"                   .     .     1 "BAR-523"   
"Bhutan Development Bank Limited"                   .     .     1 "BAR-5322"  
"Bhutan Development Bank Limited"                   .     .     1 "BAR-863"   
"Bhutan Development Bank Limited"                   .     .     1 "BAR-872"   
"Bhutan Development Bank Limited"               22190 24016     1 "BAS-495"   
"Bhutan Development Bank Limited"               22190 24016     1 "BAS-496"   
"Bhutan Development Bank Limited"               22190 24016     1 "BAS-7"     
"Bhutan Development Bank Limited"               21364 22704     1 "BET-2183"  
"Bhutan Development Bank Limited"               21364 22704     1 "BET-2183"  
"Bhutan Development Bank Limited"               21364 22704     1 "BET-2184"  
"Bhutan Development Bank Limited"               21364 22704     1 "BET-2184"  
"Bhutan Development Bank Limited"               21999 25023     1 "BID-1084"  
"Bhutan Development Bank Limited"               21999 25023     1 "BID-1084"  
"Bhutan Development Bank Limited"               21999 25023     1 "BID-1087"  
"Bhutan Development Bank Limited"               21999 25023     1 "BID-1087"  
"Bhutan Development Bank Limited"               21999 25023     1 "BID-1125"  
"Bhutan Development Bank Limited"               21999 25023     1 "BID-1125"  
"Bhutan Development Bank Limited"               21999 25023     1 "BID-1129"  
"Bhutan Development Bank Limited"               21999 25023     1 "BID-1129"  
"Bhutan Development Bank Limited"               21999 25023     1 "BID-1172"  
"Bhutan Development Bank Limited"               21999 25023     1 "BID-1172"  
"Bhutan Development Bank Limited"               21999 25023     1 "BID-1236"  
"Bhutan Development Bank Limited"               21999 25023     1 "BID-1236"  
"Bhutan Development Bank Limited"               21999 25023     1 "BID-1751"  
"Bhutan Development Bank Limited"               21999 25023     1 "BID-1751"  
"Bhutan Development Bank Limited"               21999 25023     1 "BID-1766"  
"Bhutan Development Bank Limited"               21999 25023     1 "BID-1766"  
"Bhutan Development Bank Limited"               21999 25023     1 "BID-5019"  
"Bhutan Development Bank Limited"               21999 25023     1 "BID-5019"  
"Bhutan Development Bank Limited"               21999 25023     1 "BID-888"   
"Bhutan Development Bank Limited"               21999 25023     1 "BID-888"   
"Bhutan Development Bank Limited"               21999 25023     1 "BID-889"   
"Bhutan Development Bank Limited"               21999 25023     1 "BID-889"   
"Bhutan Development Bank Limited"               21999 25023     1 "BID-906"   
"Bhutan Development Bank Limited"               21999 25023     1 "BID-906"   
"Druk PNB Bank Limited"                         18606 26449     1 "BJ1-28"    
"Bhutan Development Bank Limited"                   .     .     1 "BJA-1172"  
"Bhutan Development Bank Limited"                   .     .     1 "BJA-1172"  
"Bhutan Development Bank Limited"                   .     .     1 "BJA-34"    
"Bhutan Development Bank Limited"               22831 23841     1 "BON-140"   
"Bhutan Development Bank Limited"               22831 23841     1 "BON-140"   
"Bhutan Development Bank Limited"               21342 23076     1 "BUM-1450"  
"Bhutan Development Bank Limited"               21342 23076     1 "BUM-1450"  
"Bhutan Development Bank Limited"               21342 23076     1 "BUM-1452"  
"Bhutan Development Bank Limited"               21342 23076     1 "BUM-1452"  
"Bhutan Development Bank Limited"               21342 23076     1 "BUM-4661"  
"Bhutan Development Bank Limited"               21342 23076     1 "BUM-4661"  
"Bhutan Development Bank Limited"                   .     .     1 "CHK-1791"  
"Bhutan Development Bank Limited"                   .     .     1 "CHK-1803"  
"Bhutan Development Bank Limited"                   .     .     1 "CHK-1804"  
"Bhutan Development Bank Limited"                   .     .     1 "CHK-1809"  
"Bhutan Development Bank Limited"                   .     .     1 "CHK-1810"  
"Bhutan Development Bank Limited"               20751 27972     1 "DAN-1199"  
"Bhutan Development Bank Limited"               20751 27972     1 "DAN-3015"  
"Bhutan Development Bank Limited"               20751 27972     1 "DAN-3021"  
"Bhutan Development Bank Limited"                   .     .     1 "DOG-3519"  
"Bhutan Development Bank Limited"                   .     .     1 "DOG-522  " 
"Bhutan Development Bank Limited"               21162 25652     1 "DOT-1396"  
"Bhutan Development Bank Limited"               21481 24129     1 "DOT-1396"  
"Bhutan Development Bank Limited"               21481 24129     1 "DOT-1396"  
"Bhutan Development Bank Limited"               21481 24129     1 "DOT-5067"  
"Bhutan Development Bank Limited"               21481 24129     1 "DOT-5067"  
"Bhutan Development Bank Limited"               21481 24129     1 "DOT-5069"  
"Bhutan Development Bank Limited"               21481 24129     1 "DOT-5069"  
"Bhutan Development Bank Limited"               21481 24129     1 "DOT-803"   
"Bhutan Development Bank Limited"               21162 25652     1 "DOT-803"   
"Bhutan Development Bank Limited"               21481 24129     1 "DOT-803"   
"Bhutan Development Bank Limited"               21481 24129     1 "DOT-808"   
"Bhutan Development Bank Limited"               21481 24129     1 "DOT-808"   
"Bhutan Development Bank Limited"               21481 24129     1 "DOT-809"   
"Bhutan Development Bank Limited"               21481 24129     1 "DOT-809"   
"Bhutan Development Bank Limited"               21162 25652     1 "DOT-810"   
"Bhutan Development Bank Limited"               21162 25652     1 "DOT-823"   
"Bhutan Development Bank Limited"               21162 25652     1 "DOT-827"   
"Bhutan Development Bank Limited"               21162 25652     1 "DOT-828"   
end
format %td LoanStartDate
format %td LoanEndDate
            copy up to and including the previous line ---------------- -

            Comment

            • #7
              Nick Cox

              Comment

              • #8
                I am not room service! Sorry, but I don't know what different question what you're asking. Please try to apply the principles explained after reading the FAQ.
                • 1 like

                Comment

                • #9
                  Nick Cox There are two variables (THramNo and PlotID) that needs to be checked. In your example there is only variable.

                  Comment

                  • #10
                    Sure: just check them one at a time. Or jointly:

                    Code:
                    bysort whatever (a b) : gen diff = (a[1] != a[_N]) | (b[1] != b[_N])
                    might fit what you need. Not tested.

                    Sometimes it's easier to check for sameness.
                    Last edited by Nick Cox; 10 Aug 2022, 05:11.

                    Comment

                    Previous Next
                    Working...
                    X