(no subject)

Hi Dila,

Try:
transform(melt(dat,id.var=c("Day","Year")),Month=match(variable,month.abb),Amount=value)[,-c(3:4)]
A.K.

Dear Arun,

Thank you so much for your help..but this command doesn't apply if I have more than one id. variables such as follows:

dat <- read.table(text="Day Year Jan Feb Mar Apr?
? 1 ?2012 0 2.5 0.5 2 ?
? 2 ?2013 0 6.5 0 29
? 3 ?2013 0 9.5 0 0?
? 4 ?2013 0 0 8 0.5?
? 5 ?2013 0 5 0.5 110.5 ?
? 6 ?2011 0 4 3.5 22 ?
? 7 ?2012 11 0 12.5 3.5
? 8 ?2011 0 5 8 36.5",sep="",header=TRUE)
library(reshape2)


I have try this but it doesnt work

res <- transform(melt(dat,id.var="Day"),Month=match(variable,month.abb),melt(dat,id.var="Year"),Amount=value)
res

Could you help me on this one..Sorry for asking again and again..
Thank you so much.

Regards,
Dila