Hello,   Is it possible to include the user and password as parameters using the sasbatch.sh command line?   Ex: /SASCONFIG/Lev1/SASApp/BatchServer/sasbatch.sh -log /SASCONFIG/Lev1/SASApp/BatchServer/Logs/LOGFILE_TST_#Y.#m.#d_#H.#M.#s.log -batch -noterminal -logparm "rollover=session" -sysin /SASCONFIG/Lev1/SASApp/SASEnvironment/SASCode/Jobs/SASTest.sas   Thank you! ... View more

Hello,   I've been trying to execute the following code:   %let line = '%put NOTE: foo;'; data _null_; infile "echo &line. >> /opt/testfolder/test_program.sas" pipe; input; put _infile_; run; However, when getting the results from the execution, the file I'm trying to append is not appended.   If I remove the "%" character from the first line, the command works just fine.    How could I achieve the desired result (writing this piece of code to a file)? I've tried to use some functions such as str, nrstr, quote and nrquote and I wasn't able to execute it properly.   Thank you     ... View more

Hello experts,   For example, in order to check whether a table exists or not and then create a new table, I have been doing the following:   %IF %SYSFUNC (EXIST (foo.bar)) %THEN %DO;     PROC SQL NOPRINT;       DROP TABLE foo.bar;     QUIT;   %END; PROC SQL NOPRINT;     CONNECT TO ORACLE AS ORA (&STRING_CONN.);           execute by ora (                 create table foo.bar as select * from foo.oldtable                  );     DISCONNECT FROM ORA; QUIT; %IF %SYSFUNC (EXIST (foo.bar2)) %THEN %DO;         PROC SQL;                DROP TABLE foo.bar2;         QUIT; %END; PROC SQL NOPRINT;     CONNECT TO ORACLE AS ORA (&STRING_CONN.);           execute by ora (                 create table foo.bar2 as select * from foo.oldtable2                  );     DISCONNECT FROM ORA; QUIT;   Is there any way to optimize the amount of connections being opened and use one proc sql?   I have been using explicit passthru to create new tables but I haven't found any way to incorporate the IF in a better way so I can group this code in one proc sql.   Thank you! ... View more