date Difference using Syncsort

Ketan Varhade · Posted: Mon Sep 26, 2011 4:10 pm

Hi,
Is there any function avaiable in Syncsort to calculate the date difference
from two file?

for eg file 1
20110926

file 2
20110925

output should be :
1

Bill Woodger · Posted: Mon Sep 26, 2011 4:14 pm

You have two single-record datasets, each with a date on, and you'd like to calculate the difference with the answer as a number of days?

Would it help you to concatenate the datasets, so that the first record is from dataset 1 and the second from dataset 2?

Ketan Varhade · Posted: Mon Sep 26, 2011 4:21 pm

Yes, I want the difference in number of days.

Bill Woodger · Posted: Mon Sep 26, 2011 4:25 pm

Blood-from-a-stone time :-)

I really understood the bit about you wanting days. What I was hoping to know were the answers to the other questions.

You have dates on two seperate datasets - how many records on each dataset?

Would it help you, ie would you then be able to proceed with the code, if both the dates were on the same dataset as seperate records, or have you no clue at all about how to do this?

enrico-sorichetti · Posted: Mon Sep 26, 2011 4:29 pm

Your first question

Ketan Varhade · Posted: Mon Sep 26, 2011 4:35 pm

there are two diffrent PS and number of record in each PS is same.

for eg;
for eg file 1
date ID
20110926 ABC
20110901 XYZ

file 2 ID
20110925 ABC
20110830 XYZ

output should be :
1
2

there can be many record and input is also have a key field on which the match will be done. in this case ID is the key

enrico-sorichetti · Posted: Mon Sep 26, 2011 4:37 pm

&holy &shit... why did You reply yes to the question

Bill Woodger · Posted: Mon Sep 26, 2011 4:39 pm

enrico-sorichetti · Posted: Mon Sep 26, 2011 4:41 pm

follow on ...
and please avoid to make people willing to help You look dumb

Ketan Varhade · Posted: Mon Sep 26, 2011 4:47 pm

I thought that my question was clear enough. May be there is some problem in expressing. I will search the forum and see if i get any thing that can help me.
Thank you

enrico-sorichetti · Posted: Mon Sep 26, 2011 4:56 pm

the initial posts hinted two files with a single record and no key

as an hint
use the JOINKEYS to couple the records with the same key,
after that a date difference from two columns of the same record would me mopre than enough

Bill Woodger · Posted: Mon Sep 26, 2011 5:02 pm

Your question is clear enough if all the information that you know is known.

Let me try this:

I have a task whereby I have to find the difference in the dates between records on two different PS datasets. I need the difference as a number of days.

The records each have a key. The date is in the form CCYYMMDD.

I can do all the coding to match the records in the datasets, but I don't know how to do the date subtraction with the dates in two different files.

Does anyone have any pointers, please? I can/cannot use xTOOL. I can/cannot use more than one STEP. I do/do not have a SyncSort manual available. (delete as applicable).

Ketan Varhade · Posted: Mon Sep 26, 2011 5:37 pm

I know how to use join keys. I have written that much of code to match the file on the key feild position, while writing the outrec I am not able to calcluate the difference. I did some search on DATE in syncsort but I didnt get any info that can help me.
current code(sysin) i am able to write till reformat fields.