Output a filelist to TXT file on Mainframe

I am working on a program to migrate several SAS and TXT files from a
given Mainframe account to a Windows server.  I have much of the program
working and I have been working with a text file of Mainframe files
created with TSO 3.4 dataset list that someone did for me.  I would like
to make the program more dynamic and send a list of all Mainframe datasets
(files) to a text file that I can read in and create macro calls from.

I have tried a few aproaches that I found on here using PROC IDCAMS but
each time it seams to keep running and never ending.  The directory
(Mainframe account) that I am trying to get a file list for testing
purposes only has 13 files so it should be very quick.

I did get a list using the code below but it sends the list to the SAS LOG
and I have not been able to redirect it with PROC PRINTTO.

Command I have used:

X 'LISTCAT LVL(ZQR0)';

Is there a way to redirect or "pipe" the output of this to a file like
ZQR0.FILELIST.TXT?

I am working via SAS CONNECT so avoiding JCL would be my preferable
solution.

Thanks,
   Jim

> From: Brittain, James (CDC/CCHIS/NCHS)

here are a couple of references that you'll need after you get this
list:

1. List Processing Basics: Creating and Using Lists of Macro Variables
* Ronald J. Fehd
* Art Carpenter

 http://www.**--****.com/ 

 http://www.**--****.com/ 
ng_Lists_of_Macro_Variables


 http://www.**--****.com/ 

 http://www.**--****.com/ 


2. Batch Processing under Windows

 http://www.**--****.com/ 

 http://www.**--****.com/ 



see also:

 http://www.**--****.com/ 

Ron Fehd  the macro maven  CDC Atlanta GA USA RJF2 at cdc dot gov

Are they SAS datasets?   If so you could capture the file names with ODS using Proc Datasets.

I tried it (on UNIX), and do get it into a data set, and of course you could use any number
of means to print a sas data set to a file; if you are using SAS Connect you could use proc
download after this to bring down the data set.

RSUBMIT;

libname saslib2 '/home/user/saslib';
ods output members=members;
proc datasets library=saslib2;
quit;

proc print data=members;
run;


ENDRSUBMIT;
signoff;


-Mary





From: Jim Brittain < XXXX@XXXXX.COM >
To:  XXXX@XXXXX.COM 
Subject:      Output a filelist to TXT file on Mainframe
Date:         Thu, 23 Jul 2009 16:54:20 -0400

I am working on a program to migrate several SAS and TXT files from a
given Mainframe account to a Windows server.  I have much of the program
working and I have been working with a text file of Mainframe files
created with TSO 3.4 dataset list that someone did for me.  I would like
to make the program more dynamic and send a list of all Mainframe datasets
(files) to a text file that I can read in and create macro calls from.

I have tried a few aproaches that I found on here using PROC IDCAMS but
each time it seams to keep running and never ending.  The directory
(Mainframe account) that I am trying to get a file list for testing
purposes only has 13 files so it should be very quick.

I did get a list using the code below but it sends the list to the SAS LOG
and I have not been able to redirect it with PROC PRINTTO.

Command I have used:

X 'LISTCAT LVL(ZQR0)';

Is there a way to redirect or "pipe" the output of this to a file like
ZQR0.FILELIST.TXT?

I am working via SAS CONNECT so avoiding JCL would be my preferable
solution.

Thanks,
   Jim

On Thu, 23 Jul 2009 17:28:39 -0400, Fehd, Ronald J. (CDC/CCHIS/NCPHI)






what you are creating is a member of a PDS. That thing contains a list of
other files (the output from LISTCAT), I think. I don't understand what
you want to do. You are migrating a application to Win. What would you do
with a list of hostfiles on Win? So why "redirecting" the LISTCAT output
to a Win-file??
I assume you want to transfer the logic, not the physical representation
(files) on win? In that case you might want a directory list of .SAS
or .TXT files in another file? Is that true, or do you want the LISTCAT
output (that you can do with PROC DOWNLOAD).
There are several possibilities to do this, but first post what you really
want to do.

Gerhard

Jim

