topic How to read previous 2 versions of SAS GDG files in SAS program? in ODS and Base Reporting

How to read previous 2 versions of SAS GDG files in SAS program?

deleted_user — Fri, 31 Jul 2009 11:27:38 GMT

I want to read 3 previous versions of SAS GDG files in SAS(I am Using JCL to RUN).

Re: How to read previous 2 versions of SAS GDG files in SAS program?

Cynthia_sas — Fri, 31 Jul 2009 11:59:40 GMT

Hi:
The documentation has some good examples:
http://support.sas.com/documentation/cdl/en/lrcon/61722/HTML/default/a000934566.htm
http://www2.sas.com/proceedings/sugi31/253-31.pdf

cynthia

Re: How to read previous 2 versions of SAS GDG files in SAS program?

sbb — Fri, 31 Jul 2009 13:00:49 GMT

Just to be clear here, are you referencing the use of SAS Generation Data Sets as Cynthia referenced or MVS (IBM mainframe) GDG (Generation Data Group) datasets using your JCL? If MVS GDG is correct, the next question would be to ask whether you have the SAS GDG "data library" on disk or is your SAS GDG "sequential format" data on tape?

Scott Barry
SBBWorks, Inc.

Re: How to read previous 2 versions of SAS GDG files in SAS program?

deleted_user — Mon, 03 Aug 2009 04:37:04 GMT

Hi,

MVS GDG is correct and SAS GDG "sequential format" data on tape.

Narayana

Re: How to read previous 2 versions of SAS GDG files in SAS program?

sbb — Mon, 03 Aug 2009 14:13:04 GMT

If you wish to process all of the SAS observations together, you must combine them together in a DATA step, using a SET statement with each JCL DDNAME defined uniquely in your batch JCL.

Also, if you want to minimize the number of tape drive allocations, you can use a combination of the UNIT=AFF=ddname JCL DD parameter and also use the OPEN=DEFER parameter on SET.

Refer to the SAS z/OS Companion Guide and the LIBNAME statement discussion on concatenation.

Scott Barry
SBBWorks, Inc.

SAS 9.1.3 Companion for z/OS
http://support.sas.com/documentation/onlinedoc/91pdf/sasdoc_913/base_zoscom_8406.pdf

Re: How to read previous 2 versions of SAS GDG files in SAS program?

deleted_user — Tue, 04 Aug 2009 03:56:01 GMT

Thanks Barry

You mean to say like the followig code? If not Please give me sample code.
Data Test;
Set lib1.file1
lib2.file2
lib3.file2;
Run;

//lib1 DD DSN=VXXXXX.Test.File1.V00,Disp=SHR
//lib2 DD DSN=VXXXXX.Test.File2.V01,Disp=SHR
//lib3 DD DSN=VXXXXX.Test.File3.V02,Disp=SHR

Re: How to read previous 2 versions of SAS GDG files in SAS program?

sbb — Tue, 04 Aug 2009 13:41:08 GMT

Yes - correct, however you will use 3 tape drives even though you only need 1.

Again, from my previous reply, consider using the JCL DD parameter UNIT=AFF= and also the OPEN=DEFER on the SET statement, both coded for efficiency / optimization.

And you will want to confirm the SAS dataset name on the tape with PROC CONTENTS -- do not presume the names are "file1" and "file2".

My suggestion: setup the JCL batch jobstream and submit it - you will see the results of your efforts.

Scott Barry
SBBWorks, Inc.