Joined: 10 May 2007 Posts: 2455 Location: Hampshire, UK
1) We know you have a DFSort question because you posted in that part of the forum. Create a meaningful title for your topics.
2) use the code tags to present your code and data. This maintains any spacing and uses a fixed width font so that stuff lines up correctly
3) As your sample data, which is supposed to be representative of the data in your dataset, only has 1 type 0 record and it has DDA (presumably in the position you say, why not simply change your data if the record type is 1 - no need to go checking your typ 0?
1) We know you have a DFSort question because you posted in that part of the forum. Create a meaningful title for your topics.
2) use the code tags to present your code and data. This maintains any spacing and uses a fixed width font so that stuff lines up correctly
3) As your sample data, which is supposed to be representative of the data in your dataset, only has 1 type 0 record and it has DDA (presumably in the position you say, why not simply change your data if the record type is 1 - no need to go checking your typ 0?
Thanks Nic for your reply...
I just wanted to see if we could do it...I don't have any data. I'm in the design phase and see if we could change without changing the proc.
To your bullet point 3, it could be DDA/SAV etc...I just want to change if it is only DDA based on the file we process.
Although your sample data is limited, test your code well. You have no "END" to limit the WHEN=GROUP, so the PUSH will potentially affect every record following, even if it is another "header" and the records belonging to that header.
Although your sample data is limited, test your code well. You have no "END" to limit the WHEN=GROUP, so the PUSH will potentially affect every record following, even if it is another "header" and the records belonging to that header.
Thanks Bill for you input. I'll update my package so I don't forget.