Re: DCOLLECT & DFSORT

2021-08-03 Thread Leon Trafalski
This is what I use with ICETOOL to display dataset information. HEADER('Data Set Name')    ON(029,44,CH) - HEADER('#Ext') ON(082,01,BI) - HEADER('Volser')   ON(083,06,CH) - HEADER('BlkLen')   ON(089,02,FI) - HEADER('RecLen')   ON(091,02,FI)

Re: DCOLLECT & DFSORT

2021-08-03 Thread Jack Zukt
Hi, Thank you for you suggestions. I am going to try them out. Jack On Tue, 3 Aug 2021 at 15:21, Cameron Conacher wrote: > Four bytes binary to display numeric? > Starting-column,4,bi,EDIT=(TTTS) > Maybe be what you are looking for? > > Packed date to display numeric? > Starting-column,4,PD,

Re: DCOLLECT & DFSORT

2021-08-03 Thread Cameron Conacher
Four bytes binary to display numeric? Starting-column,4,bi,EDIT=(TTTS) Maybe be what you are looking for? Packed date to display numeric? Starting-column,4,PD,EDIT=(TTT) Maybe what you are looking for? If you want leading zeros use “T” If you want leading zeroes as blanks use “I”. Sent f

Re: DCOLLECT & DFSORT

2021-08-03 Thread Sri h Kolusu
On the DCOLLECT > input records the date is in the 'dddF' format and the space fields are > 4 byte long signed. I am pretty sure that there is a way to tell DFSORT to > make that translation but I am having no luck with the manual. > Any suggestions? Jack, That is a standard Y4U format dat

Re: DCOLLECT & DFSORT

2021-08-03 Thread Steve Smith
I use a format item of E'.999' on the field specified as length 4, type PD... I'm not sure of the syntax on a typical SORT, as I always use symbol files, and ICETOOL DISPLAY for this sort of thing. sas On Tue, Aug 3, 2021 at 8:27 AM Jack Zukt wrote: > Hello All, > I am trying to build a rep

DCOLLECT & DFSORT

2021-08-03 Thread Jack Zukt
Hello All, I am trying to build a report of inactive datasets using DCOLLECT for input and DFSORT to create the files for each last year referenced. For the output files I only want the dataset name; last used date; allocated space; used space; storage group name. Now for the tricky part: I want th