Mainframe SAS has a tool called  Proc Source which can be used with the
Partitioned Data Sets (PDS) where mainframe programs are often stored. It
can, for example, simply list the members of a pds or it can also dump the
entire pds into a sequential text file with a record indicating the start
of each new pds.

If you were to assign filenames to the pds and to a sequential file, say In
and Out, you could use the code

Proc Source indd = in  Outdd = Out nodata;
run;

The file Out would have the list of the member names and these will appear
as


 ./       ADD   NAME=member name


The ./ Add bit is used by an IBM utility for loading members into a PDS.

Nat Wooding
Environmental Specialist III
Dominion, Environmental Biology
4111 Castlewood Rd
Richmond, VA 23234
Phone:804-271-5313, Fax: 804-271-2977
       Cel Phone: 804-205-0752



             Jim Brittain
             < XXXX@XXXXX.COM >
             Sent by: "SAS(r)                                           To
             Discussion"                XXXX@XXXXX.COM 
             < XXXX@XXXXX.COM                                           cc
             GA.EDU>
                                                                   Subject
                                       Output a filelist to TXT file on
             07/23/2009 04:54          Mainframe
             PM


             Please respond to
               Jim Brittain
              < XXXX@XXXXX.COM >






I am working on a program to migrate several SAS and TXT files from a
given Mainframe account to a Windows server.  I have much of the program
working and I have been working with a text file of Mainframe files
created with TSO 3.4 dataset list that someone did for me.  I would like
to make the program more dynamic and send a list of all Mainframe datasets
(files) to a text file that I can read in and create macro calls from.

I have tried a few aproaches that I found on here using PROC IDCAMS but
each time it seams to keep running and never ending.  The directory
(Mainframe account) that I am trying to get a file list for testing
purposes only has 13 files so it should be very quick.

I did get a list using the code below but it sends the list to the SAS LOG
and I have not been able to redirect it with PROC PRINTTO.

Command I have used:

X 'LISTCAT LVL(ZQR0)';

Is there a way to redirect or "pipe" the output of this to a file like
ZQR0.FILELIST.TXT?

I am working via SAS CONNECT so avoiding JCL would be my preferable
solution.

Thanks,
   Jim


CONFIDENTIALITY NOTICE:  This electronic message contains
information which may be legally confidential and or privileged and
does not in any case represent a firm ENERGY COMMODITY bid or offer
relating thereto which binds the sender without an additional
express written confirmation to that effect.  The information is
intended solely for the individual or entity named above and access
by anyone else is unauthorized.  If you are not the intended
recipient, any disclosure, copying, distribution, or use of the
contents of this information is prohibited and may be unlawful.  If
you have received this electronic transmission in error, please
reply immediately to the sender that you have received the message
in error, and delete it.  Thank you.

Dear SAS-L-ers,

Jim Brittain posted the following:

Jim, I immediately thought of the same solution that Nat did when reading this.  If you are migrating PDS's to PC's then PROC SOURCE is your guy!

I used PROC SOURCE to great effect many years ago when I first navigated the dark and stormy gulf that separates the mainframe mainland and the PC archipelago.  If you do not feel like reinventing the calipers, check out my oldy, moldy SUGI 25 paper:

Transferring Your Mainframe SAS Programs to Your PC in Three Easy Steps

 http://www.**--****.com/ 

If you dust off the cobwebs, give it a shake, and change a line or two, it just might do the trick!

Jim, best of luck in all of your SAS endeavors!


I hope that this suggestion proves helpful now, and in the future!

Of course, all of these opinions and insights are my own, and do not reflect those of my organization or my associates. All SAS code and/or methodologies specified in this posting are for illustrative purposes only and no warranty is stated or implied as to their accuracy or applicability. People deciding to use information in this posting do so at their own risk.

+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Michael A. Raithel
"The man who wrote the book on performance"
E-mail:  XXXX@XXXXX.COM 

Author: Tuning SAS Applications in the MVS Environment

Author: Tuning SAS Applications in the OS/390 and z/OS Environments, Second Edition

 http://www.**--****.com/ 

Author: The Complete Guide to SAS Indexes

 http://www.**--****.com/ 

+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
An expert is someone who knows more and more about less and
less, until eventually he knows everything about nothing. - Anonymous
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++