That's because macro variables YEAR1 and YEAR2 are only defined in your parent SAS session and not in the RSUBMIT or child session. Add this statement after signing on to copy your macro variables over to the new session: %syslput _all_ / remote = &worker; ... View more

I am unfamiliar with this variable.  I tried using it as follows but it did not work properly.  It sent an email when the file was open but also when it was not open.  Let me know if this logic makes sense.   %macro price_tag; libname myxls OleDB init_string="Provider=Microsoft.ACE.OLEDB.12.0; data source = &Inputs; extended Properties=Excel 12.0"; data Recon_fx; set myxls.'Inp_Plan_Map_SAS'n; if syslibrc ne 0 then %err_email; %runquit;libname myxls clear; %mend price_tag; ... View more

I believe it is possible to use the scheduling capabilities of SAS Management Console without full administration rights.This is something a SAS administrator could sort out.   Perhaps you should ask your manager(s) that if they employed a builder to construct a new house and then said you can only use hand tools like hammers and handsaws not power saws and nail guns - does this sound sensible? In IT terms this is exactly the type of decision your managers are making ... View more

Describe your sas data, post a test data and what do you want to have in the pivot table. If you tried writing a code - what difficulties you had? up to what point did you advance ? ... View more