Hey I have the same problem. How did u solve it? I have a big dataset with over 300 observations and I have the startingdate and the endingdate dd/mm/yyyy and I want to calculate the duration for each observation. Can you write me the code for that? I didnt quite understand it 😞 Thank you so much! Cheers, Mary ... View more

On unix you can use the filelocks=none option in the library statement, which allow read access to multiple processes at the same time. Example:   libname mydata '/data' access=readonly filelocks=none; ... View more

Wow! Why not just merge the tables? data B ;   input rate_assignment_name $ ; cards; A B B C ;;;; data A;   input ID rate_assignment_name $ ; cards; 1 A 2 B 3 D ;;;; data want ;   merge A (in=in1) B (in=in2) ;   by rate_assignment_name  ;   if in1 ;   if first.rate_assignment_name then cnt=0;   cnt + in2 ;   if last.rate_assignment_name then do;     if cnt=0 then RAerror='Enter Valid Rate Assignment Name';     else if cnt=1 then RAerror=' ';     else RAerror='Too many matches';     output;   end; run; You could join them using PROC SQL code: proc sql noprint ;   create table STATIC.STATUS as     select a.*        , case when (b.rate_assignment_name is not null) then ' '                             else 'Enter Valid Rate Assignment Name'           end as RAerror     from STATIC.Manual_correction a       left join SASDEV.EDM_RATE_ASSIGNMENT b       on a.rate_assignment_name = b.rate_assignment_name   ; quit; If the lookup table has an index you could even count the matches in a data step. data B (index=(rate_assignment_name));   input rate_assignment_name $ ; cards; A B B C ;;;; data A;   input ID rate_assignment_name $ ; cards; 1 A 2 D 3 B ;;;; data want ;   set A ;   do cnt=0 by 1 until (_iorc_) ;      set B key=rate_assignment_name  ;   end; _error_=0;   if cnt=0 then RAerror='Enter Valid Rate Assignment Name';   else if cnt=1 then RAerror=' ';   else RAerror='Too many matches'; run; ... View more

Thanks Quentin Call Execute Worked for me. ... View more