Hello, I’m trying to create a flag named prod in the below code which basically should compare column Status in each row by EMPID. The prod flag should be ‘Y’ if the EMPID has different values in status columns or else it should be ‘N’, meaning they have the same status in all the rows. Source Data Set: Data aa; infile cards; input EMPID $3. @5 Status $3.; cards; 123 Opn 123 Opn 345 Cld 345 Opn 567 Cld 567 Cld 567 Cld 999 Opn 984 Cld 236 Cld 236 Cld 236 Opn ; Run; Desired output: EMPID Status Prod 123 Opn N 123 Opn N 345 Cld Y 345 Opn Y 567 Cld N 567 Cld N 567 Cld N 999 Opn N 984 Cld N 236 Cld Y 236 Cld Y 236 Opn Y My Code: Data aa1; retain PROD; set aa; by EMPID Status; if first.Status = last.Status then PROD = 'N'; else PROD = 'N'; Run; So in the above case, EMPID 236 Prod is ‘Y’ because they have 2 diff status values(Cld,Opn) whereas EMPID 123 is ‘N’ because the status is same for both the rows. I tried using first and last method but the output wasn’t the way I expected. I am beginner SAS programmer so wondering if I could get some help to code this one. Thanks in advance for your help!
... View more