I am trying to update multiple columns using SQL update. It gives me error at highlighted and undelined area (at the end of the where clause)   proc sql; update want as a set CntA = (select coalesce(sum(A),0) , CntB = (select coalesce(sum(B),0) , CntC = (select coalesce(sum(C),0) , CntD = (select coalesce(sum(D),0) from have where (a.Originator = Originator) and (year) between (a.year)-8 and (a.failureyear)-1; quit;     ... View more

I am  using following macro to import and combine 40 excel sheet. But some of the fields are getting truncated. Is there a way to avoud truncation in the code below?    options mprint mlogic symbolgen; %macro merge(n);*n is the number of your xls files; %do i=1 %to &n; proc import out=datafile&i datafile="&&file&i" dbms=xls replace; sheet="XYZ"; getnames=yes; run; run; %end; data whole; set %do j=1 %to &n; datafile&j %end; ; run;   %mend merge; filename lib pipe 'dir "ABC\*.xls" /b'; data _null_; infile lib; input;list; run; data file; length filenames $ 140; infile lib truncover; input filenames : $; filenames="ABC\"||filenames; run; data null; set file; call symputx('file'||put(_n_,8. -L ),filenames,'G'); run; options sasautos=work; %merge(40) * there are 40 excel sheets that need to imported and combined*     ... View more