length name user no temp $ 40; data want; input temp $300.; cards; ajay|ku mar|2656|         muni|carr om|455676|         ajay|kumar|9890|vijay|kumar|          589|user|flow|568 run; data want1(keep=name user no); set want; length name user no temp $ 40; input a $1. @@; retain temp name user no; if a ne '|' then temp=cats(temp,a); else do;          count+1;          select(mod(count,3));           when (1) name=temp;           when (2) user=temp;           when (0) do; no=temp;output;end;          end;          call missing(temp);        end; return; last:  no=temp;output; datalines; ajay|ku mar|2656|         muni|carr om|455676|         ajay|kumar|9890|vijay|kumar|          589|user|flow|568 ; run; proc print; run; Actually this contains datalines reading from the same dataset actually i wnat to read the data intially to a dataset and from that dataset i want to read to another dataset as you have written this code by using datalines as my data is huge i cant keep the datalines... ... View more

data temp; infile cards missover truncover; input sclurp $32000. ; cards; ajay|ku mar|2656|34        muni|carr om|455676|56         ajay|kumar|9890|78|vijay|kumar|589|90| user|flow|568      |67 run; data temp2; /*input @;*/ set temp; sclurp=cats(of sclurp ); retain sclurp ''; if not mod(countw(sclurp,'|'),4) then   do;    do i=1 to countw(sclurp,'|') by 4;     name=input(scan(sclurp,i,'|'),$32.);     user=input(scan(sclurp,i+1,'|'),$32.);     no=input(scan(sclurp,i+2,'|'),8.);     age=input(scan(sclurp,i+3,'|'),8.);     output;    end;    sclurp='';   end; drop sclurp i; run; proc print; run; Tryed by this way it was getting errors ... View more

data temp; infile cards missover truncover; input sclurp $32000. ; cards; ajay|ku mar|2656|34        muni|carr om|455676|56         ajay|kumar|9890|78|vijay|kumar|589|90| user|flow|568      |67 run; data temp2; /*input @;*/ set temp; sclurp=cats(of sclurp ); retain sclurp ''; if not mod(countw(sclurp,'|'),4) then   do;    do i=1 to countw(sclurp,'|') by 4;     name=input(scan(sclurp,i,'|'),$32.);     user=input(scan(sclurp,i+1,'|'),$32.);     no=input(scan(sclurp,i+2,'|'),8.);     age=input(scan(sclurp,i+3,'|'),8.);     output;    end;    sclurp='';   end; drop sclurp i; run; proc print; run; I am trying by this way i am not getting the output i wnat in this way i want the inital data in to a dataset as i cant give datalines as my data is huge ... View more

it is '13'X i am thinking as i searched in net it has given as.. ... View more

I have tryed ur code but the linkages are not getting correctly and i am running this on SERVER .. ... View more

I have tryed art code but the linkages are not getting correctly and i am running this on SERVER .. ... View more

Thqs Ksharpthe code was working but it was taking time as i am having 8 crors of data can u help me to reduce the time ... View more

obs a1 a2 a3 a4 a5 a6  R_id 1 1 a 5 7 8 9 1 2 . . . . . . 2 3 11 b 12 13 14 15 3 4 9 c 100 101 102 103 1 5 104 c 106 107 108 109 1 obs=1 all are unique so r_id=1 obs=2 all are unique so r_id=2 obs=3 all are unique so r_id=3 obs=4 as a5 of obs1 and obs 4 of a1 having link r_id=1 obs=5 as a2 of obs4 and obs 5 having linkage so r_id=1 ... View more

obs a1 a2 a3 a4 a5 a6  R_id 1 1 a 5 7 8 9 1 2 . . . . . . 2 3 11 b 12 13 14 15 3 4 9 c 100 101 102 103 1 5 104 c 106 107 108 109 1 obs=1 all are unique so r_id=1 obs=2 all are unique so r_id=2 obs=3 all are unique so r_id=3 obs=4 as a5 of obs1 and obs 4 of a1 having link r_id=1 obs=5 as a2 of obs4 and obs 5 having linkage so r_id=1 sory i have corrected it ... View more

Thqs Linus it worked ... View more

Thqs ksharp but how can i do the same for character varaibles ... View more