Formula usage: How to create second column based on retained values from first column?
Nov 21, 2013 1:33 AM(6617 views)
Hi, a recurring tasks can be seen in the attached JMP data table example. A first column has row values, that need to be continued for more rows than where the first column has the value. In thye example the first column has the numbers 1, 2, 3 etc mixed with letters (or any other irrevelant information). Now, the value of the second column should always be equal to the last value encountered in the first column. When a new number is seen in the first column, that value should be continued. Sounds complicated, but looks simpler in the table.
Any help appreciated. (In base SAS retain would do the job.)