So it writes NOTES to the SAS log using the %PUT macro statement. The meaning of most of the parameters seems pretty obvious. I see only two tricky things here. 1) is the reference to the undefined macro variable MACRO.  I assume thta this macro is used in an environment where that macro variable is defined before this macro is called. 2) It will conditionally run the code in the a remote SAS/Connect session instead of the local SAS session where it is originally submitted. I checks the parameter SERVER to know which remote session to run on.  But it will only remote submit if the local session is running on a windows machine. ... View more

The code as such doesn't make sense. - there are no endrsubmit's for the rsubmit's, so it is unclear what is executed where - a dataset test is created, but never used - a dataset simon is used, but where does it come from?   I can guess that you get a lookup table from DB/2 that contains keys and id's. Your first step will be to import the data from the Excel file into SAS. Then you have to make sure that the customer id`s from Excel can be matched to those from DB/2 (same variable attributes, same contents). Then you can join the two tables on customer id. ... View more

All you need is a small change in 2nd step. If you want to count rows dismiss distinct  in 1st step.   proc sql;        select count(distinct custs)  into : cnt        from Yin.Accounts_final_sb; quit;   data  Yin.Pacs_all;   set  Yin.Pacs_all;         retain custs &cnt; run; ... View more