topic Re: How to execute more sas codes automatically and orderly in Unix in SAS Programming

How to execute more sas codes automatically and orderly in Unix

Guofeng — Wed, 05 Dec 2018 10:37:34 GMT

I'd like to execute more SAS codes automatically and orderly.

Follow code(all_codes.sas) can run successfully in Window SAS. However it failed in Unix when I used command: sas94 all_codes.sas in Putty.

%macro all_codes;
data _null_;
systask command "sas &QCPROG.qc_SDTM_ex.sas" taskname="ex" ;
systask command "sas &QCPROG.qc_SDTM_ec.sas" taskname="ec" ;
systask command "sas &QCPROG.qc_SDTM_ds.sas" taskname="ds" ;
waitfor _all_ ex ec ds ;
run;
%mend deal_codes;
%deal_codes;

Could anybody do me a favor? Thanks in advance.

Re: How to execute more sas codes automatically and orderly in Unix

Jagadishkatam — Wed, 05 Dec 2018 10:53:31 GMT

Could try the x command as below

%macro all_codes;
 data _null_;
 x "sas &QCPROG.all_codes.sas" ;
 x "sas &QCPROG.qc_SDTM_ex.sas";
 x "sas &QCPROG.qc_SDTM_ec.sas" ;
 x "sas &QCPROG.qc_SDTM_ds.sas" ;
 run;
 %mend deal_codes;
 %deal_codes;

Re: How to execute more sas codes automatically and orderly in Unix

s_lassen — Wed, 05 Dec 2018 11:02:45 GMT

A couple of questions:

Can you start SAS using "sas94 all_codes.sas" from the Shell?
Why do you put your SYSTASK statements after DATA _NULL_? This is not a data step statement, you can use it anywhere.
Can you start your SAS command using an X statement or command? Try that, with OPTIONS XWAIT, then you should be able to see what happens in the Shell window.
In what way does the SYSTASK command fail? Any messages in the log?
Can you start a SAS using SYSTASK outside the SAS system?
What does it mean that you use the command in Putty? that's not a Shell (or is it?), I think it's a file transfer program.

Re: How to execute more sas codes automatically and orderly in Unix

Guofeng — Wed, 05 Dec 2018 11:12:29 GMT

PuTTY is an SSH and Telnet client for Windows， it can check in/out data in Unix and also can use sas9 xxx.sas to run sas codes.

Re: How to execute more sas codes automatically and orderly in Unix

Guofeng — Wed, 05 Dec 2018 11:16:53 GMT

Hi Jagadishkatam, I tried it. However the codes like qc_SDTM_ex.sas don't execute in the UNIX and there are no erorrs/warrings.

Re: How to execute more sas codes automatically and orderly in Unix

Guofeng — Wed, 05 Dec 2018 11:46:56 GMT

Hi s_lassen, thank you so much for the valuable comments. for comments #3 and #5,could you show me some examples when you have time. I'm not familiar with SYSTASK and command. I often run SAS codes in SAS system.
Sincere appreciation.

Re: How to execute more sas codes automatically and orderly in Unix

Kurt_Bremser — Wed, 05 Dec 2018 12:18:21 GMT

Start by catching all system responses to a command:

filename oscmd pipe "sas &QCPROG.qc_SDTM_ex.sas 2>&1";

data _null_;
infile oscmd;
input;
put _infile_;
run;

Look at the log and see what you got.

Once you know what really happens, we can devise ways to work around your problem.

Note that the filename pipe is the best method to run external commands.

Also note that systask and waitfor are global statements and do not need a data step to run.

Re: How to execute more sas codes automatically and orderly in Unix

s_lassen — Wed, 05 Dec 2018 14:35:19 GMT

Re my comment #3: If you are running in a Windows terminal, you may not be able to start a session in another window, using the X command. Try instead the pipe approach suggested by @Kurt_Bremser

Re #5: Sorry, I did not mean to try and start a SYSTASK outside the SAS System. It should have been outside the macro. It is often easier to make Things work if you try first without the macro calls.