topic Re: How to %SYSLPUT or %SYSRPUT Locally? in SAS Programming

How to %SYSLPUT or %SYSRPUT Locally?

Junyong — Tue, 19 Jan 2021 00:33:19 GMT

%syslput and %sysrput assign a global macro variable as a result.

/*remote access*/
%let wrds=wrds.wharton.upenn.edu 4016;
signon wrds username=_prompt_;

/*pass local macro ONE to remote*/
%macro one(one);
%syslput one=&one;
rsubmit;
%put &one;
endrsubmit;
%mend;

/*prints 1234 remotely*/
%one(1234)

/*ONE works globally*/
rsubmit;
%sysrput one=&one;
endrsubmit;

/*prints 1234 here*/
%put &one;

Can I assign a local macro variable in this case?

Re: How to %SYSLPUT or %SYSRPUT Locally?

ChrisNZ — Tue, 19 Jan 2021 02:18:36 GMT

Your question is confusing.

%SYSLPUT is submitted in a (most likely local) session and creates/copies macro variables to the server session.

%SYSRPUT is remote-submitted to retrieve the value of a macro variable stored on the remote host and creates/updates macro variables on the calling (most likely local) session.

So they copy macro variable values from a SAS session to another.

What do you want to do?

Re: How to %SYSLPUT or %SYSRPUT Locally?

Junyong — Tue, 19 Jan 2021 02:59:32 GMT

%SYSLPUT is submitted in a (most likely local) session and creates/copies macro variables to the server session—here %SYSLPUT passes either local or global macro variables from the local session to the server session only as global macro variables.

%macro have(local_var_at_local);
%syslput local_var_at_server=&local_var_at_local;
rsubmit;
%put &local_var_at_server is a local macro variable at the server session.
endrsubmit;
%mend;
%have

rsubmit;
%put &local_var_at_server is available though was local inside have macro;
endrsubmit;

I want to create a server-side local (rather than global) macro variable from a local-side local macro variable.

Re: How to %SYSLPUT or %SYSRPUT Locally?

ChrisNZ — Tue, 19 Jan 2021 03:50:15 GMT

> I want to create a server-side local (rather than global) macro variable from a local-side local macro variable.

I understand you mean local as in in macro-local, not host-local.

You can't since %syslput sends the value to the remote host outside of a remote macro environment.

%macro have(local_var_at_local);
  %syslput local_var_at_server=&local_var_at_local;  /* sending a host-local macro-local variable to the remote host, no macro-local environment on that host */
  rsubmit;                                                                          /* connecting to the remote host macro-global environment */
    %put &local_var_at_server is NOT a local macro variable at the server session.; /* nothing local here */
  endrsubmit;
%mend;
%have

The only way would be to pull (rather than push/send) macro variables from the remote host from within a macro. There is no command to execute such a pull.