Last time I used the second approach on the link.   Please find the log output as following:   data WORK.SAMPLE; infile datalines dsd truncover; input VAR1:$50. VAR2:MMDDYY10. Reason_1____:$20. Reason_2___:$23. _Reason_3:$24.; format VAR2 MMDDYY10.; label VAR1="Name      " VAR2="Visit Date      " Reason_1____="Reason 1    " Reason_2___="Reason 2   " _Reason_3=" Reason 3"; datalines; John 08/29/2018 Paying for clinic visits John                               11/04/2019 Insurance Navigation Paying for clinic visits Teresa 02/12/2017 Access to medical needs Teresa 06/21/2018 Access to medical needs Paying for clinic visits Teresa 12/12/2018 Insurance Navigation ;;;; ... View more

Thanks for the suggestion. Please find the data sample as following:   Create table sample(var1 varchar(50), var2 float, reason_1____ varchar(20), reason_2___ varchar(23), _reason_3 varchar(24)); Insert into sample(var1, var2, reason_1____, reason_2___, _reason_3) Values('', ., '', '', ''); Insert into sample(var1, var2, reason_1____, reason_2___, _reason_3) Values('John', 08/29/2018, '', '', 'Paying for clinic visits'); Insert into sample(var1, var2, reason_1____, reason_2___, _reason_3) Values('', ., '', '', ''); Insert into sample(var1, var2, reason_1____, reason_2___, _reason_3) Values('John                              ', 11/04/2019, 'Insurance Navigation', '', 'Paying for clinic visits'); Insert into sample(var1, var2, reason_1____, reason_2___, _reason_3) Values('', ., '', '', ''); Insert into sample(var1, var2, reason_1____, reason_2___, _reason_3) Values('Teresa', 02/12/2017, '', 'Access to medical needs', ''); Insert into sample(var1, var2, reason_1____, reason_2___, _reason_3) Values('', ., '', '', ''); Insert into sample(var1, var2, reason_1____, reason_2___, _reason_3) Values('Teresa', 06/21/2018, '', 'Access to medical needs', 'Paying for clinic visits'); Insert into sample(var1, var2, reason_1____, reason_2___, _reason_3) Values('', ., '', '', ''); Insert into sample(var1, var2, reason_1____, reason_2___, _reason_3) Values('Teresa', 12/12/2018, 'Insurance Navigation', '', ''); ... View more

Yes, I have the dataset to work with. The dataset has more than 30 variables. I need to extract the variables (as shown in the example) and consolidate the data. ... View more