Hi, I would like to create separate columns (Line1 to LineN) to split individual sentences in a paragraph (column name is Comments) using SAS arrays. This is how I envisioned it to be: Comment: Traffic data for South Entrance is estimated. Traffic counter was inoperable from December 1-7 due to new counter installation. Estimated data generated by taking daily average from December 8-31... Line1: Traffic data for South Entrance is estimated. Line2: Traffic counter was inoperable from December 1-7 due to new counter installation. Line3: Estimated data generated by taking daily average from December 8-31... Using the code below, I was able to identify that the maximum number of sentences there is in a Comment value is 17. I assume this will be the dimension for my array (?) proc sql noprint; select max(NumSentences) into :max_cnt trimmed from work.SouthRim; quit; %put &=max_cnt; I am thinking of using count, find and substr functions but do not know how and where to start. Can you please help me? Many thanks in advance!
... View more