View previous topic :: View next topic
|
Author |
Message |
Jay Villaverde
New User
Joined: 08 Mar 2014 Posts: 27 Location: USA
|
|
|
|
Hi. One step in my program is where I want to divide by a certain factor based on a different field.
For example, my data looks like:
Code: |
1331658001|00030835|
1331665001|00031028|
1374639001|00029011|
1378471004|00028856|
1463482001|00031032|
1463484001|00031211|
1741893001|00034740|
1741897001|00052321|
|
I know I can use the following to divide by a set number such as:
Code: |
SORT FIELDS=(01,10,CH,A)
OUTREC FIELDS=(01:01,10,
11:C'|',
12:12,08,ZD,DIV,+5,EDIT=('TTTTTTTT'),
20:C'|')
|
But I have a need to divide some of those numbers in the 2nd column by 5, others by 3, others by 2, etc. based on the number in the 1st column.
Thanks,
Jay |
|
Back to top |
|
|
Bill Woodger
Moderator Emeritus
Joined: 09 Mar 2011 Posts: 7309 Location: Inside the Matrix
|
|
|
|
Why use OUTREC FIELDS instead of OUTREC BUILD? You can see that FIELDS means different things in different contexts, but BUILD does not, so is clearer (processing is identical).
Why use the column numbers when your output data are contiguous?
IFTHEN=(WHEN=(logical-expression) seems to be what you want, unless you can point out why. |
|
Back to top |
|
|
Jay Villaverde
New User
Joined: 08 Mar 2014 Posts: 27 Location: USA
|
|
|
|
Not familiar with IFTHEN but that does seem to be what I need. Can you help with the code for my situation? I'll also look up the usage of it.
Thanks |
|
Back to top |
|
|
Jay Villaverde
New User
Joined: 08 Mar 2014 Posts: 27 Location: USA
|
|
|
|
Looks like I got what I needed. Looked up usage of IFTHEN= and it worked beautifully.
Thanks |
|
Back to top |
|
|
|