topic Re: how to use if condition in remote session in SAS Programming

how to use if condition in remote session

shubham1 — Tue, 13 Nov 2018 10:56:34 GMT

%macro new;

options mprint mlogic;

OPTIONS COMAMID = TCP;

%LET _host_user=xxxx;

%let _host_pass=xxxx;

%LET Rsysv = rysa 7280;

signon Rsysv  user="&_host_user" password="&_host_pass" noscript;

 

rsubmit;

 
data new;

x=5;

run;

 

data _null_;

call symputx('y',2);

run;

 

%if &y=2 %then %do;

proc download data=new;

run;

%end;

 

endrsubmit;

 

%mend;

 

%new

how can i use below condition correctly in remote session

%if &y=2 %then %do;

Re: how to use if condition in remote session

Shmuel — Tue, 13 Nov 2018 15:37:50 GMT

You should enter the %IF into a internal macro submitted to the remote host:

%macro new;
options mprint mlogic;
OPTIONS COMAMID = TCP;
%LET _host_user=xxxx;
%let _host_pass=xxxx;
%LET Rsysv = rysa 7280;
signon Rsysv  user="&_host_user" password="&_host_pass" noscript;

rsubmit;
 
data new;
x=5;
run;
 
data _null_;
call symputx('y',2);
run;

%macro check(arg);
    %if &arg=2 %then %do;
      proc download data=new;
     run;
   %end;
%mend check;
%check(&y);

endrsubmit;

%mend;

%new;

Re: how to use if condition in remote session

Shmuel — Tue, 13 Nov 2018 15:44:41 GMT

You should consider any code between RSUBMIT and ENDRSUBMIT as a separate program, You probably know that %IF should be part of a macro known to host where it is running.

Re: how to use if condition in remote session

Reeza — Tue, 13 Nov 2018 16:15:17 GMT

If you're using SAS 9.4 TS1M5 that type of code is valid, but it's not in earlier versions. You need to have another external macro that you can call with the %IF logic.