topic Re: sas -stdio in GRID in Administration and Deployment

sas -stdio in GRID

Asbon — Fri, 18 Aug 2023 11:42:50 GMT

Hi,

below is from .ksh which is working fine.
how to use it in sas grid Please.

function fn_check_batch_load
{
/sas/SASGMCU/sasgsub -stdio << SASEND
        * this expects to be called with the '-stdio' flag to redirect the output;
        proc sql;
            connect to oracle(user=&pcdsuser orapw=&pcdspw path='@pcds');
            CREATE TABLE pcrs_recent AS
            SELECT
                COMPARE("${SCRIPT_DATE}", max_end) AS comp_dat
            FROM    connection to oracle (
                SELECT    prcs_id,
                    TO_CHAR(MAX(end_ts), 'YYYYMMDD') max_end
                FROM    prcs_run
                WHERE    prcs_run_status_ref_cd = 'FNSH'
                AND    prcs_id = 14001
                GROUP BY prcs_id
                )
            ;
                disconnect from oracle;
        quit;

        * dump just the data we care about;
        data _null_;
            set pcrs_recent;
            file stdout;
            put comp_dat;
        run;
SASEND
} # function fn_check_batch_load

Thanks.

Re: sas -stdio in GRID

gwootton — Mon, 28 Aug 2023 15:39:06 GMT

The SASGSUB option to run interactively in -GRIDRUNSASLM, have you tried using this?

SASGSUB Command: Starting SAS in Interactive Mode
https://go.documentation.sas.com/doc/en/pgmsascdc/9.4_3.5/gridref/n17o2lfqlayjqvn1bseb11m822p5.htm

Re: sas -stdio in GRID

doug_sas — Mon, 28 Aug 2023 16:07:44 GMT

While you could do a great deal of work to make SASGSUB with GRIDRUNSASLM work with -stdio, why are you not putting the code you want to execute in a file (like my-program.sas) and using that as the program to run?