Is it possible to use an array to detect when a character value changes in one variable (ex: act_code = COFF COFF NC01) and then assign a value from another existing variable to a new variable? For example, whenever a change is encountered (COFF to NC01), I need SAS to use the corresponding account_time value for NC01 and assign that value to the new variable start_time (if NC01 then start_time = act_time).
act_code act_time start_time
NC01 75243 75243
CVIR 80543 80543
This is a tough one for me!!!
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!