I’ve seen some folks use fuzzy matching based on amounts and time windows to catch reversed payments, but it’s never perfect. For smoother payment tracking, I’ve heard good things about Antom’s Secure online checkout—they’re a leading provider of payment processing services to merchants worldwide and might offer better reconciliation tools to avoid this mess altogether. ... View more

Here's a minor tweak on @FreelanceReinh 's suggestion.  This code avoids reading through the matching observations before accepting the "extras".  Instead, it uses "firstobs=" to jump directly to the extra obs in the longer dataset:   data _null_; if 0 then set BAU_0000_1_CASH_COLLECTED nobs=n1; if 0 then set BAU_0000_2_CASH_COLLECTED nobs=n2; if n1^=n2; fobs=min(n1,n2)+1; call execute ('data want;'); call execute (catx(' ','set',ifc(n1>n2,'BAU_0000_1_CASH_COLLECTED','BAU_0000_2_CASH_COLLECTED'),'(firstobs=',fobs,');')); call execute ('run;'); run; ... View more

Check if /USER/01_folder is the correct spelling. Is it really USER, not User or user? All-uppercase for a directory is very rare in UNIX systems. ... View more

Thanks! (Turns out I could have used proc transpose in the way I initially wanted before I ventured into Array's) ... View more

Thanks Tom! Really appreciate your time ... View more

So I don't have the ability to simply use 'ods excel' because it produces excel files which are full of nonsense i.e. special characters & symbols (guessing its a SAS config issue at my company). But the good news is I have now managed to replace the same steps using my current method of output using 'ods tagsets.excelbase'.    I didn't realise until now how many different variations there were with outputting and formatting data to Excel, so that should keep me busy upskilling for a few weeks. 🙂   Thanks for taking the time to reply - all the best! ... View more

Do you know the number in advance? %let n=5; Or do you need to calculate it? proc sql noprint; select max(count) into :n trimmed from (select var1,var2,count(*) as count from have group by var1,var2) ; quit; Once you have the count you can generate the variable definitions.   You could use macro code, but you would need to use a macro definition to allow the use of the %DO loop. length %do i=1 %to &n ; Nmbr_&i $14 Bal_&i 8 %end; ; array Nmbr_[5] ; array Bal_[5] ; Or you could generate the LENGTH statement with a data step. filename code temp; data _null_; file code column=cc; put 'length ' @; do i=1 to &n; put 'Nmbr_' i '$14 Bal_' i '8 ' @; if cc>65 then put / ' ' @ ; end; put ';' ; run; data want; %include code / source2; array Nmbr_[&n]; array Bal_[&n]; ....   ... View more