02-03-2014 05:07 PM
I have a code that I can execute in my local machine without any problem. Now I want to submit my code to the remote server for executing. I need to make a some adjustments. In my code I have many macro variables defined using %let. As well as some dataset in my local machine. To submit the code to remote server, I have the following paragraph.
%let wrds=wrds.wharton.upenn.edu 4016;
options comamid=TCP remote=WRDS;
signon username= xxxxxx;
My question is where I should put my defined macro variables as well as dataset.
02-03-2014 10:27 PM
The question is where do you want your macro variables to be resolved? On your local machine, your remote server, or both?
I suggest you explore the %SYSLPUT and %SYSRPUT macro statements. They allow you to assign macro variables between local to remote SAS sessions.