@dpa  Forgot to add a Retain statement so variable drug_list doesn't get re-initialized for every iteration of the data step. Below code that should be o.k. data want; set have; by id seq; length drug_list $1000; retain drug_list; drug_list=catx(',',drug_list,drug); if last.seq then do; output; call missing(drug_list); end; drop drug; run; ... View more

Please do not re-open an old question.  If you have a new question, open a new post.  Include in your post test data - in the form of a datastep - and what the output should look like.  Also, be clear as to the logic behind gettnig the output.  In your description below you mention nothing of which row to take, 3, 3 appears once, however 3,2 appears multiple times, so which one should it be? ... View more

27         data _null_; 28           x='12december2015'; 29           y=input(x,anydtdte32.); 30           put y= date9.; 31         run; y=12DEC2015  with SAS9.4 on WINx64 y=12DEC2015  with SAS9.4 on LINx64 y=.                    with SAS9.3 on Z/OS   This works in 9.3:   data _null_;   X='12december2015';   Y=input(prxchange('s/(\d{2}\w{3})\w*(\d{4})/$1$2/',1,X),date9.);   put Y= date9.; run; ... View more

Thank you for your help ... View more

Ok. I didn't copy paste It happened coz of version change. BUt worked. ... View more