cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
MR1993
‎12-07-2017
  • 3 Posts
  • 0 Likes Given
  • 0 Solutions
  • 0 Likes Received

Re: Uninterrupted records with a given value

by Calcite | Level 5 in SAS Programming
‎12-04-2017 03:27 PM
‎12-04-2017 03:27 PM
Thanks!     When this happens, output the last two rows.   What you gonna do if data like:   7    15DEC2015    BC 7    15MAR2016    NO 7    25NOV2017    NO     ... View more

Re: Uninterrupted records with a given value

by Calcite | Level 5 in SAS Programming
‎12-01-2017 04:04 PM
‎12-01-2017 04:04 PM
Right. This line should not be in the output. 2 18AUG2017 IR ... View more

Uninterrupted records with a given value

by Calcite | Level 5 in SAS Programming
‎12-01-2017 02:36 PM
‎12-01-2017 02:36 PM
Hello, I am seeking help. I need to extract records with same TYPE ('NO', in this case) showing up uninterrupted based on each date. It is ok 'NO' showed up with other values, but they have to be uninterrupted with no other value on a differnent date in between (i.e. #6) and 'NO' also had to be the last time it showed up (#2 & 5).   Thank you ver much in advance!!! id   ISSUE_DATE   TYPE           2    16OCT2015    BC 2    16OCT2015    NO 2    15FEB2017    CD     2    15FEB2017    NO  5    16JAN2016    NO 5    20FEB2017    NO 6    10DEC2015    NO 6    16MAR2016    CD 6    21NOV2017    NO 7    15DEC2015    NO 7    15MAR2016    NO 7    25NOV2017    BC   Desired output with IDS 6 & 7 removed. id   ISSUE_DATE   TYPE           2    16OCT2015    BC 2    16OCT2015    NO 2    15FEB2017    CD     2    15FEB2017    NO  2    18AUG2017    IR 5    16JAN2016    NO 5    20FEB2017    NO ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎12-07-2017 05:57 PM
Quick links