Hi everyone,

I am sure there must have been a way to make the following codes more compact but no matter how I tried, I failed to do it. Could anyone help me?
"
egen worked_episode1=rowtotal(jobepisode1)
egen worked_episode2=rowtotal(rsemp_jobepisode1 rsemp_jobepisode2 )
egen worked_episode3=rowtotal(rsemp_jobepisode1 rsemp_jobepisode2 rsemp_jobepisode3)
egen worked_episode4=rowtotal(rsemp_jobepisode1 rsemp_jobepisode2 rsemp_jobepisode3 rsemp_jobepisode4)
.......
........
........
egen worked_episode43=rowtotal(rsemp_jobepisode1 rsemp_jobepisode2 rsemp_jobepisode3 rsemp_jobepisode4..............rsemp_jobepisode43)
"
Many thanks!!