Dear all, First of all, happy new year everyone. I'm a new user in using SAS program, and currently my company is using SAS Enterprise Guide for company's management reports. I'm currently stuck with this issue as below example, as in how to massage/amend the observations extracted from the system database: Acc_No Agent Src Branch_F Exec Trx DocType_A TFC Case No KU1234 Fairview Enterprise A KU KU KU 2 ABC6345 KL4321 AMG Marine X KL KL KL 3 C ABC6345 KL4321 AMG Marine X KL KL KL 4 C ABC6345 KL4322 Macro Trust Fund X KL KL KL 5 C ABC6345 To this using SAS: Acc_No Agent Src Branch_F Exec Trx DocType_A TFC Case No KU1234 Fairview Enterprise A KU KU KU 2 ABC6345 KU1234 Fairview Enterprise A KU KU KU 3 C ABC6345 KU1234 Fairview Enterprise A KU KU KU 4 C ABC6345 KU1234 Fairview Enterprise A KU KU KU 5 C ABC6345 The scenario is, when the data/records downloaded are sorted by column "Case No" & "TFC", those rows with TFC = "C" (in this example, which is row 2 to row 4) will copy the observations/information from Column "Acc_No" until "Trx" from the very first row of the same "Case No". Hope the experts here can help this beginner here. Thanks.
... View more