Page 1 of 1

concatenate 3 input records in different ds into one record

Posted: Thu Mar 21, 2013 11:21 am
by bhargavi_ns
I want to concatenate 3 input records in different dataset into one record in output dataset:

input1:
99abcdefghijklmno

input2:
123456789

input3:
987654321

Required output:
99abcdefghijklmno 123456789 987654321

Posted: Thu Mar 21, 2013 11:59 am
by bhargavi_ns
I am able to do this using SAS.
But need to try using ICETOOL or SORT.

Posted: Thu Mar 21, 2013 3:08 pm
by Anuj Dhawan
Please have a look at RESIZE parameter for DFSort.

Posted: Fri Mar 22, 2013 4:38 am
by William Collins
What are the RECFMs and LRECLs of your inputs? You have one record on each file?

Posted: Sun Mar 24, 2013 2:27 am
by tamilselvan.sampath
You can use joinkeys fuction in dfsort

Posted: Sun Mar 24, 2013 3:29 am
by William Collins
tamilselvan.sampath wrote:You can use joinkeys fuction in dfsort
Possibly, but probably not necessary, and you don't know for sure one way or the other without knowing the information already asked, and not yet supplied.