Hi, I have a requirement where I have to combine the data present in the same variable on different datasets into a single variable. The format of the variables is character. The records are linked by a particular id. So for a particular id if we have 5 rows and each of the five rows contain a char variable called LINe , then we need to produce one record which contains the two variables id and LINE. Here LINE is a combination of the LINE variable from the five records which are linked by the id. Given below is an example of the data. 100 abcdefghijkollldsdksjd 100 djsjdklsjdksdlsldklskdsld;sk;dks; 100 djskdjsldjlsdjlsdjlsdljskdjskdjskdioeioeoeoe 100 jksldksldklsldklsdksldksldklskdls 100 djsldksldksldklsdk;d;;adskldkasldklsdksdkl;skdsk 200 djksldklskdlskdls\ 200 uuuuuuuuuuuuuuuuuu Output required 100 abcdefghijkollldsdksjddjsjdklsjdksdlsldklskdsld;sk;dks;djskdjsldjlsdjlsdjlsdljskdjskdjskdioeioeoeoejksldksldklsldklsdksldksldklskdlsdjsldksldksldklsdk;d;;adskldkasldklsdksdkl;skdsk 200 djksldklskdlskdls\uuuuuuuuuuuuuuuuuu Thanks
... View more