Look at the RANGE option in PROC IMPORT.  Are the ranges a consistent size, ie always 3 rows?   @Vivekkaushal wrote: I have excel data in the given format. What code do I write to make it a singe table with Agent id as one of the fields. Attached file to show desired format   Agent 1               Name Total  Calls Total Hrs AWT                         Agent 2               Name Total  Calls Total Hrs AWT                                                         Agent 3               Name Total  Calls Total Hrs AWT           ... View more

That's really a logic issue first - what do you want to do with the multiple ID?    1. Account for it in the model somehow 2. Aggregate the data to have a single obs per time  3. Pick one of the obs per time and use that one, ie first or last     ... View more