May I ask a followup question, please. I was wondering if I have a column (comment) with text data in the same dataset then how do I split them into different columns (comment1, comment2, comment3, comment4, comment5)? I tried for long time, but failed. See the modified dataset below- data have; infile datalines dsd dlm=',' ; input name :$3. id :$3. reg_dates :MMDDYY10. test_dates :MMDDYY10. comment :$100.; datalines; abc,010,01/10/2017,01/20/2017,transferred to another hospital abc,010,01/10/2017,05/12/2017,case has been closed abc,010,08/01/2019,08/13/2019,unable to followup abc,010,10/02/2018,10/09/2018,admin closure def,023,02/11/2017,02/14/2017,transferred to another hospital def,023,07/03/2016,07/30/2016,unable to followup def,023,11/20/2017,11/26/2017,case has been closed def,023,11/20/2017,04/20/2018,unable to followup def,023,06/02/2017,07/02/2017,unable to followup pqr,125,05/10/2013,05/20/2013,transferred to another hospital xyz,200,09/12/2015,09/18/2015,case has been closed xyz,200,01/12/2016,11/22/2017,transferred to another hospital xyz,200,01/12/2016,01/21/2016,unable to followup ; run;
... View more