MVSFORUMS.com

I was also looking for answer to this old post. I was able to execute REXX program but it cannot be executed in interactive mode. I did not find this feature of much use.

I finally did a little cheating by having first SAS call REXX and then REXX call SAS.

Here is the solution.

JCL:

//SAS EXEC SAS
//SYSIN DD * ...

Kolusu,

I was going to try this next but this is other way round, executing REXX from SAS. I am trying SAS from REXX.

Kolusu,

SAS is working, but not the way I want. My requirement is to execute SAS program through a REXX code in JCL.

Our shop mainly deals with batch REXX so we are investigating if we start de ...

In the below code, I cam executing SAS program through REXX.

When I execute it through the JCL, I get the expected messages from REXX in SYSTSPRT, both before and after executing SAS.

But from ...

Looks like SAS need exclusive access to data library. Changing to DISP=OLD solved the problem.

Following SAS code is working fine -

LIBNAME mysasds 'DB.SAS.DATASET';

data mysasds.wtclub;

But when I allocate the dataset in SAS JC ...

Above link does not work so providing a new link

https://stats.idre.ucla.edu/sas/modules/match-merging-data-files-in-sas/

IF WS-INDICATOR NOT = ('Y' AND 'P')

In my interaction with business analysts, they don't get confused with code like this, but the programmers always are. I think it is okay since it is sup ...

If you have to press enter for a pull then that would mean that you don't have anything in queue. Check you logic again.

shyamsaravan, in your query this is causing extra rows.

WHERE C.EFF_DT > '0001-01-01'
OR C.EFF_DT IS NULL

searched for macrf locate mode and this is the first link i got - http://csc.colstate.edu/woolbright/QSAM.HTM

Unfortunately, those are not the requested results. . . Confused

I agree chandra's input and output are differently formatted then OP's post. But unless we are trying to spoon feed, the required logic ...

http://publib.boulder.ibm.com/infocenter/zos/v1r11/index.jsp?topic=/com.ibm.zos.r11.ikja300/c2d.htm

If the result cannot be expressed as a whole number, an error results. That is, the result must n ...

Try this to add EMPGENDER in the SELECT -

CREATE VIEW V1
(
EMPNO,
EMPNAME
EMPGENDER,
EMPAGE,
EMPSALARY
)
AS
SELECT
EMPNO,
EMPNAME,
CAST (NULL AS CHAR(1)) ...