me too, I provided Ken one example I had, I suppose he could add an OCOPY step to copy from USS to a PDS/E

one example

//SYSIN    DD *

  DATA TEMPA;

  SET PDB.JOBS;

  DATE=DATEPART(INITTIME);

  IF DATE = '05DEC2006'D

  OR DATE = '12DEC2006'D;

  IF SYSTEM = 'CPU3';

  IF INITTIME = '.' THEN DELETE;

  IF JOB = 'INIT'  THEN DELETE;

  JOBSTART = TIMEPART(INITTIME);

  IF JOBSTART LE '17:00:00'T AND JOBSTART GE '10:00:00'T;

  FORMAT ACCOUNT1 $PROJECT.;

  RUN;

  ods csvfile='/u/cvitul/cpu3_dec5.csv';

  PROC PRINT DATA=TEMPA LABEL;

  VAR SYSTEM ACCOUNT1 INITTIME JOB CPUUNITS;

  RUN;

  ods csvclose;

On 11/22/2022 11:26 PM, [email protected]

, it was SAS9 unfortunately where I'm working now does not have any SAS so I'm kinda stuck in time

On 11/23/2022 9:11 AM, Horne, Jim wrote:
I've done it to USS files but not to PDSEs.  I'm not sure if you can, but how 
would you read an Excel file in a PDSE from a PC?

Jim Horne
________________________________
NOTICE: All information in and attached to the e-mails below may be 
proprietary, confidential, privileged and otherwise protected from improper or 
erroneous disclosure. If you are not the sender's intended recipient, you are 
not authorized to intercept, read, print, retain, copy, forward, or disseminate 
this message. If you have erroneously received this communication, please 
notify the sender immediately by phone (704-758-1000) or by e-mail and destroy 
all copies of this message electronic, paper, or otherwise. By transmitting 
documents via this email: Users, Customers, Suppliers and Vendors collectively 
acknowledge and agree the transmittal of information via email is voluntary, is 
offered as a convenience, and is not a secured method of communication; Not to 
transmit any payment information E.G. credit card, debit card, checking 
account, wire transfer information, passwords, or sensitive and personal 
information E.G. Driver's license, DOB, social security, or any other 
information the user wishes to remain confidential; To transmit only 
non-confidential information such as plans, pictures and drawings and to assume 
all risk and liability for and indemnify Lowe's from any claims, losses or 
damages that may arise from the transmittal of documents or including 
non-confidential information in the body of an email transmittal. Thank you.

----------------------------------------------------------------------
For IBM-MAIN subscribe / signoff / archive access instructions,
send email [email protected]  with the message: INFO IBM-MAIN
--
Carmen

----------------------------------------------------------------------
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to [email protected] with the message: INFO IBM-MAIN

Reply via email to