BookmarkSubscribeRSS Feed
Vivekkaushal
Calcite | Level 5

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   
    
NameTotal  CallsTotal HrsAWT
    
    
    
Agent 2   
    
NameTotal  CallsTotal HrsAWT
    
    
    
    
    
    
    
Agent 3   
    
NameTotal  CallsTotal HrsAWT
    
1 REPLY 1
Reeza
Super User

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
       

 

Ready to join fellow brilliant minds for the SAS Hackathon?

Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.

Register today!
How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 1 reply
  • 543 views
  • 0 likes
  • 2 in conversation