Instead of lag use RETAIN as in before your calculations: Retain Ref_Point_new . ; When you assign a new value to the Ref_Point_New variable it will be kept from iteration to iteration. ... View more

Following your logic I think the following should not have anything the Required column in your result 9FB83E1BFC68D743250F4D9AFFFFFFFF 9FB83E1BFC68D743250F4D9AFFFFFFFF 9FB83E1BFC68D743250F4D9AFFFFFFFF 9FB83E1BFC68D743250F4D9AFFFFFFFF 9FB83E1BFC68D743250F4D9AFFFFFFFF Try this code proc sort data=have out=have1 nodupkey; by var1 var2; run; data have1; set have1; where var2 ne ''; run; data have1; set have1; where index(var2, 'x19')> 0; run; proc sort data=have; by var1; proc sort data=have1 out=have2(rename=(var2=Required)) ; by var1; data want; merge have(in=a) have2(in=b); by var1; if a; run; ... View more

Hey i got it Thank you %let name = %sysfunc(scan(%sysget(SAS_EXECFILENAME),1,'.')); ... View more

Ok. thank you for helpful suggestion. will try any and get back to you. ... View more

I have worked on dataset which contains 850 columns. what exactly you are looking for? ... View more