Hi SAS community, I am wondering how I might be able to identify different observations under the same variable by creating a dummy variable I want to create a dummy variable called initial_product to identify which was the first product customers chose before they change to another product. The dataset I want to get looks like this ( I already have ID and product variables and observations), How do I create the variable initial_product ? ID product Initial_product 1 A Y 1 A Y 1 B N 2 B Y 2 C N 2 C N 3 A Y 3 B N 3 B N I would appreciate any comments or suggestions. I tried lag function, first.id/last.id but none of this gets me what I want. Thanks
... View more