you may need to use prxnext. prxparse('/(ProviderName:\s+[a-zA-z ]+?;)/') indicates providers name folowed by space and words and till the ; prxnext capture position and length wherever you have this pattern. by doing substr(prov_info, position+13, length-13, we can remove ProviderName:     data have; Prov_Info ="ProviderName: Spine and Pain Center of Whatchamikola; IDN: 2345678901; IsGroup: No;, ProviderName: Happy Toes; IDN: 3456789012; IsGroup: No;, ProviderName: IDN: 3456789012; IsGroup: Yes;, ProviderName: Bright Smiles of AZ; IDN: 1234567890 IsGroup: Yes;, "; run; data want; length val patternid $200.; set have; start = 1; stop = length(prov_info); re = prxparse('/(ProviderName:\s+[a-zA-z ]+?;)/'); set have; call prxnext(re, start, stop, trim(prov_info), position, length); do while (position > 0); val = substr(prov_info, position+13, length-13); patternID = catx(" ", patternid, val); call prxnext(re, start, stop, trim(prov_info), position, length); end; drop re start stop position length val; run; proc print data=want; run;   ... View more

something like this using proc transpose or    data have; infile datalines dlm='09'x missover; input id date:yymmdd10. code1 code2 code3; format date yymmdd10.; datalines; 1 2010-04-12 01.01 01.02 1 2011-02-20 01.01 01.02 1 2012-08-24 02.05 01.01 01.02 2 2012-08-19 01.01 2 2012-10-10 01.09 01.01 2 2015-01-27 01.01 01.09 3 2014-05-02 03.02 3 2014-12-16 01.01 03.02 4 2010-03-28 03.05 ; proc sort data=have out=have1; by id date; run; proc transpose data=have1 out=want(rename=(col1=code) drop =_name_ where=(code ne .)); by id date; var code1 code2 code3; run;  or by array     data want (drop = code1 code2 code3 i where=(code ne .)); set have; array co(*) code1 code2 code3; do i= 1 to dim(co) ; code= co(i); output; end; run;   ... View more

this is good case for using hash technique. I made data using Sashelp.class so that you can try out. here we are making flags based on name present in particular dataset      data class_female; set sashelp.class(where=(sex='F')); run; data class_male; set sashelp.class(where=(sex='M')); run; data want; if _n_=1 then do; if _n_ = 0 then set sashelp.class; dcl hash h1(dataset: 'class_female'); h1.definekey("Name"); h1.definedone(); dcl hash h2(dataset: 'class_male'); h2.definekey("Name"); h2.definedone(); end; set sashelp.class; call missing(female_flag); if h1.find() = 0 then female_flag =1; else female_flag = 0 ; if h2.find() = 0 then male_flag =1; else male_flag = 0 ; run;   ... View more