topic Re: sas macros in SAS Programming

sas macros

astha8882000 — Wed, 11 Jul 2018 19:13:51 GMT

I'm trying to run the following piece of code:

%let abc_unix = &sd_exports.;

%sysrput abc_unix = &abc_unix.;

LIBNAME abc "&abc_unix.";

I get the error " %SYSRPUT statement is valid only when OPTION DMR is in effect.".

What should I be adding to get this to run successfully?

Re: sas macros

Reeza — Wed, 11 Jul 2018 19:22:19 GMT

DMR option is not set, which means it's:

NODMR

disables you from invoking a remote SAS session.

If it's set this way, you can't push your macro variable to the remote session, because you can't connect to it.

http://support.sas.com/documentation/cdl/en/lrdict/64316/HTML/default/viewer.htm#a000279080.htm

@astha8882000 wrote:

I'm trying to run the following piece of code:

%let abc_unix = &sd_exports.;

%sysrput abc_unix = &abc_unix.;

LIBNAME abc "&abc_unix.";

I get the error " %SYSRPUT statement is valid only when OPTION DMR is in effect.".

What should I be adding to get this to run successfully?

Re: sas macros

astha8882000 — Wed, 11 Jul 2018 19:33:26 GMT

Got it, thanks. What can I add to make that work?

Re: sas macros

astha8882000 — Wed, 11 Jul 2018 19:40:59 GMT

I tried doing this:

%let abc_unix = &sd_exports.;
%nrstr(%sysrput abc_unix = &abc_unix.);

LIBNAME abc "&abc_unix.";

that gave me the error: Statement is not valid or it is used out of proper order.

Then I did this:

%let abc_unix = &sd_exports.;
%nrstr(%%)sysrput abc_unix = &abc_unix.;

LIBNAME abc "&abc_unix.";

that gave me this error: LINE and COLUMN cannot be determined.
NOTE: NOSPOOL is on. Rerunning with OPTION SPOOL might allow recovery of the LINE and COLUMN where the error has occurred.
ERROR 180-322: Statement is not valid or it is used out of proper order.

Re: sas macros

astha8882000 — Wed, 11 Jul 2018 20:10:21 GMT

I tried doing that too, that didn't help either:

%let abc_unix = &sd_exports.
rsubmit;
%sysrput abc_unix = &abc_unix.;
endrsubmit;
LIBNAME abc "&abc_unix.";

I get the following error: ERROR: The text expression &abc_UNIX. contains a recursive reference to the macro variable abc_UNIX. The macro variable will be assigned the null value.

Re: sas macros

Reeza — Wed, 11 Jul 2018 20:58:14 GMT

Do you want SYSLPUT instead of RPUT?

RPUT moves macro variables from the Remote server to local.

LPUT moves macro variables from the Local to the server.

Re: sas macros

Tom — Wed, 11 Jul 2018 22:56:43 GMT

@astha8882000 wrote:
I tried doing that too, that didn't help either:
%let abc_unix = &sd_exports.
rsubmit;
%sysrput abc_unix = &abc_unix.;
endrsubmit;
LIBNAME abc "&abc_unix.";
I get the following error: ERROR: The text expression &abc_UNIX. contains a recursive reference to the macro variable abc_UNIX. The macro variable will be assigned the null value.

Your first line sets the local macro variable ABC_UNIX to the value of the macro variable SD_EXPORTS. Assuming that you actually ended the %LET statement with a semi-colon.

Your next three lines form a remote submit block that is attempting to recursively define a macro variable ABC_UNIX in the remote session. It has nothing to do with the other lines at all.

So effectively you ran these two lines.

%let abc_unix = &sd_exports. ;
LIBNAME abc "&abc_unix.";

What is it that you actual WANT to do?

Perhaps something like this?

rsignon;
%syslput abc_unix = &sd_exports.;
rsubmit;
LIBNAME abc "&abc_unix.";
endrsubmit;

Or something else?

Re: sas macros

Tom — Wed, 11 Jul 2018 23:00:30 GMT

@astha8882000 wrote:

I'm trying to run the following piece of code:

%let abc_unix = &sd_exports.;

%sysrput abc_unix = &abc_unix.;

LIBNAME abc "&abc_unix.";

I get the error " %SYSRPUT statement is valid only when OPTION DMR is in effect.".

What should I be adding to get this to run successfully?

%SYSRPUT runs on the REMOTE session.

That code would make more sense it you included the first two lines in an RSUBMIT block.

rsubmit;
  %let abc_unix = &sd_exports.;
  %sysrput abc_unix = &abc_unix.;
endrsubmit;

LIBNAME abc "&abc_unix.";

Re: sas macros

astha8882000 — Wed, 11 Jul 2018 23:35:23 GMT

It's definitely rput because I need to read a dataset from that remote server.

Re: sas macros

astha8882000 — Wed, 11 Jul 2018 23:42:43 GMT

So this was my original code and mentioned with the code lines is what my aim was:

%let abc_unix = &sd_exports.; //this is the target folder

%sysrput abc_unix = &abc_unix.;--this will start reading from server into the target folder

LIBNAME abc "&abc_unix."; this will create a libref to that target folder

Re: sas macros

astha8882000 — Wed, 11 Jul 2018 23:44:39 GMT

I tried that, it gave me the following error:

ERROR: Invalid or unspecified remote session ID. Set OPTIONS REMOTE=session_id.
NOTE: Subsequent lines will be ignored until ENDRSUBMIT.
ERROR: Remote submit to UNKNOWN canceled.

Re: sas macros

Reeza — Thu, 12 Jul 2018 01:56:54 GMT

%sysrput abc_unix = &abc_unix.;--this will start reading from server into the target folder

No, it will create a macro variable with that value on the remote server. Nothing is moved or read, you only create a macro variable.

Re: sas macros

Tom — Thu, 12 Jul 2018 02:08:05 GMT

If you don't have a remote session running you cannot do ANYTHING on the non-existent remote session.

How are you creating the remote session? Normally I would use signon command to start a remote session. I would know the NAME of the remote session. What is the name of the remote session you are trying to reference?

You can create a local libref that points to remote location without creating any macro variables on the remote session.

libname mylib remote "path on remote" server=remotname ;

Re: sas macros

SASKiwi — Thu, 12 Jul 2018 02:17:51 GMT

This code worked fine for me (you may need to add SIGNON options):

signon;

rsubmit;

  %let abc_unix = Just Testing;
  %sysrput abc_unix = &abc_unix.;

endrsubmit;

%put abc_unix = &abc_unix.;

Re: sas macros

astha8882000 — Thu, 12 Jul 2018 03:23:32 GMT

I tried this and got the error:

ERROR: Invalid or unspecified remote session ID. Set OPTIONS REMOTE=session_id.
ERROR: Remote signon to UNKNOWN canceled.
25
26 rsubmit;
ERROR: Invalid or unspecified remote session ID. Set OPTIONS REMOTE=session_id.
NOTE: Subsequent lines will be ignored until ENDRSUBMIT.
ERROR: Remote submit to UNKNOWN canceled.

Re: sas macros

andreas_lds — Thu, 12 Jul 2018 05:22:45 GMT

@SASKiwi said "This code worked fine for me (you may need to add SIGNON options)

Now please read the documentation of signon-statement and add the required options.

Do you have sas installation on your computer and and a sas installation on a server?

Re: sas macros

astha8882000 — Thu, 12 Jul 2018 13:10:38 GMT

I actually ended up working around it by getting that exact server location rather than getting into all this and reading the data in there. Still not sure how to get sysrput to work, but maybe another time. Thanks everyone for your help!