Hello All, I have a raw file with data like this: H 1095 NJ 06DEC84 C 01DEC11 $45.0 C 01AUG11 $37.5 H 1096 CA 01SEP83 C 01JUL11 $156.7 H 1097 VG 07JUL74 C 01FEB11 $109.5 H 1099 OT 13FEB79 C 01Mar11 $45.0 C 01May11 $45.0 H 1202 CA 01JAN81 C 01May11 $37.0 C 01Oct11 $45.0 C 01Feb11 $109.5 H 1090 PT 01DEC11 C 01MAR11 $45.0 C 01MAY11 $45.0 representing client ID, State, DOB and transaction details. I need the output to be like this: ClientID State DateofTransaction Amount 1095 NJ 01DEC11 $45.0 1095 NJ 01AUG11 $37.5 1096 CA 01JUL11 $156.7 1097 VG 01FEB11 $109.5 1099 OT 01Mar11 $45.0 1099 OT 01May11 $45.0 1202 CA 01May11 $37.0 1202 CA 01Oct11 $45.0 1202 CA 01Feb11 $109.5 1090 PT 01MAR11 $45.0 1090 PT 01MAY11 $45.0 I have used the following: Data Transact; infile hca dlm = ' ' missover lrecl=100; input @3 ClientID$ 4. @8 State$ 2. #2 @3 DOT Date7. @11 Amount$; format DOT Date7.; run; And the result I'm getting is attached herewith. Now I know I need to do something with the repeated transactions as in more than one transaction for each client. What should I do?
... View more