I have two data frames with a number of common variables that I wish to put into "long format".
   
  The first contains the variables
   
  es(Csales)
 [1] "terr"   "Dec.02" "Jan.03" "Feb.03" "Mar.03" "Apr.03" "May.03" "Jun.03"
 [9] "Jul.03" "Aug.03" "Sep.03" "Oct.03" "Nov.03" "Dec.03" "Jan.04" "Feb.04"
[17] "Mar.04" "Apr.04" "May.04" "Jun.04" "Jul.04" "Aug.04" "Sep.04" "Oct.04"
   
  For this the following code works fine.
   
  Csall<-reshape(Csales, idvar = "terr", timevar = "month",
  varying = list(c("Dec.02","Jan.03","Feb.03","Mar.03",
  "Apr.03","May.03","Jun.03","Jul.03","Aug.03","Sep.03",
  "Oct.03","Nov.03","Dec.03","Jan.04","Feb.04","Mar.04",
  "Apr.04","May.04","Jun.04","Jul.04","Aug.04","Sep.04",
  "Oct.04")),direction = "long")
   
  The second dataset contains the variables
   
  es(Ccalls)
 [1] "TERRITORY"             "REGION"                "ACTIVITY_TYPE"        
 [4] "CONTACT_TYPE"          "TARGETED_FLG"          "CONTACT_GRADE"        
 [7] "CONTACT_PR_SPECIALITY" "UBM"                   "DEC02"                
[10] "JAN03"                 "FEB03"                 "MAR03"                
[13] "APR03"                 "MAY03"                 "JUN03"                
[16] "JUL03"                 "AUG03"                 "SEP03"                
[19] "OCT03"                 "NOV03"                 "DEC03"                
[22] "JAN04"                 "FEB04"                 "MAR04"                
[25] "APR04"                 "MAY04"                 "JUN04"                
[28] "JUL04"                 "AUG04"                 "SEP04"                
[31] "OCT04"  
   
  Trying the following code on this set produces an error
   
  Ccall<-reshape(Ccalls, idvar = "TERRITORY, timevar = "MONTH",
  v.names = list(c("TERRITORY","REGION","ACTIVITY_TYPE","CONTACT_TYPE",
  "TARGETED_FLG","CONTACT_GRADE","CONTACT_PR_SPECIALITY","UBM")),
  varying = list(c("Dec.02","Jan.03","Feb.03","Mar.03",
  "Apr.03","May.03","Jun.03","Jul.03","Aug.03","Sep.03",
  "Oct.03","Nov.03","Dec.03","Jan.04","Feb.04","Mar.04",
  "Apr.04","May.04","Jun.04","Jul.04","Aug.04","Sep.04",
  "Oct.04")),direction = "long")
   
  Where am I going wrong here?
   
  Any help would be greatly appreciated.


Kind regards


Dr Graham Leask
Economics and Strategy Group
Aston Business School
Aston University
Aston Triangle
Birmingham
B4 7ET

Tel: Direct line 0121 204 3150
email g.leask@aston.ac.uk
	[[alternative HTML version deleted]]

