About kevin_123

kevin_123 · ‎07-19-2012

Hi Tapas. I recommend doing two passes if you do know how many duplicates you can encounter. First to create your string and the second pass to add it back to the original records data inds; input custno prod $ acc_flag $ bal ; datalines; 111 a1 qaz 10 111 b1 wsx 11 222 c1 wsx 233 333 d1 grw 251 444 e1 dc 25 444 f1 vefw 1231 444 g1 wefr 36 555 h1 bdfgh 615 666 i1 qe 767 777 j1 erg 31 777 k1 eth 472 777 l1 ret 251 777 m1 dfwef 3761 888 p1 ffef 36 ; run; proc sort data=inds; by custno prod; run; data tmp_ds (keep=custno prod_con acc_con); set inds; by custno; length prod_con acc_con $50.; retain prod_con acc_con; if first.custno then do; prod_con =""; Acc_con = ""; end; prod_con = trim(prod_con) || trim(prod); acc_con = trim(acc_con) || trim(acc_flag); if last.custno then output; run; data final_ds; merge inds tmp_ds; by custno; run;

kevin_123 · ‎07-13-2011

Hi Littlestone. Are you trying to read the data conditionally, based upon a value in a specific field ? Or is the data in reverse order in the flat file? If you are trying to read the data based upon a field within the data, such as length then use the @@ to "pause" reading the file. data results; input @1 ID $3. @4 Sex $1. @5 Age 2. @@ ; if age < 10 then do; input ; * no height or weight for children under 10; end; else do; input @7 Height 3. @10 Weight 3.; end; cards; 001F36175180 001F01 ; run; Otherwise,, just read in the whole line and use the reverse function; Cheers.

Online Status	Offline
Date Last Visited	‎09-01-2015 07:11 AM

Re: concatenate through group by using SAS or PROC SQL, urgent help ne...

is it possible to read data from right to left?

Re: concatenate through group by using SAS or PROC SQL, urgent help ne...

is it possible to read data from right to left?