by jeff@[EMAIL PROTECTED]
Aug 22, 2006 at 07:08 AM
Thanks for your help as well. I tried it your way and there is a littl
elogic I am missing to get the looping right.
John Culleton wrote:
> jeff@[EMAIL PROTECTED]
wrote:
>
> > I have a program that I wrote that creates a work file to read from to
> > create a print record. The program is a sales re****t that allows the
> > user to specify how many years to compare. An example is 07-01-06 thru
> > 07-31-06 If they answer 3 prior years it would show sales data (it
also
> > handles exact day instead of just 070106, 071005, 070104)
> > 20060701
> > 20050702
> > 20040703
> >
> > 20060702
> > 20050703
> > 20040704
> >
> > When I read the Work file I need to read 2 recs before writing the
> > print record to calculate the percentage change in amount. Example:
> > 20060701 10%
> > 20050702 7%
> > 20040703
> > Sales up 10% for 2006 over 2005, sales up 7% 2005 over 2004.
> >
> > Any ideas on the best way to accomplish this?
>
> In psuedo code:
> open files
> read first record into first work field.
> perform loop until end file.
> close files.
>
> loop.
> read next record into second work field.
> calculate percent change.
> move second work field to print-rec-date.
> move percent change to print-rec pct.
> write print-rec.
> move second-work field to first work-field.
> ------------------------------------------
>
> Now my logic may be faulty since I don't know how the input file
> is organized. But the principle is to create a pipeline which
> holds two records at a time. After you do the calculation and
> print the re****t line you ****ft the data and read another record.
>
> The other suggestion of laying all the data up in a big table may
> also be useful.
>
> Specify your input record layout and your re****t line layout.
> That may help us help you.
>
> BTW is the input file sequential or indexed-sequential?
> --
> John Culleton
> Able Indexers and Typesetters