MVSFORUMS.com

Here are the details.

Cobol layouts, old and new versions. Each '01' level represents a DB2 table, naming format is <db2 schema name>-<DB2 table name>. Schema name can change in differe ...

Kolusu,

For input there will be two sets (old and new) each of - File-Aid Xref, Cobol layout and data files. Automation will have to process all these to generate the compare code. It will take som ...

Thanks Kolusu. I need differences at field level with field names, edited my post with a sample report. I think it would be challenging to do that with DFSORT.

Hi,

I have file-aid DB2 RDX extracts of two versions of a database in flat files. I have corresponding XREF and COBOL layout. Is there a way to compare the common fields in the two files. I am thin ...

Thanks Kolusu!

Simply encrypting or redacting will not serve our purpose. We need to make meaningful changes, like changing name to a valid name. So changing "Dibakar" to "Suleman&qu ...

I am looking for user experience with data masking tools. By data masking I mean replacing personally identifiable information in production extracts by other values so that test environments using th ...

I hope three months is not too late to respond.

I work in similar project where apart from masking we also have to maintain character of data, like "John" becomes "Bond" (4 lett ...

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/