Hi,   For the attached screenshot I want to have the values under __NAME__ appended to existing column names:       So output dataset will have only one row for a customer which will have column names snack_net_amount , breakfast_net_amount , snack_num_txns , breakfast_num_txns. Can someone please help me with this? I think I am missing something very basic, but since I am new to SAS, can't seem to figure it out. ... View more

Hi,   I have a dataset which looks like the below: id First_Qual_Month Txn_Month 1000361 Jul-19 Jul-19 1000361 Jul-19 Aug-19 1000361 Jul-19 Sep-19 100897 Jan-20 Oct-19 100897 Jan-20 Nov-19 100897 Jan-20 Dec-19 100897 Jan-20 Jan-20 100897 Jan-20 Feb-20 100897 Jan-20 Mar-20   I need to select only those rows for each id where the months are after the first_qual_month. I can select upto next 6 months of data per user. Can someone please help me on this? I am new to sas and first. doesn't look to be the solution! ... View more