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: 
kashish_joker
‎10-29-2018
  • 3 Posts
  • 1 Likes Given
  • 0 Solutions
  • 2 Likes Received

Re: To find out the dates on which status changes

by Fluorite | Level 6 in SAS Programming
‎08-30-2018 05:38 AM
‎08-30-2018 05:38 AM
Thanks for your quick response.   But need more help on this, I am attaching the output that I an getting with your code(Namiing: HAVE). Their ia a issue in that the red_date is not updating, it is showing the first date but I want red_date must be latest date on which status goes "OFF"  for you help also attaching the output needed(Namming: WANT).     ... View more

To find out the dates on which status changes

by Fluorite | Level 6 in SAS Programming
‎08-30-2018 04:48 AM
2 Likes
‎08-30-2018 04:48 AM
2 Likes
Hello All,   Here i am having a data which contain a field status which varies with respect to date, what I want is find the dates on which its status get OFF and after getting OFF on which date if start working. data have; input key System_Date $ status $; datalines; 1 1-08-18 ON 1 2-08-18 OFF 1 3-08-18 OFF 1 4-08-18 OFF 1 5-08-18 OFF 2 1-08-18 ON 2 2-08-18 OFF 2 3-08-18 OFF 2 4-08-18 OFF 2 5-08-18 ON ; run;   this is how I want the output   key System_Date $ status $ red_date $ green_date $ 1   1-08-18             ON 1   2-08-18            OFF  2-08-18 1   3-08-18            OFF  2-08-18 1   4-08-18            OFF  2-08-18 1   5-08-18            OFF   2-08-18 2   1-08-18            ON 2   2-08-18           OFF  2-08-18 2   3-08-18           OFF  2-08-18 2   4-08-18           OFF  2-08-18 2   5-08-18           ON    2-08-18             5-08-18   Thanks in Advance. ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎10-29-2018 03:27 AM
Likes given to
View All
Likes from
View All
Quick links